CurrentMember Name Property not working... -
01-12-2006
, 11:56 AM
Using Iif statement along with currentmember.name is producing strange
results
There are 4 "With Member" statements in the below MDX query. Each of
these is meant to return the Current Member Name (or UniqueName).
** Iif( ... ).UniqueName statement working
[Measures].[UniqueName]
** Iif( ... ).Properties("Name") does not work for calculated
members but works for regular members [Measures].[PropertyName]
** Iif( ... ).Name statement is not working
[Measures].[DisplayName]
** CurrentMember.Name statement is working
[Measures].[ControlTest] (DisplayName and ControlTest should produce
same results)
With
Set [ChangeRangeList] as 'AddCalculatedMembers([Paid Change Range].[All
Change Range].Siblings)' ---includes regular and calculated members
Member [Measures].[UniqueName] as 'StrToMember(iif("TEST" = "TEST",
"[Paid Change Range].currentmember","[Incurred Change
Range].currentmember")).UniqueName'
Member [Measures].[PropertyName] as 'StrToMember(iif("TEST" = "TEST",
"[Paid Change Range].currentmember","[Incurred Change
Range].currentmember")).Properties("Name")'
Member [Measures].[DisplayName] as 'StrToMember(iif("TEST" = "TEST",
"[Paid Change Range].currentmember","[Incurred Change
Range].currentmember")).Name'
Member [Measures].[ControlTest] as '[Paid Change
Range].currentmember.Name'
SELECT
{ [Measures].[UniqueName], [Measures].[PropertyName],
[Measures].[DisplayName], [Measures].[ControlTest] } on columns,
[ChangeRangeList] on rows
FROM WkClms
I have also added solve_order=100 to my .Name statement but that
doesn't help... I thought it was stuck on whether to resolve calculated
member in With Set or in With Member first. But that doesn't make
sense because then why would [Measures].[ControlTest] work? Anyway,
it didn't help.
Note -- you can probably see this but the Iif statement will use the
first argument everytime
Any advice appreciated.
Thanks,
Joel |