inter cube feeders with one more dimensione

Post Reply
nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

inter cube feeders with one more dimensione

Post by nicola531 »

Hello again,

I have got to Cube (Cube A, Cube B)
The first Cube, Cube A is the same a Cube B minus a dimension.
So Cube A is (Dimension 1, Dimension 2, Dimension 3) and Cube B is (Dimension 1, Dimension 2, Dimension 3, Dimension 4)
I would like just to feed Cube B with Cube A and treat Dimension 4 equal to Dimension 3.
So I would like to have a B rule that does this: CubeB [Dimension 1, Dimension 2, Dimension 3, Dimension 4] = Cube A [Dimension 1, Dimension 2, Dimension 3]
where Cube B. Dimension3 is the same a CubeB dimension4 and equal to CubeA. Dimenson 3.
And CubeA dimension 1 = Cube B dimension 1
And CubeA dimension 2 = Cube B dimension 2

What I tried to do is to put this in the Cube A Rules Editor

FEEDERS;
[] => DB (Cube B, !Dimension 1, !Dimension 2, !Dimension 3, !Dimension 3)

But I dont know what to put as SKIPCHECK for the Cube B rules editor in order to activate this feeder (if I have understood properly the inter cube feeder process)


Any idea?


Thankx in advance for your time.

Bye

Nicola
Wim Gielis
MVP
Posts: 3234
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: inter cube feeders with one more dimensione

Post by Wim Gielis »

Hi

Consider:

Code: Select all

[]=N:IF(!Dimension 3@=!Dimension 4,DB(Cube A, !Dimension 1, !Dimension 2, !Dimension 3),0);
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: inter cube feeders with one more dimensione

Post by nicola531 »

Thanxs a lot!!!
It was exactly what I was looking for :)


Bye
Nicola
Post Reply