Contributor

Re: Erin Lauterbach & Sam Wong - Model Building Problem Solving

@NicolasCadierhere are the responses to your questions: 

 

Question 1 Response:

COLLECT() is a function used in conjunction with Line Item Subsets to dimensionalize line items back to a list.
For example, in our Statistical Forecasting Application, we have a Calculation module that with line items that calculate the final forecasts for each algorithm method.

 

Step 1: Identify Line Items to Dimensionalize/CollectPicture1.png

Step 2:  Create a Line Item Subset and mark line items for inclusionPicture2.png

Step 3: In your list, create a property called Connect to Subset whose format is your line item subset:

Picture3.png

Picture7.png

Step 4: Create a module dimensionalized by this Line Item Subset and relevant properties, and call COLLECT()

Picture5.png

 

Step 5: Create a module dimensionalized by your list, and reference the Subset module with a Lookup from the Connect to Subset property

Picture6.png

 

 

Another example and more details on COLLECT() can be found here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/COLLECT.html

 

 

Question 2 Response:

Refer to Rob Marshall’s example (link below), he gave a great response and we agree with it. Create a concatenated list of the intersections and use this flat list in your model. Create a module with properties to translate the Flat List to other levels of your hierarchy

https://community.anaplan.com/t5/Best-Practices/Best-practice-for-Organisation-Hierarchy-in-Matrix-S...

 

- Erin & Sam 

 

 

 

Tags (1)