Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Non Empty Counting Descendants SSAS vs. Essbase Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 4:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 2:39 AM
Points: 1, Visits: 5
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....

Post #1462543
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse