Stop View Changing Dimension Order when adding a Subset

[John Hammond]

Help

I was trying to write some generalised TI code using views to load a cube when I realised that when you added a subset to the input view you changed the order in which the dimensions presented themselves in the TI code.

If you start with subset 'All' then the dimensions are in the order of the source cube. Say the dimensions are

A,B,C,D,E

If you assign a subset to C then it goes to the back of queue

A,B,D,E,C

If you then assign a subset to A then it goes to the back of queue and so on.

B,D,E,C,A

The problem occurs when you read your datasource into variables and it completely rejigs what is in each variable and you have to rename the variables or remap depending on your approach.

Is there any way to stop View Changing Dimension Order when adding a Subset?

Is there a sane reason why TI chooses to behave like this?

Regards

John

[Steve Rowe]

Hi John, IMO this is a bug and should not be happening. Are you starting with a view created from scratch in the TI or one that was created through the server explorer?

Cheers

[John Hammond]

HI Steve

I am using a view created in TI, but the behaviour seems to be the same if the view is created by hand.

NB the order of the dimensions in the view when used as TI input is the same order that is shown in the properties window on the right when you have selected a view on the left. This allows you to see the order in a view more easily than creating a TI process each time!

Thanks

John