dbTalk Databases Forums  

Multiple Selections for DefaultMember

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


Discuss Multiple Selections for DefaultMember in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
K. Bryan
 
Posts: n/a

Default Multiple Selections for DefaultMember - 09-20-2006 , 04:16 PM






I'm working with SSAS 2005 and was wondering, is it possible to have
multiple selections for DefaultMember?

It seems like thru the UI you are either able to select ALL or one. Is
there a way to write a MDX expression to select multiple?

Thanks in advance.



Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: Multiple Selections for DefaultMember - 09-20-2006 , 05:56 PM






simple answer: no
a default member is 1 member only

if you always select 2 members (or more) then group them into an hierarchy
and select this grouped member as the default.
maybe you can setup the default member on a calculated member in a cube, but
I have not tested this.
(you have to change the defaultmember in the cube himself, you can't do it
in the dimension himself)



"K. Bryan" <notme (AT) kbryan (DOT) net> wrote

Quote:
I'm working with SSAS 2005 and was wondering, is it possible to have
multiple selections for DefaultMember?

It seems like thru the UI you are either able to select ALL or one. Is
there a way to write a MDX expression to select multiple?

Thanks in advance.




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.