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
Drilldown to a view using Attribute
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
Drilldown to a view using Attribute
Thanks
Micheline
Micheline
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Drilldown to a view using Attribute
Account = DimensionElementPrincipalName('Account', Account);
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
Re: Drilldown to a view using Attribute
THANKS a million. IT works perfectly-
I did not know the Principalname comand.
I did not know the Principalname comand.
Thanks
Micheline
Micheline