TM1 Forum

Hi All,

I need to drill from a cube to another cube while passing some parameters;
Let's say I have 3 dimensions:
Account PPP-SSS
Principal : PPP
Secondary : SSS

Account is the concatenation of Principal and secondary:

In MY PROLOG of the DRILL process I wrote :
PRINCIPAL= subst(Account, 1,3);
SECONDARY =subst(Account, 5,3);

IT WORKS PERFECTLY - if I drill from a view where the account itself is showing -
IT DOES not work if the view is showing the ALIAS of the account.

(I tried some things, none of them worked- Like creating a new alias with exactly the account, and writing that Principal is the Subst(attrs....)- did not work, maybe because the command was in the prolog);

Any ideas?

thanks

Account = DimensionElementPrincipalName('Account', Account);

THANKS a million. IT works perfectly-
I did not know the Principalname comand.