I’m trying to build a filter on the Sprint dimension that would be in Page.
I would want the filter to give me only Sprint that have a higher key then 90 ([Sprint].CurrentHierarchyMember.Key>90)
I’m pretty sure I would need an aggregate or a Case When, but I don’t know how to set them up.
Could someone help me please?
I recommend using the Aggregate() function to group the Sprint dimension “Sprint” level members and the Filter() function to retrieve desired members. See the suggested formula below:
[Sprint].CurrentMember.Key > 90
See the eazyBI documentation page for more details on the suggested functions - MDX function reference.
Roberts // firstname.lastname@example.org