Level 1 - Model Building - Module Report - Different Results

In the Module - REP01 Country Margin Report below, G3 Location and P2 Products were selected in Pages and the results are as per below screenshot.

However, in the Module - REP01 Country Margin Report - Copy below, G2 Country and P1 Product Family were selected in Pages and the results shown is '0' as per below screenshot.

Were there some steps missing? I would think that their results should be the same.

Regards

Accepted answers

All comments

ankit_cheeni

Hi,
Your two modules have different dimensions, your 'Copy' model doesn't know which value to pull in when you refer two different modules.

Since the dimensions in 'Copy' module are parent of the dimension in the other module and you already have done the calculation in REP01, try referring that directly. As Anaplan says "calculate once, reference many times" 🙂

Star

@ankit_cheeni

1) Why would the result be different when everything else is the same except for the Pages - one with dimensions
displaying parent and the other with lower levels?
How do you fix the result in the 'Copy' model? Displaying '0' is not correct.
2) Understand the 'calculate once, reference many times' from the best practice perspective. But from the logical perspective, the same results still need to be achieved, right?

ankit_cheeni

Hi Star,
Sorry I wasn't clear the last time. What I mean is reference the REP01 line item directly in the Copy module. This will pull in the value for the parent combination(G2 P1 combination in Copy from G3 P2 combination in REP01)

Star

Hi @ankit_cheeni
I guess where I am coming is, how is it resolved if no referencing to REP01 Country Margin is defined in Copy module.
Assume that REP01 Country Margin was not created and only Copy module was created. The '0' result would give a wrong impression. Hence, how is it resolved without referencing?

Misbah

@Star

You need to check the summary methods of your line items in Source Modules.

Price Book - Summary Should be set to SUM

Volume - Summary Should be set to SUM

If either of the above is set to none it will not aggregate the values and the output will be zero.

Let us know about your findings

Misbah

ankit_cheeni

@Star As Misbah suggested, you need to check if the summary of the items are set to none(in that case you will get zero).

Also, the calculation would still be wrong due to basic maths
e.g.(Volume*Price)

2*3 = 6
3*4 = 12
Now when you reference it directly, it will show the rollup value, i.e. 18. However, if we use the formula directly it will do (2+3)*(3+4) which is 35 since they are being pulled in from different modules.

Let me know if this makes sense

Star

@Misbah

The results are still different. I have tried setting Price book to None, Average and Sum. Volume always at Sum.

The results at the Copy module should be the same as the REP01 Country Margin Report but they are different even with the above Summary Settings.

Star

@ankit_cheeni
Please refer to my reply to @Misbah for the different results.

Misbah

@Star

This is expected because you are aggregating the prices of your products as well. For example my Product Family has 3 Products i.e., P1, P2 & P3

P1 = $1

P2 = $1.5

P3 = $2.5

If you try to sum everything up, you are saying that the price of entire product family is $5 - which might not be true. Same goes to rest of the summary methods like Average etc

Keeping your summary method on Price lien item as Average will take you closer but it will not be the correct answer

In order to avoid this situation you can create a module dimensioned by Product Family and Insert one input line item and upload your prices directly instead of letting Anaplan do the aggregation.

Hope that helps

Misbah

Quick Links

Can you help?

Unanswered questions

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…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…