dbTalk Databases Forums  

Can I use the command "isleaf" for this problem? Could somebody help me, please?

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


Discuss Can I use the command "isleaf" for this problem? Could somebody help me, please? in the microsoft.public.sqlserver.olap forum.



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

Default Can I use the command "isleaf" for this problem? Could somebody help me, please? - 12-21-2005 , 02:32 AM






Firs: I'm sorry for my english, I cannot speak english well. But I need
some help.

I have dimension, which could have been used only together with another
dimension. IF I use
this dimension separately, I need to see only null values, but in all
levels. My dimension has got three levels. I used calculated member and
this command: "IIF(ISLEAF([mydimension].currentmember), null,
myvalues)". But I can see null values only in the last level. Could
somebody give me some advice, How can I set analysis manager to show
null values in the all levels in this dimension. Thank you.


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.