TI process: Force elements sequence in source view

[holger_b]

Dear forum colleagues,

I am trying to populate a number of cells in a certain way, datasource is a cube view. It would help a lot if I could force the contents of the source view to appear in a certain sequence. In other words, I would like to iterate through all cells which are solely different by the version element. And finally the version elements will need to be arranged in a certain order.

In SQL, I would use "ORDER BY" - is there a sophisticated way of constructing a view in a way that will do what I have in mind?

Thank you
Holger

[tomok]

You can use an MDX query against a cube as your data source and there is an equivalent ORDER command in MDX. I don't really have much experience using that so can't provide any assistance. You can also try building your view with sorted subsets. I don't know how complicated your requirements are for the sorting order but that is likely your best bet.

[Steve Rowe]

You might want to try and approach the problem from another direction.

From my experience anything that requires data to be processed in a particular order is doomed and depending on the detail will require significant maintenance.

You will probably be better off breaking your logic in to smaller steps, it might be more inefficent but I'll take inefficent over detailed hand-holding everytime.

Can't help much with the detail....
Cheers,

[holger_b]

Dear both,

thank you for caring. In the meantime I came to the conclusion that my approach was not too smart so I decided to redesign the whole thing.

Thank you
Holger