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
Same dimensions twice in the same cube
-
- 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
Hello,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
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
Peter
-
- 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
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
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
-
- 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
Hello Nicola
This should do the trick, regarding
In CUBE A:
[]=N:DB(CUBE B, !Dimension1);
In CUBE B:
FEEDERS;
[] => DB(Cube A, !Dimension 2);
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
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