Hi All,
I have not done a drillthrough for long time and I dont seem to find my info.
I am drilling from 1 cube to another where the dimension names are different.
So cube 1 has a dimension called COMPANY (drill from)
and Cube 2 has a dimension called GR-Company (drill to)
My drillthrough works for all = dimensions, but I know I have to write a command in the process to say that company = gr-company.
I dont seem to find the right syntax.
Thanks
Micheline
Drillthrough from 1 cube to another
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
Drillthrough from 1 cube to another
Thanks
Micheline
Micheline
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
Re: Drillthrough from 1 cube to another
Hi All,
I finally found a way. I dont know if it is the best way, but it works for me.
As I see that many people read but did not answer, here is what I did:
In the drill Process, i created the view of the drill-to cube using a subset of the dimension that has a different name.
in the prolog, I recreate that subset using the parameter (coming from the Drill-from cube).
Something like below:
SubsetDeleteAllElements('RollingPeriods', 'zdrill');
period = subst(RollingPeriods,5,6);
Subsetelementinsert('RollingPeriods','zdrill',period,1);
I finally found a way. I dont know if it is the best way, but it works for me.
As I see that many people read but did not answer, here is what I did:
In the drill Process, i created the view of the drill-to cube using a subset of the dimension that has a different name.
in the prolog, I recreate that subset using the parameter (coming from the Drill-from cube).
Something like below:
SubsetDeleteAllElements('RollingPeriods', 'zdrill');
period = subst(RollingPeriods,5,6);
Subsetelementinsert('RollingPeriods','zdrill',period,1);
Thanks
Micheline
Micheline
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Drillthrough from 1 cube to another
This is pretty much how it's done. There are a number of threads about drill through (and some about issues that popped up with PA) already on the Forum. May have been why no one answered.
Ty
Cleveland, TN
Cleveland, TN