Order by Time desc ?

[twolf]

Hi,

tricky Problem (hopefully only for me ;-))
How can i change the order in my time-dimension, so the latest date could be seen as the first (above) entry?
E.g.
2002
2001
2000

and same in quarters, months and days.

Thx
Thorsten

 

[claws2rip]

try this:

Order([Product].[product category].members, [unit sales], Desc)

just substitute the "product" with your time dimension
and the "unit sales" with a measure in your cube

Sam

 

[twolf]

Hmpf, my fault,

first thanks for your suggestion, secound i forgot to describe, that i want to change the order in the time-dimension, when i open (!) the cube in the browser or user-frontend, like ProClarity.

Any idears?
Thorsten

 

[claws2rip]

i've never used proclarity so i cant offer suggestions using that product. for a browser or Vb front end u would have to use a MDX statement

here's a sample mdx statement
>>>>>>>>>>>>>>
select
{[Measures].[Store Cost],[Measures].[Store Sales],[Measures].[Store Profit Rate]} on columns,
Order([Product].[Product Department].members, [Measures].[Store Profit Rate], BDESC) on rows
from Sales
>>>>>>>>>>>>>>>>>>>>>>>>>>>

Sam

 

[OliverS]

I believe that you can order the dimension based on a key in the dimension table. This means that with the correct key you can make the dimension appear however you like in a client tool like Crystal Analysis Pro or ProClarity.

Oliver