Level 1 Model Building 2.0 (New UX) - Model Building Activity 5

LarysaK · 2024-08-19T21:04:35+00:00

There was an error rendering this rich post.

Team!

Pls help me, I can't move on.

EMP03 Employee Drivers by Role

EMP02 Employee Expenses - the task is update the formulas bonus, car , phone… to ref driver data in the EMP03; employees' costs to be driven by role and departent.
!!!!!!!!!!!!! I tried all possible scenarios, but I always get zero in the module EMP02 for any line items - bonus, car, phone.

Please exp what was the mistake. Thank you for your kind support.

Bonus formula

IF    Employed?
THEN    Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department]
ELSE    0

CarCost

IF Employed?THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role]ELSE 0

SYS08 Employee Details

Accepted answers

All comments

pyrypeura

Hi,

Could you check at individual employee level and utilise drill down. That way it can be easier to see what is going wrong. For example if the Employed? boolean is not working correctly. For example if you navigate to Shala Engle you should see 200 in Medical Costs row.

LarysaK

HI pyrypeura,

The cell is empty. What is my problem? Please help. Thank you

pyrypeura

Could you show what dimensions you have in EMP03 from the blueprint? Your formula in EMP02 seems correct to me.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…