dbTalk Databases Forums  

Sorting OLAP data Cubes in Excel 2003

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


Discuss Sorting OLAP data Cubes in Excel 2003 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrew Alfaro via SQLMonster.com
 
Posts: n/a

Default Sorting OLAP data Cubes in Excel 2003 - 05-17-2005 , 03:49 PM






Hello,

I want to know if there is a way to Sort data from OLAP cube viewing in MS
Excel 2003???
Not by dimention name (ASC or DESC), by VALUES in cells (ASC or DESC)

Thanks!

--
Message posted via http://www.sqlmonster.com

Reply With Quote
  #2  
Old   
Andrew Alfaro via SQLMonster.com
 
Posts: n/a

Default Re: Sorting OLAP data Cubes in Excel 2003 - 05-17-2005 , 04:27 PM






Donīt Worry, I find some solution trying lot of options in Excel.
Must select a range from upper left to lower right, including the dimention
names and values. Then Data, Order.

Have a good day!

--
Message posted via http://www.sqlmonster.com

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.