dbTalk Databases Forums  

Dimension selection

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


Discuss Dimension selection in the microsoft.public.sqlserver.olap forum.



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

Default Dimension selection - 08-10-2006 , 11:17 AM






I have a cube, we are using Panaroma cube browser, Where user can select
multiple value for a dimension, Example in calendar, they can select 2006
and 2005 same time,
I want to know in calculated member, how many dimension values selected.

Example :

Calendar

2002,2003,2004,2005,2006,2007.....


If user select 2002,2003 and 2004, Expected result in Calculated member is 3
If user select 2005,2006 , Expected result in Calculated member is 2

Any help please.

thanks in advance

kalyan


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.