Trying to find equivalent of INDIRECT in Anaplan
My specific problem is referencing a line item by name from another module using a text value as the name. For example, if the line item is "1011" in module "Module A", how can I reference this line item dynamically within another module "Module B" using a separate input that matches "1011".
In excel, I could use the INDIRECT function to create cell references that take values from other cells dynamically and returns the contents of the cells being referred. I'm looking to understand how this can be done in Anaplan.
Answers
-
It depends, what is the dimensionality of both modules?
0 -
Module A contains pipeline opportunity-level data - opportunity codes (40K distinct opportunities) and regions (against 3 regions) with 63 line items.
Module B is a summarization of opportunity level data in module A and contains only one 2 dimensions - a reference quarter (9 values) and region (3 regions). Trying to create a line item that references one of the 63 line items based on the reference quarter value.0 -
In module A, what happens to the text data as it aggregates up to the summary members? Is this a possibility where A1 = "Test" and A2="Testing" and A3="Tester"…What should be shown at A?
Total
- A
- A1
- A2
- A3
- B
- B1
- B2
- B3
- C
- C1
- C2
- C3
0 - A