Fresher..Rules & Feeders

Post Reply
Anuj4u2
Posts: 5
Joined: Wed Jul 05, 2017 6:27 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Fresher..Rules & Feeders

Post by Anuj4u2 » Sat Aug 12, 2017 3:49 pm

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
Last edited by Anuj4u2 on Sun Aug 13, 2017 9:41 am, edited 1 time in total.

BariAbdul
Regular Participant
Posts: 404
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: Fresher..Rules & Feeders

Post by BariAbdul » Sun Aug 13, 2017 1:16 am

"You Never Fail Until You Stop Trying......"

Anuj4u2
Posts: 5
Joined: Wed Jul 05, 2017 6:27 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Re: Fresher..Rules & Feeders

Post by Anuj4u2 » Sun Aug 13, 2017 9:57 am

BariAbdul wrote:
Sun Aug 13, 2017 1:16 am
This might help:
http://www.tm1forum.com/viewtopic.php?t=4252 Thanks
Thank you for your suggestion,

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.

Wim Gielis
MVP
Posts: 1562
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Fresher..Rules & Feeders

Post by Wim Gielis » Sun Aug 13, 2017 10:30 am

Anuj4u2 wrote:
Sun Aug 13, 2017 9:57 am
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.
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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

Anuj4u2
Posts: 5
Joined: Wed Jul 05, 2017 6:27 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Re: Fresher..Rules & Feeders

Post by Anuj4u2 » Sun Aug 13, 2017 12:25 pm

Wim Gielis wrote:
Sun Aug 13, 2017 10:30 am
Anuj4u2 wrote:
Sun Aug 13, 2017 9:57 am
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.
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.
Source Cube Service Profile
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'];

Wim Gielis
MVP
Posts: 1562
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Fresher..Rules & Feeders

Post by Wim Gielis » 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 ??
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

Anuj4u2
Posts: 5
Joined: Wed Jul 05, 2017 6:27 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Re: Fresher..Rules & Feeders

Post by Anuj4u2 » Mon Aug 14, 2017 3:45 am

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 ??
Nope.
I tried, its pass a consolidated value..... Which incorrect.
....

BariAbdul
Regular Participant
Posts: 404
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: Fresher..Rules & Feeders

Post by BariAbdul » Mon Aug 14, 2017 6:03 am

Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??
Nope.
I tried, its pass a consolidated value..... Which incorrect.
What Wim has advised you is the way to do in your case. You must have been doing something incorrectly...
"You Never Fail Until You Stop Trying......"

lotsaram
MVP
Posts: 3006
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: Fresher..Rules & Feeders

Post by lotsaram » Mon Aug 14, 2017 6:20 am

Anuj4u2 wrote:
Mon Aug 14, 2017 3:45 am
Nope.
I tried, its pass a consolidated value..... Which incorrect.
....
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.

Anuj4u2
Posts: 5
Joined: Wed Jul 05, 2017 6:27 am
OLAP Product: Cognos
Version: 10.2
Excel Version: 2016

Re: Fresher..Rules & Feeders

Post by Anuj4u2 » Mon Aug 14, 2017 10:04 am

lotsaram wrote:
Mon Aug 14, 2017 6:20 am
Anuj4u2 wrote:
Mon Aug 14, 2017 3:45 am
Nope.
I tried, its pass a consolidated value..... Which incorrect.
....
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.
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.
Thank you for your Help
I appreciate it :)

Post Reply