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'];