Using Rules to transfer data into cube with less dimensions

Post Reply
vasek1192
Posts: 28
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Using Rules to transfer data into cube with less dimensions

Post by vasek1192 » 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.

User avatar
Elessar
Community Contributor
Posts: 236
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Location: Russia

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

Post by Elessar » 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));
Best regards, Alexander Dvoynev

vasek1192
Posts: 28
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

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

Post by vasek1192 » 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."

Post Reply