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