Hi guys
on SSAS 2012, my cube has this Dimension "Policies by Country" with 5 hierarchy layers
Country -> Policy Group -> Policy -> Insured -> Claims and Benefits
Now I want to count the Insureds, who have bookings on a measure called "EXPOSURE" on the "Claims and Benefits" Level. This selection should be controlled by the currentmember.
In Essbase, the statement is rather simple:
NonEmptyCount ([All Policies by Country].CurrentMember.Leaves,[Exposure])
Is there a way to do this in SSAS?
This works no matter where the user is positioned in the hierarchy....