Multiple SUM&LOOKUP splitting workaround

Options
khush89
khush89 Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Anaplan Community

Hi,

 

I am trying to split multiple SUM&LOOKUP's used in a lineitem in a  module in order to optimize the model performance. But while splitting the SUM & LOOKUP into different line items in separate modules (dimensioned by lists used in SUM&LOOKUP)  , the result is not coming as expected. Since the size of lists is quite huge, i cannot even combine the lists being used in the SUM&LOOKUP  as part of one module and then aggregate the value to final module. I know its not best practice to use multiple SUM&LOOKUP together, but the requirement is such that we have to sum the transaction value based on multiple attributes . Is there any workaround for the same where more than 3 SUM&LOOKUP are being used in a single line item

 

Thanks in advance!

Khushboo

Comments

  • khush89
    khush89 Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

     Thanks @rob_marshall 

    I have attached screenshot of SUM&LOOKUP i am trying to do using Calc modules as you have mentioned already. But this approach seems to work only if we have one attribute to do SUM&LOOKUP on. In case of multiple attributes, the result doesnt seem to look correct.

     

    Below is how the splitting of lineitems is done in the Final module:

    Value: Line item which need to be aggregated based on List 1 and List 2

     Aggregate level 1: 'Sum Calc 1'. 'Aggregate 1'[LOOKUP:List1]

    Final Aggregation: 'Sum Calc 2'. 'Aggregate 2'[LOOKUP:List2]

     

    Let me know if you need more details

  • khush89
    khush89 Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    @Misbah 

    This would give me correct result, however issue in my case is the size of lists being used is really huge (~ million items in each list). And combining them in a separate module is increasing the model size by 10 GB. 

  • khush89
    khush89 Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    @rob_marshall 

    Yes correct, there are million+ items in each of these list. To answer your questions,

    1. Apparently there is no relation between List 1 and List 2. However, both of these are as attributes in the Final Module.

    2. Original SUM&LOOKUP was: Value[SUM:List 1,LOOKUP: List 1, SUM: List 2, LOOKUP: List 2]

     

  • khush89
    khush89 Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    @rob_marshall 

    Yes this approach works for me. I am concatenating items from both lists and doing SUM on line item (module based on concatenated items list) and then doing lookup on another lineitem (Final module). 

    Thanks!

Categories