Unable to display alias attribute in MDX

[Francois]

Hi there,

I'm struggling to find a way to display an alias for the following MDX. The goal of the MDX is to retrieve accounts which is specific to an entity from a TB load and only 'Active' accounts.

FILTER(TM1FILTERBYLEVEL(DESCENDANTS([Account].[All Account]) , 0) , [lkp.Account Setup].(STRTOMEMBER("[Entity].[" + [mod.UserInterfaceSettings].(STRTOMEMBER("[}Clients].[" + Username + "]"),[UserInterfaceObjects].[Entity],[measure_mod.UserInterfaceSettings].[String]) + "]"),[measure_lkp.Account Setup].[Active]) = "TRUE")

The MDX is used in PAW view, with PAW you are unable to switch on the alias without replacing or updating the current SET which overwrites the MDX code used for a dynamic report.

Any idea how to retrieve the alias of the account dimension for the relevant accounts?

Thanks.

[MarenC]

Hi,

Simplest thing to do would be to make this a permanent subset and use the alias with the subset. Then reference the subset in PAW

Maren

[Francois]

Hi Maren

Thanks.

This is an option but we have many entities each with its own maintainable set. It defeats the purpose where you know have to create multiple static sets, maintain them without creating locking, and then create another MDX set to reference the static sets to make your books and reports 'dynamic'.

Francois

[MarenC]

Hi,

Why would the subset have to be static? You just pop the MDX you posted into the new subset, save that subset and use an alias with it.
Then in PAW use this subset in the report.

Maren

[Francois]

Hi Maren

This MDX is currently saved as a dynamic subset. I've tried switching on the Alias PAW set editor but you cannot commit the change to the current set without overwriting the MDX set.

Below is the view of the set editor in PAW.

PAW Set editor

Screenshot 2023-06-26 at 12.49.04.png (103.02 KiB) Viewed 1486 times

I might have it wrong, but you cannot update a set by switching on the alias without updating/replacing the current set. This in turn changes it to a static set of accounts. You can switch on the alias on A but it only displays it in the 'Available members' section. The 'Current set' can only be updated by inserting or overwriting the current set with B.

Francois

[MarenC]

Hi,

Have you tried saving the subset in architect using the alias or alternatively via a ti process, using SubsetAliasSet?

Maren

[Francois]

Hi Maren

The architect option did not work however, your suggestion of using SubsetAliasSet was greatly appreciated.

Thank you!

Francois