SAC - sort dimensions members using a property (in a table)

[former_member767054]

Hi everybody.

I'm on a payroll planning topic, and I'm trying to sort members of a dimension (pay scale) according to a property.

(I've added the property for this particular purpose)

Please find below some columns of my salary "grid".

"Tri" (sort) is the property of "Compte" (Account).

I know I have the "custom sort" feature, but it means making the sort by hand (there is 160 members).

This sort is important because when people get promoted they "jump to the next column".

I'd like something efficient and clever as you certainly guess 🙂

(I've found this : https://userapps.support.sap.com/sap/support/knowledge/en/2830016

but this is complicated and heavy for a pretty standard requirement).

Thanks in advance for your advices & regards.

Guillaume P.

[Jay_Gandhi]

Hi there,

In the table you could insert the property directly into the table (via the Builder Panel, you can select the arrow next to the dimension the property belongs to and then tickmark the property itself).

Once the property is in the table, you can enable 'custom sort' and sort the property members accordingly as you wish.

Jay

[Oleks_Master]

Hello Jay.

Are you sure it's possible to sort property members? I cannot find this function.

Br, Oleksandr

[former_member767054]

Thank you Jay.

Your advice works fine.

The ability to insert a property as a dimension is available only if you are not displaying unbooked data, but in my case this is OK.

Any chances to "hide" the "Tri" property row without breaking the sort ?

Thanks again.

G.