TM1 Forum

Hi,

we are loading "Regional %" from "LDP" Cube to "LDP Calc" Cube through Link in Performance Modeler."Regional%" data is not rolling up to consolidated level "LDP Calc" Cube.Please see the screen Prints in the attachment.Could you please help me in solving this issue.



AutoGenerated Rules:

#Region Link rule: LDP Calc LDP - Numeric
#Source cube: LDP
#Target cube: LDP Calc
#@AutoGenerated
['Version For Calcs':{'Version 1','Version 2','Version 3','Version 4','Version 5','What if','Current'}, 'Calc LDP Related':{'FOB Fuel Surcharge Override','FOB %','Pick-up Allowance','Fuel Surcharge (Y/N)','Delivered %','LDP','Regional %','Del Fuel Surcharge Override','Fuel Tier'}] = N:DB('LDP',
!Hier Customer, !Hier LDP East-West, ATTRS('Version For Calcs',
!Version For Calcs, '}Map_}Link_LDP Calc LDP'), ATTRS('Calc LDP Related',
!Calc LDP Related, '}Map_}Link_LDP Calc LDP'));

#Region Link rule: LDP Calc LDP - String
#Source cube: LDP
#Target cube: LDP Calc
#@AutoGenerated
['Version For Calcs':{'Version 1','Version 2','Version 3','Version 4','Version 5','What if','Current'}, 'Calc LDP Related':{'FOB Fuel Surcharge Override','FOB %','Pick-up Allowance','Fuel Surcharge (Y/N)','Delivered %','LDP','Regional %','Del Fuel Surcharge Override','Fuel Tier'}] = S:DB('LDP',
!Hier Customer, !Hier LDP East-West, ATTRS('Version For Calcs',
!Version For Calcs, '}Map_}Link_LDP Calc LDP'), ATTRS('Calc LDP Related',
!Calc LDP Related, '}Map_}Link_LDP Calc LDP'));


we are using Planning Analytics 2.0


Regards,
Rajesh