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/Collect
Step 2: Create a Line Item Subset and mark line items for inclusion
Step 3: In your list, create a property called Connect to Subset whose format is your line item subset:
Step 4: Create a module dimensionalized by this Line Item Subset and relevant properties, and call COLLECT()
Step 5: Create a module dimensionalized by your list, and reference the Subset module with a Lookup from the Connect to Subset property
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
- Erin & Sam