dbTalk Databases Forums  

Re: Dimension Sorting

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


Discuss Re: Dimension Sorting in the microsoft.public.sqlserver.olap forum.



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

Default Re: Dimension Sorting - 10-23-2005 , 06:07 PM






Quote:
is there a way to define that order ?
You can define the order in the MDX statement

{National,Potential.[Very High]:Potential.[No Potential]}

But I assume that you want the members to be in the correct order when
you drag the dimension onto a pivot table control of some sort. I have a
couple of suggestions, you could try.

Both involve creating a real "national" member in the dimension
(obviously no data will link to this one directly) You can then setup
the sort order in the dimension table as you would normally

Then try setting up either a calculated cell or a custom rollup formula
on your "national" member. If it were me, I would probably explore the
calculated cell option first.

HTH

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell


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.