dbTalk Databases Forums  

Getting the count of the lowest level (MDX formula)

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


Discuss Getting the count of the lowest level (MDX formula) in the microsoft.public.sqlserver.olap forum.



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

Default Getting the count of the lowest level (MDX formula) - 08-09-2004 , 03:01 AM






Hi,

I want to retrieve a count of a level.

All Region (1st level)
Asia (2nd level)
China (3rd level)
Singapore
Taiwan
Europe
Belgium
France
Spain
Italy
America
Canada
US

Depending on where i stand i want the count of the counrties. So like when i
am on belgium the count should be 1 (because this is the lowest level). When
i am on America the count should be 2 (because there are 2 countries in
America)
When i am on All Region than the count should be 9 (because there are 9
countries in total). How can i get this?

I used something like this:

Count({descendants([Region].Currentmember)})

or anything that comes close to this, but it also includes the second level
and in this case all levels, so the count is 13 .

Anyone can help me out with this?

Thnx

Stan


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.