TM1 Forum

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?

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 ?

Bit more on nested DB could be found in below post:
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks

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

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

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

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

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

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.