Page 1 of 1

Fresher..Rules & Feeders

Posted: Sat Aug 12, 2017 3:49 pm
by Anuj4u2
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

Re: Fresher..Rules & Feeders

Posted: Sun Aug 13, 2017 1:16 am
by BariAbdul

Re: Fresher..Rules & Feeders

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

Re: Fresher..Rules & Feeders

Posted: Sun Aug 13, 2017 10:30 am
by Wim Gielis
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.

Re: Fresher..Rules & Feeders

Posted: Sun Aug 13, 2017 12:25 pm
by Anuj4u2
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'];

Re: Fresher..Rules & Feeders

Posted: Sun Aug 13, 2017 12:41 pm
by Wim Gielis
Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??

Re: Fresher..Rules & Feeders

Posted: Mon Aug 14, 2017 3:45 am
by Anuj4u2
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.
....

Re: Fresher..Rules & Feeders

Posted: Mon Aug 14, 2017 6:03 am
by BariAbdul
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...

Re: Fresher..Rules & Feeders

Posted: Mon Aug 14, 2017 6:20 am
by lotsaram
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.

Re: Fresher..Rules & Feeders

Posted: Mon Aug 14, 2017 10:04 am
by Anuj4u2
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 :)