Rollup Issue in Performance Modeler

Post Reply
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Rollup Issue in Performance Modeler

Post by rajeshdayaneni »

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
Attachments
Feeders_Issue.docx
(203.22 KiB) Downloaded 211 times
Post Reply