@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!
... View more
@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]
... View more
@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.
... View more
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
... View more
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
... View more
