TM1 Forum

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

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);

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.