Sort-Function in TI

[SADELMA]

Hi all,

is there a way to sort a subset inside of a TI-Process? I create a Subset in the process for example with values 1 - 3. The result is 3 - 2 - 1. I want the result in the order 1 - 2 - 3. How can i do that inside the TI-Process?

Thank you in advance!

Greetings

[Marcus Scherer]

Without knowing details and what your source is, you may force TI to loop through your source data set from the last row to first row instead of first to last. You may determine the number of rows in a first run and then create a backward loop where you create your subset.

[Steve Rowe]

You could create the subset with MDX which would give you access to sorting functionality.

Alternatively you could process the subset a second time using the same code, which should reverse the order I think.