Using Rules to transfer data into cube with less dimensions

[vasek1192]

Hi,

I am attempting to transfer Amount data between cubes with target cube having one less dimension.

Source Cube Dimensions: Product, Total_Amount
Target Cube Dimensions: Product, Months, Measures

Measures among others contains Amount element.

Thanks to more than generous help from other users here I now know plenty of ways to this using TI and I know how to use rules to transfer data the opposite way (Cube with more dim -> Cube with less dim). But I don't exactly know how to do it this way.

Any help would be appreciated.

[Elessar]

This starts to remind me a "1000 answers to "Measure tower height using barometer" question" meme =)

Using a rule here will be much simpler than using a TI process:
Target cube:

Code: Select all

SKIPCHECK;
[] = N: DB('Source Cube', !Product, ATTRS(some mapping with source cube measures));

Source cube:

Code: Select all

SKIPCHECK;
FEEDERS;
[] => DB('Target Cube', !Product, 'Months total', ATTRS(some mapping with target cube measures));

[vasek1192]

Thanks for the reply to clarify, the barometer meme is not too far off. I entered a new job and I am being trained in TM1. I was given series of tasks to do and after I complete them the usual extension of my assignment is: "Find other ways to accomplish this and implement it. See you tomorrow."