level 3 4.6.5 Sale Planning Model: DAT02 module

Can someone help explain this to me, I believe we cannot use formulas to reference to the different models right? am I suppose to create another module in the Sales planning model that match the module in Datahub and import it?

If that is the case, I already done it but when using a lookup function like this 'DAT02 PY Revenue'.Revenue[LOOKUP: 'SYS00 Time Settings'.PY Qtr, LOOKUP: 'SYS03 Account>Product Details'.'A1 Account'] My data are not correct.

can someone point me how to match the data?

Accepted answers

Emmeline

The target module is dimensioned by a numbered list "Account>Product", but in a SYS module you need to store mapping to Account (I guess it is parent of the list) and Product (to do so, you can use a FINDITEM for example, based on the display name of the numbered list).

You cannot retrieve correct data if you don't map the product dimension on your target module: if only Account is mapped, the target module will aggregate sales of all products for each account.

All comments

Emmeline

Hi,

I can see in your formula that you are using a lookup using the SYS module for the list "Account>Product". You are currently mapping Account, but what about the product? I guess your module DAT02 PY Revenue is dimensioned by Account + Product lists.

syazwan000

The target module are using a numbered list as a dimension while the source module uses A1 account and a Product list as a dimension, if I'm using or adding a lookup for a product list, the data will turn out blank.

Emmeline

You cannot retrieve correct data if you don't map the product dimension on your target module: if only Account is mapped, the target module will aggregate sales of all products for each account.

Sarah69

Okay so It depends on the specific software or platform being used for modeling. In some cases, formulas can reference data from different models, while in other cases, a separate module may need to be created in the sales planning model to import and match data from the datahub module. Consult the documentation or support resources for the specific software or platform being used for more guidance.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…