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

MDX help - counting tuples with a given member Expand / Collapse
Author
Message
Posted Tuesday, May 28, 2013 10:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 2, 2013 1:49 AM
Points: 116, Visits: 289
Is there a way, MDX, to count the number of tuples in a set that have a given member.

For example

{ (a1, b1) , (a1, b2) , (a1, b3) , (a2, b1) }

such that given member a1 would yield a count of 3 (the first three tuples in the set)
Post #1457442
Posted Wednesday, May 29, 2013 9:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:12 PM
Points: 46, Visits: 129
try something like this

SELECT NON EMPTY {[Measures].[b1/b2/b3]} ON 0,
NON EMPTY {[a1].ALLMEMBERS)} ON 1
FROM CUBE_NAME
Post #1458025
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse