Cube Rule

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Cube Rule

Post by Jorge Rachid »

Hi everyone,

I have to do a rule on TM1 but I am facing some difficult.

There is a cube of human resources (cube 1) with some metrics and I also have a lookup cube where each of the metrics of human resources cube has a expense classification, as image.

Then in another cube I am trying to do a rule where I do a DB from the cube 1, but on this DB when I am going to select the metric I would like to use the lookup cube.

How can I do this?
Attachments
print1.jpg
print1.jpg (65.8 KiB) Viewed 5263 times
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cube Rule

Post by Wim Gielis »

You can nest a DB() function within another DB() function.
So 1 of the arguments of the DB() function for the lookup cube, is again a DB() function for the metric.
Was that your question ?
Best regards,

Wim Gielis

IBM Champion 2024
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
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Cube Rule

Post by BariAbdul »

Bit more on nested DB could be found in below post:
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks
"You Never Fail Until You Stop Trying......"
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Cube Rule

Post by mvaspal »

Hi
Why don't you build a hierarchy in the dimension that is on the rows on your screen?
Wim, I think he is trying to accumulate cost lines, so not sure how a nested DB would help here? Although I agree, it is not too clear from the original post
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Cube Rule

Post by Jorge Rachid »

Hi there,

I've tried to use DB inside another DB and it didnot worked.

I will put in a word file more details so you can understand better.

Thanks for helping me.

Jorge Rachid
Attachments
Cubes.docx
(122.32 KiB) Downloaded 199 times
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cube Rule

Post by Wim Gielis »

mvaspal wrote:Wim, I think he is trying to accumulate cost lines, so not sure how a nested DB would help here? Although I agree, it is not too clear from the original post
My Portuguese nowadays isn't what it used to be :-D
Best regards,

Wim Gielis

IBM Champion 2024
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
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Cube Rule

Post by mvaspal »

Hi

Create a hierarchy in the first cube's cost dimension, i.e.
Total
___Encargos
______Avisio Previo

And then the rule should be obvious, hopefully :)
This will work as long as it is a n:1 mapping
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Cube Rule

Post by Jorge Rachid »

Hi guys,

I understond this point of creating the hierarchy and then using DB.

But I would like to know if it is possible to do something using the look up cube, where I set the expense classification for each metric of the cube.

Thanks for helping.

JR
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Cube Rule

Post by mvaspal »

Hi
technically it is possible yes, you can follow the logic of accumulation links, used by Performance Modeler, and build similar control/technical cubes to support what you want to achieve.
Post Reply