Subset - Order of elements

Sylvana Neydek

Hi.

I am transferring our v11 subsets to v12. These are mostly account subsets with a specific order which is not the order of the dimension structure. This seems to be a big issue, if there is no possibility to give an order id.

I tried different ways:

• Insert the accounts into the BIFarmdEPMStaging.dbo.DEPM_MOD_ELEMENTINSUBSET table in the right order
• I created a table with the subsets, elements and oder id and then created query-based subsets with an order by statement on this custom table

But I always end up in a list  of accounts which is ordered by the structure of the dimension.

Any ideas or solutions for this? Anyone having the same issues?

Thanks in advance.

Sylvana

John Robson

Please try setting the hierarchized setting to false in list designer for your hyperblock:

Here my countries appear in definition order from my app engine process:


Here is the order from the process: