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?
Cube Rule
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Cube Rule
- Attachments
-
- print1.jpg (65.8 KiB) Viewed 5263 times
-
- 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
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 ?
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
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
-
- 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
Bit more on nested DB could be found in below post:
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks
"You Never Fail Until You Stop Trying......"
-
- 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
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
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
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Cube Rule
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
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
-
- 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
My Portuguese nowadays isn't what it used to bemvaspal 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
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
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
-
- 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
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
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
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Cube Rule
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
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
-
- 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
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.
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.