Actual and planning cubes different member names problem

[abcuser]

Hi,
using Cognos TM1 v9.5.2 on Windows I have several cubes: orders, sales, manufacture etc. All of cubes have 'actual' data. Now I got an end-user requirement to add 'plan' data into each of this cubes. Because planning data are not available at the same level I need one cube for actual data and one cube for plan data. Then add rule at actual data cube to pull data from plan. So far no problem.

Plan cube has three dimensions: time, product and measure. All other cubes (order, sales etc) have the same dimensions plus some additional dimensions. What I see the problem now is that each of this cubes have different member names in time dimension. For example:
- order cube hierarchy: "TIME OF ORDERING" --> "ORDER 2012" --> "ORDER JAN 2012"
- sales cube hierarchy: "TIME OF SALES" --> "SALES 2012" --> "SALES JAN 2012"
- plan cube hierarchy: "TIME" --> "2012" --> "JAN 2O12".

Now when using rule in order cube to get 'plan quantity' measure from plan cube I have written the following rule:
DB('PLAN', !ORDER_PRODUCT, !ORDER_TIME, 'PLAN QUANTITY');

I understand that above formula for measure 'plan quantity' returns only zeros into order cube, because time dimension member names do not match between plan and order cubes. How to solve this problem? Is there anyway I can add prefix into above formula like "ORDER" prefix? See attached picture of simple sample of order and plan cube.

P.S. One of solution is to create one plan cube for every existing cubes. So 'plan order' cube for 'order' cube, 'plan sales' cube for 'sales' cube, 'plan manufacture' cube for 'manufacture' cube etc and make sure that plan cube has exact members as actual cube. But I would like to avoid this plan cube duplication if possible.
Thanks

[Jeroen Eynikel]

- Yes you can use a prefix

instead of !order time you can put 'ORDER ' | !order time

Keep in mind that you would need to get rid of the 'order' part in your feeder though. So when feeding from the other cube you will need to use a subst function to get rid of the order part.

- Another option would be to create aliases on both dimensions. (Which is a solution I would personally prefer)

Jeroen