dbTalk Databases Forums  

CurrentMember Name Property not working...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss CurrentMember Name Property not working... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joel Barish
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.