Drilldown to a view using Attribute

Post Reply
mnasra
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

Post by mnasra »

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
Thanks
Micheline
lotsaram
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

Post by lotsaram »

Account = DimensionElementPrincipalName('Account', Account);
mnasra
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

Post by mnasra »

THANKS a million. IT works perfectly-
I did not know the Principalname comand.
Thanks
Micheline
Post Reply