TM1 Forum

Is it possible to feed Measures data to a cube that does not have a common dimension?

For example if I have a Payroll Budget cube with dimensions of Dept, Job Code and Earning and I calculate the GL Account and GL Dollars by business rules in the Payroll Budget Measures dimension, can I feed just the GL Account and GL Dollars to a cube that has GL Account as a dimension and GL Dollars as a Measure of a GL Budget Measures dimension?

Or do I have to export the data and populate the GL Budget cube using a TI process?

Thanks for your help,

...Tom

Yes, it's quite possible. In your feeders (and rule) you just need to hard code a few references. Or alternatively make use of attributes to map one dimension to another dimension.

There's an example of the syntax for a problem that's somewhat similar to your own in the Wiki: http://wiki.olapforums.com/index.php?title=TM1_Feeders (see the "Intercube feeders" section)

You might also want to have a look at the rule and feeder posts from the FAQ post.

Cheers,
Martin

Tom,

This can definitely be achieved. I have not tested this but saw a similar implementation in an application.

You would create an intermediary cube that would have dimensions from the other 2 cubes:
Dept, Job Code, Earning, GL Account, GL Budget Measures

In the Payroll Budget Cube:
Skipcheck;
Feeders;
['GL Dollars'] => DB('GL Calc',!Dept,!Job Code,!Earning,DB('Payroll Budget',!Dept,!Job Code,!Earning,'GL Account'),'GL Dollars');

In the Intermediary cube (GL Calc):
Skipcheck;
['GL Dollars'] = n: If( DIMNM('GL Account',DIMIX('GL Account',!GL Account)) @= DB('Payroll Budget',!Dept,!Job Code,!Earning,'GL Account'), DB('Payroll Budget',!Dept,!Job Code,!Earning,'GL Dollars'), STET );
Feeders;
['GL Dollars'] => DB('GL Calc',!Dept,!Job Code,!Earning,!GL Account,'GL Dollars');

In the GL Budget Cube:
Skipcheck;
['GL Dollars'] = DB('GL Calc','Dept','Job Code','Earning',!GL Account,'GL Dollars' );
Feeders;

Ankur

Thanks Martin and Ankur for your responses. I will try your suggestions and report back with my results.

Regards,

...Tom