Level 1 Model Building Exam - Activity 6

I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020.

The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04:

REP04.5.png

It draws from SYS08:

I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.

EMP02:

EMP02.5.png

EMP03:

EMP03.5.png

Can anyone help an amateur Anaplanner on where I am going wrong?

Accepted answers

All comments

Kanishq17

hi @tspoon

So if you see the dimension of REP04 is on region , role and department , but your formula uses sum only for region and role , you need to use department mapping as well after that so that it is correctly assigned to department

Hope this solves the issue

tspoon

Hi - thanks so much for your input. I corrected the formula but am still getting the wrong numbers which makes me think there's something wrong with EMP02. Is it because I don't have region as part of the formula in EMP02? I have department and role in there but no region.

sreesanda

The Time Scale As per the requirement its Years

AjayM

Hi @tspoon ,

EMP02 is the right source for REP04, because EMP03 gives driver details at role and department level. We first calculate individual expenses at employee level in EMP02 using this driver data, and then aggregate them in REP04 at region and role level.

So couple of issues I see here:

Your data in EMP03 looks off. Please reload the file into this module and cross check with the file.
REP04 is a summary report module at region and role levels. Your formula in initial snapshot made sense but the dimensionality is the problem
As @sreesanda pointed, this reporting module REP04 should be at year level

Cheers!

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…