Hi guys, I need some help.
I have two similar cubes and the only difference between then is the period dimension.
In one cube I have the complete period, like 11/25/2019, and on another cube I have only month and year, like 11/2019.
I am facing some doubt to bring the data from the cube which has complete data using DB, because I only want the value on mm/yyyy format.
Any ideas that could help me?
Thanks a lot.
JR
Rule Question
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
-
- MVP
- Posts: 3128
- 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: Rule Question
You have over 100 posts here. Why can't you post the rules and feeders that you now have ?
Basically you need the SUBST function and/or an attribute.
Basically you need the SUBST function and/or an attribute.
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: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: Rule Question
Given a choice I will prefer the path of using TI to copy data from one cube to the other. It will be a very straight forward unless the dates you are storing is serial number date format which you may need some date formatting function in combination of SUBST etc.
If insist of using rule, I will just create hierarchy eg
11/2019
11/01/2019
11/02/2019
....
12/2019
12/01/2019
.....
You cna then use rule to pull based on the parent easily.
However real life model can be much more complex than what I have illustrated above.
If insist of using rule, I will just create hierarchy eg
11/2019
11/01/2019
11/02/2019
....
12/2019
12/01/2019
.....
You cna then use rule to pull based on the parent easily.
However real life model can be much more complex than what I have illustrated above.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Rule Question
Hi Wim. Sorry about that.
I did not put the screenshots here because I tried to do the rule and not worked. I didn't understand how SUBST function would work in this case.
I will put the cube structure of the two cubes here so you can help please?
This is the first cube with the complete period:
This is the dimension with the complete period:
Now the cube with another dimension of period:
Please repair that this cube does not have nrolan and nrolot dimension. In this case I get the total of dimension.
I will put the screenshot of the dimension of period of this cube on another post.
Thanks.
I did not put the screenshots here because I tried to do the rule and not worked. I didn't understand how SUBST function would work in this case.
I will put the cube structure of the two cubes here so you can help please?
This is the first cube with the complete period:
This is the dimension with the complete period:
Now the cube with another dimension of period:
Please repair that this cube does not have nrolan and nrolot dimension. In this case I get the total of dimension.
I will put the screenshot of the dimension of period of this cube on another post.
Thanks.
Wim Gielis wrote: ↑Mon Nov 25, 2019 1:10 am You have over 100 posts here. Why can't you post the rules and feeders that you now have ?
Basically you need the SUBST function and/or an attribute.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Rule Question
The period dimension of the cube that I want to do the rule:
I want to match this period here with the same period of the first cube via rule. How could SUBST help in this case?
Thanks a lot.
JR.
I want to match this period here with the same period of the first cube via rule. How could SUBST help in this case?
Thanks a lot.
JR.
Jorge Rachid wrote: ↑Mon Nov 25, 2019 2:30 pm Hi Wim. Sorry about that.
I did not put the screenshots here because I tried to do the rule and not worked. I didn't understand how SUBST function would work in this case.
I will put the cube structure of the two cubes here so you can help please?
This is the first cube with the complete period:
cube1.png
This is the dimension with the complete period:
complete period.png
Now the cube with another dimension of period:
cube2.png
Please repair that this cube does not have nrolan and nrolot dimension. In this case I get the total of dimension.
I will put the screenshot of the dimension of period of this cube on another post.
Thanks.
Wim Gielis wrote: ↑Mon Nov 25, 2019 1:10 am You have over 100 posts here. Why can't you post the rules and feeders that you now have ?
Basically you need the SUBST function and/or an attribute.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Rule Question
Hi, thanks for help!
I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too.
My dimensions of period has the hierarchy as you said. I put some screenshots here.
On rule you would use the ELPAR function?
Can you explain more?
Thanks, JR.
I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too.
My dimensions of period has the hierarchy as you said. I put some screenshots here.
On rule you would use the ELPAR function?
Can you explain more?
Thanks, JR.
kangkc wrote: ↑Mon Nov 25, 2019 2:03 am Given a choice I will prefer the path of using TI to copy data from one cube to the other. It will be a very straight forward unless the dates you are storing is serial number date format which you may need some date formatting function in combination of SUBST etc.
If insist of using rule, I will just create hierarchy eg
11/2019
11/01/2019
11/02/2019
....
12/2019
12/01/2019
.....
You cna then use rule to pull based on the parent easily.
However real life model can be much more complex than what I have illustrated above.
-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: Rule Question
No, you do not need to use ELPAR at all as the target dimension will have the exact matching element in the source dimension, just that at target it is N element and at source it is a C element. Hence a simple rule statement using a direct DB will do the trick. This is on the assumption there are no other mapping with other dimensions required.Jorge Rachid wrote: ↑Mon Nov 25, 2019 2:35 pm Hi, thanks for help!
I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too.
My dimensions of period has the hierarchy as you said. I put some screenshots here.
On rule you would use the ELPAR function?
Can you explain more?
Thanks, JR.