Fresher..Rules & Feeders
-
- Posts: 6
- Joined: Wed Jul 05, 2017 6:27 am
- OLAP Product: Cognos
- Version: 10.2
- Excel Version: 2016
Fresher..Rules & Feeders
Hi everyone i am new to TM1
what to do if source cube has more dimension than Target cube which doesn't have related to target dimensions
Source A Dim
B Dim
C Dim
Month
Year
Currency
Nos which has three elements NOS, ARR, Revenue.
Target Cube
A Dim
B Dim
C Dim
Alos
what should be rule for getting value of NOS elements from source cube to alos dimension of target cube.
tnx in advance
what to do if source cube has more dimension than Target cube which doesn't have related to target dimensions
Source A Dim
B Dim
C Dim
Month
Year
Currency
Nos which has three elements NOS, ARR, Revenue.
Target Cube
A Dim
B Dim
C Dim
Alos
what should be rule for getting value of NOS elements from source cube to alos dimension of target cube.
tnx in advance
Last edited by Anuj4u2 on Sun Aug 13, 2017 9:41 am, edited 1 time in total.
-
- 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: Fresher..Rules & Feeders
This might help:
http://www.tm1forum.com/viewtopic.php?t=4252 Thanks
http://www.tm1forum.com/viewtopic.php?t=4252 Thanks
"You Never Fail Until You Stop Trying......"
-
- Posts: 6
- Joined: Wed Jul 05, 2017 6:27 am
- OLAP Product: Cognos
- Version: 10.2
- Excel Version: 2016
Re: Fresher..Rules & Feeders
Thank you for your suggestion,BariAbdul wrote: ↑Sun Aug 13, 2017 1:16 am This might help:
http://www.tm1forum.com/viewtopic.php?t=4252 Thanks
I went through the post, it was somewhere same as mine but, not understood it properly.
my question is if I don't have month and year dimensions in target cube which is present in source cube.
then what should be the rule, if I hard code it then the value is not flowing correctly from source to target.
-
- MVP
- Posts: 3117
- 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: Fresher..Rules & Feeders
Please show us your rule and also use real dimension names and cube names.
You should hardcode a value for the dimensions that you miss on the target side.
If your feeder is correct (assuming you feed this calculation) then it should all work.
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
-
- Posts: 6
- Joined: Wed Jul 05, 2017 6:27 am
- OLAP Product: Cognos
- Version: 10.2
- Excel Version: 2016
Re: Fresher..Rules & Feeders
Source Cube Service ProfileWim Gielis wrote: ↑Sun Aug 13, 2017 10:30 amPlease show us your rule and also use real dimension names and cube names.
You should hardcode a value for the dimensions that you miss on the target side.
If your feeder is correct (assuming you feed this calculation) then it should all work.
Dimensions
* Version
* Department
* SP_Pricing contain 200 elements
* SP_Sectors- 4 elements Service Profile which is consolidated elements, SP International, SP Institutional, SP Cash . this three are leaf elements
* Month
* Year
* M_Currency
* Measure Nos three element - Nos, ARR, Revenue
Target Cube;- ALOS
Dimensions
* Version
* Department
* SP_Pricing contain 200 elements
* SP_Sectors- 4 elements Service Profile which is consolidated elements, SP International, SP Institutional, SP Cash . this three are leaf elements
* ALOS - 1 element
so i want Nos value from Measure Nos Dimension and want to apply rule to consolidated
['Service Profile','ALOS']=C:(DB('Service Profile',!Version,!Department,!SP_Pricing,'SP Cash','??','??','Local Currency','Nos')*['SP Cash','ALOS'])+
(DB('Service Profile',!Version,!Department,!SP_Pricing,'SP International','??','??','Local Currency','Nos')*['SP International','ALOS'])
(DB('Service Profile',!Version,!Department,!SP_Pricing,'SP Institutional','??','??','Local Currency','Nos')*['SP Institutional','ALOS'])
what should be in place of '??'
Alos is independent of Month ie Constant but Calculated
Feeders;
[{'SP Cash','SP International,'SP Institutional'},'NOS']=>DB('ALOS',!Version,!Department,!SP_Pricing,'Service Profile','ALOS');
OR feeder can be written in ALOs cube itself .
[{'SP Cash','SP International,'SP Institutional'},'ALOS']=> ['Service Profile','ALOS'];
-
- MVP
- Posts: 3117
- 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: Fresher..Rules & Feeders
Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??
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
-
- Posts: 6
- Joined: Wed Jul 05, 2017 6:27 am
- OLAP Product: Cognos
- Version: 10.2
- Excel Version: 2016
Re: Fresher..Rules & Feeders
Nope.Wim Gielis wrote: ↑Sun Aug 13, 2017 12:41 pm Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??
I tried, its pass a consolidated value..... Which incorrect.
....
-
- 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: Fresher..Rules & Feeders
Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??
What Wim has advised you is the way to do in your case. You must have been doing something incorrectly...Nope.
I tried, its pass a consolidated value..... Which incorrect.
"You Never Fail Until You Stop Trying......"
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Fresher..Rules & Feeders
Not "nope". If you want help you post your code. And if you are serious about getting help you post your code AND you post a screenshot of subset editor the 2 missing dimensions showing what the top consolidation is called.
Right now you are time wasting. You are free of course to waste your own time but realize others may find it less endearing to have their time wasted.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 6
- Joined: Wed Jul 05, 2017 6:27 am
- OLAP Product: Cognos
- Version: 10.2
- Excel Version: 2016
Re: Fresher..Rules & Feeders
I extremely apologize for this, it was my mistake, I have to hard code the December month value, which was not mentioned in excel, I cleared it from Clint. Now my rule is working Properly.lotsaram wrote: ↑Mon Aug 14, 2017 6:20 amNot "Nope". If you want help you post your code. And if you are serious about getting help you post your code AND you post a screenshot of subset editor the 2 missing dimensions showing what the top consolidation is called.
Right now you are time wasting. You are free of course to waste your own time but realize others may find it less endearing to have their time wasted.
Thank you for your Help
I appreciate it