Moving data from cube with different dimension
Posted: Sat Mar 02, 2024 2:17 pm
Hi,
I'm facing performance issues with feeders in my TM1 model, and I'm seeking advice on optimizing a rule. Here's the setup:
Input Cube: IC_Input Cube
Dimensions: CBT, Company Code, Brand, Trading Partner, Business Area, Measure ("Value")
Output Cube: IC_Output Cube
Same dimensions as Input Cube
Allocation Cube: Ratio Cube
Dimensions: Company Code, Brand, Business Area, "Turnover ratio"
Requirement:
For non-dummy brands, values should be directly transferred to their respective brands.
Entries not ending with a dummy brand code should be moved to those specific brands after the initial allocation.
Any remaining unallocated dummy balance should be allocated based on a Business Area rule, which involves multiplying the dummy brand values with the provided ratio and allocating the value to respective actual brands.
The rule I've applied is:
IF(Brand=Dummy, IC_Dummy Cube * Allocation Ratio cube, IC Input Cube)
The issue I'm facing is heavy feeders due to which the RAM exceeds the limit. I've created a separate cube without the brand dimension called IC Dummy Cube to avoid one-on-one mapping from the brand in the original input cube.
I'm considering using TI coding to optimize the process. Any insights or suggestions on how to improve performance and reduce memory usage would be greatly appreciated.
Thank you!
I'm facing performance issues with feeders in my TM1 model, and I'm seeking advice on optimizing a rule. Here's the setup:
Input Cube: IC_Input Cube
Dimensions: CBT, Company Code, Brand, Trading Partner, Business Area, Measure ("Value")
Output Cube: IC_Output Cube
Same dimensions as Input Cube
Allocation Cube: Ratio Cube
Dimensions: Company Code, Brand, Business Area, "Turnover ratio"
Requirement:
For non-dummy brands, values should be directly transferred to their respective brands.
Entries not ending with a dummy brand code should be moved to those specific brands after the initial allocation.
Any remaining unallocated dummy balance should be allocated based on a Business Area rule, which involves multiplying the dummy brand values with the provided ratio and allocating the value to respective actual brands.
The rule I've applied is:
IF(Brand=Dummy, IC_Dummy Cube * Allocation Ratio cube, IC Input Cube)
The issue I'm facing is heavy feeders due to which the RAM exceeds the limit. I've created a separate cube without the brand dimension called IC Dummy Cube to avoid one-on-one mapping from the brand in the original input cube.
I'm considering using TI coding to optimize the process. Any insights or suggestions on how to improve performance and reduce memory usage would be greatly appreciated.
Thank you!