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
Rollup Issue in Performance Modeler
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Rollup Issue in Performance Modeler
- Attachments
-
- Feeders_Issue.docx
- (203.22 KiB) Downloaded 260 times