If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Different sort order in one dimension?

Started by imnini, 17 Feb 2011 01:28:14 AM

Previous topic - Next topic

imnini

Hi all,

I have a cube with three dimension - time , area, product.

when the value of time dimension is 2005 ~ 2006 , the sort order of area dimension was like this:
UK, US, JAPAN, KOREA, CANADA

when the value of time dimension is 2007 ~ 2008 , the sort order will be set to:
KOREA, CANADA, UK, US, JAPAN

How could I accomplish this task? Should I reload the data in 2007 ~ 2008? So, I could use the sort-by-input function in TI.
Or, there are some other better ways to achieve this?
Thank you!

AWILDE

Could you create different Subset views for looking at different periods which had a different dimension order?