TM1 Forum

Posted: **Tue Feb 09, 2021 9:40 pm**

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.

Posted: **Wed Feb 10, 2021 8:51 am**

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

Posted: **Thu Feb 11, 2021 10:39 pm**

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."

TM1 Forum

Using Rules to transfer data into cube with less dimensions

Using Rules to transfer data into cube with less dimensions

Re: Using Rules to transfer data into cube with less dimensions

Re: Using Rules to transfer data into cube with less dimensions