Fetch data between cubes with different granularity

[tm1green]

Hi there,

I have a question. How do I fetch data from one cube to the other with different granularity? Correct me if I wrong, the DB function seems to work only if both cubes are of same granularity.

My cubes are as follow:

Cube 1 contains period, department, position, version and measure dimensions.

Cube 2 contains period, department, version and measure dimensions.

How do I fetch data from Cube 1 into Cube 2? I don't need measures by position in Cube 2. FYI, measures are headcount, salary and bonus.

Thanks in advance.

[rmackenzie]

Use 'All Positions' or 'Total Positions' or whatever your top consolidation is in the Position dimension in the DB in cube 2. E.g.

Code: Select all

# rule in cube 2
['Headcount'] = N: DB ( 'Cube 1', !Period, !Department, 'All Positions', !Version, !Measure );

How you feed it is a different matter and you should beware the obvious route of feeding from All Positions as the overhead of doing so is proportional to size of the Position dimension.

Surely Cube 2 is doing something else other than summarising Cube 1? You'd do yourself a favour by mentioning whether it does or not in your question.

[tm1green]

Thanks for the reply. It works after adding Total Positions as parent to all the position codes in the Position dimension. The Position dimension consists of position codes at the same level without parent previously.