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 » Sat Dec 26, 2009 8:20 pm

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: 2262
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: inter cube feeders with one more dimensione

Post by Wim Gielis » Sat Dec 26, 2009 9:12 pm

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

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 » Sun Dec 27, 2009 1:14 pm

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


Bye
Nicola

Post Reply