dbTalk Databases Forums  

create a mutually exclusive dimension

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


Discuss create a mutually exclusive dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jason.saldo@gmail.com
 
Posts: n/a

Default create a mutually exclusive dimension - 05-23-2005 , 05:35 PM






Hello,

I have created several cubes useing MS analysis services. I have
become comfortable with the enviroment and have created some MDX
expressions. But My current problem is Forcing the user to choose one
leaf (if that is the right term) from the dimention. Is there a way to
turn the check boxes on a dimentions list to a radio list through
analysis services or should this be done client side? Currently
clients are using OWC placed in a web page as the cube browser...

If this is possible is also possible to not allow the All selection? I
looked at doing this through permisions but that would remove all
options from the dimension.

Thank you in advance for you help.



Reply With Quote
  #2  
Old   
jason.saldo@gmail.com
 
Posts: n/a

Default Re: create a mutually exclusive dimension - 05-24-2005 , 03:01 PM






Hey dummy!

Under the advanced dimension properties set "All Level" to "NO".


Reply With Quote
  #3  
Old   
jason.saldo@gmail.com
 
Posts: n/a

Default Re: create a mutually exclusive dimension - 05-24-2005 , 04:41 PM



note to self.

This does not give desired results in OWC...


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.