Same dimensions twice in the same cube

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

Same dimensions twice in the same cube

Post by nicola531 »

Hello everybody,

Is it possibile to use the same dimension twice in the same cube?

Or maybe create a rule that allows a cube to be fed by another cube, exactly equal, but with different dimensions name.

For istance:

cube A
Dimension 1

Cube B
Dimension 2


Dimension 1 is the same of Dimension 2 so a would like to have a rule for Cube A that would read data form Cube B.

Thanx for you time.
I hope that I've been almost clear.

ND
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Same dimensions twice in the same cube

Post by kpk »

nicola531 wrote:Hello everybody,

Is it possibile to use the same dimension twice in the same cube?

Or maybe create a rule that allows a cube to be fed by another cube, exactly equal, but with different dimensions name.

For istance:

cube A
Dimension 1

Cube B
Dimension 2


Dimension 1 is the same of Dimension 2 so a would like to have a rule for Cube A that would read data form Cube B.

Thanx for you time.
I hope that I've been almost clear.

ND
Hello,

No, You cannot use the same dimension twice in a cube.
Yes, You can feed from different dimension.
Instead of sending the feeder to =>DB(cubeA, ...., dimension1, ....) you have to write =>DB(cubeA, ...., dimension2, ....).

Regards,

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

Re: Same dimensions twice in the same cube

Post by nicola531 »

I'm not sure I have understood correctly because I tried what you said but it didn't work out.

The feeder alone in the origin cube (CUBE A - dimension A) is not enough I think.
I should put a rule in the CUBE B (dimension B) to read the value from cube A.

My problem is that those two dimensions have the same value (value 1, value 2, etc) but different names (Dimension A and Dimension B ) so I can do a DB lookup with punctual value but not in general like this
In CUBE B
[] =N: DB(CUBE A, !Dimension2)

I tried to put in the CUBE A this feeder

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

but it doesn't anything..

Thanxs for you time,


N
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: Same dimensions twice in the same cube

Post by Wim Gielis »

Hello Nicola

This should do the trick, regarding
would like to have a rule for Cube A that would read data form Cube B.

In CUBE A:

[]=N:DB(CUBE B, !Dimension1);

In CUBE B:

FEEDERS;
[] => DB(Cube A, !Dimension 2);
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
Post Reply