TM1 Forum

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.

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

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

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

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. 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

Hi,

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

Maren

Hi Maren

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

Thank you!

Francois