Sort level based hierarchy members in SAC stories

[former_member430684]

Hello!

I have hierarchy GL L1, GL L2 and GL Account. I also have columns GL L1 Sorting, GL L2 Sorting.

Is there any way to sort GL L1 by values in column GL L1 Sorting? (also GL L2 in same way).

I tried this:

Solution 1= Concatenating GL L1 Sorting+GL L1 - but output looks horrible with these numbers; is there a way to show only GL L1 values (like Analysis function in Webi trick where you say if formula=same formula, then display GL L1)?

Solution 2= I tried having GL L1 Sorting column before hierarchy in table, but I can't hide that column. Is there any way to hide column in tables in SAC stories?

Thank you in advance!

[mfoeken · Accepted solution]

Hi Iva,

Sorting in SAC is limited to Ascending / Descending or a Custom Order. You can't sort dimension values of dimension A based on dimension B. That is your requirement right? You can create a calculated dimension (based on the type of connection type (live/import) and data source) to define what to display with an IF statement.

Hiding a column in a table in SAC is not available. You can change the text color to white to hide the content. There is an existing improvement request which you can vote on https://influence.sap.com/sap/ino/#/idea/215672.

Kind regards,

Martijn van Foeken | Interdobs

[former_member430684]

Ok, thank you!