Tuesday, March 27, 2012

Getting the data associated with a (known) member

Greetings SSAS-ters,

Specifically, If I know the member (e.g. [DimensionX].[AttributeY].&[46E2]) whose values I am trying to get at, how do I get at that member's actual values.

Generally, this is an org. chart type parent-child hierarchy, and for everyone* (i.e. for each [DimensionX].[AttributeY].currentmember) in the hierarchy, I need to know their top-level manager's name, their 2nd-from-top-level manager's name, and so on.

Syntactically, I'm getting at the currentmember using:

subset(

hierarchize(

ascendants(

[Producer Hierarchy].[Agency Producer Name And Payroll Number - multicolumn].currentmember

) /* )ascendants */

) /* )hierarchize */

,1 /*subset startposition....*/

,1 /*...subset for 1 member in set....*/

) /* )subset */

I'd appreciate any help - thanks in advance!!

Gregg

Please note - I am wanting to SCOPE my result within a CREATE MEMBER CURRENTCUBE.[MEASURES].MyNewMeasure cube calculation, please.|||

In case anyone ever needs the same info, this problem eventually got figured out and solved by using:


ancestor([parent-child-hierarchy], <<numeric expression>>).name

No comments:

Post a Comment