Home > Archive > MS SQL Server OLAP > December 2005 > Can I use the command "isleaf" for this problem? Could somebody help me, please?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

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

2005-12-21, 3:24 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.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com