Imagine, you want a report chart by month and you want to get the issues that are still in “Open” . Then you can create a Calculated Measure using Tuples.

For example, to get from the Issues Created, the Issues in “Open” status. You can use this tuple:

([Measures].[Issues created],[Status].[Open])

Then, to get the Date creation of the Issues you can use this formula:

[Issue].CurrentMember.get(‘Created at’)

Then the formula to get the still Open issues for each month can be this:

    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod([Issue].CurrentMember.get('Created at'),
    ([Measures].[Issues created],[Status].[Open]) > 0
Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s