# level 1 Exam activity 4

Options
edited November 2022

Hi,
I have been stuck on this question from past few days can anyone please assist me asap Have tried my best but couldn't correctly complete it.
The formula I am using  for Bonus in EMP002 is IF Employed? THEN salary* 'EMP03 Employee Drivers by Role'.Bonus%[LOOKUP:'SYS08 Employee Details'.Role] ELSE 0. is this correct?

also not able to get the correct formula for  Car Costs, Medical Costs and Phone cost, mistake in this is leading to wrong answers which are further dependent on this. Please help me out with the exact formulas  and what line items need to be changed in the EMP002 or any other module all confused.

• edited November 2022
Options

You are almost there. However, look at the dimensions of the drivers module. How many are there? If there are multiple dimensions in the source that are not present in the target then you need multiple mappings to match the data and bridge the dimensions gap.

Also, bonus is the only driver which is a % of salary. The others can be referenced directly.

Good luck,

• edited November 2022
Options

Hi,

PFA drivers  module dimensions I have given. Also can you specify formula for car cost or any one which can be referenced directly.

• edited November 2022
Options

Ok, so your driver module has two dimensions but your formula contained one mapping looking up the role for each employee!

Think through the logic of what you are trying to achieve.

Bonus is a function of salary while car, phone and medical costs are not.

• edited November 2022
Options

Iam confused with this part only not sure anymore what needs to be done.

• edited November 2022
Options

You now have a new drivers module dimensioned by Department and Role.

The current formula looksup a drivers module dimensioned by Department and Country.

Therefore, change the source to reference your new drivers module and update the mappings to reflect the changes in dimensions.

• edited November 2022
Options

@ChrisAHeathcote
I successfully completed the formulas without errors but there is no data displaying for car cost, bonus costs,phone costs and medical costs. please refer attachments.

• edited November 2022
Options

Have you updated the new drivers module?

The original module is updated via an import. Do you have to perform a similar import for the new module?

• edited November 2022
Options

Yes I have updated drivers module also have imported without any error.

• edited November 2022
Options

Can you post a pic of the new drivers module grid and blueprint?

• edited November 2022
Options

@ChrisAHeathcote
yes sure. Please find the respective screenshots.

• edited November 2022
Options

Role should be a dimension of the drivers not additional line items.

Remove the line items which refer to roles.

However, I can see that the drivers module does contain the correct dimensions.

Now check that the line items in the Employee systems module used in the LOOKUPs is populated.

This I believe is also updated via an import.

• edited November 2022
Options

@ChrisAHeathcote
Have corrected line items in drivers module please check also sent ss of sys08 module

• edited November 2022
Options

The Role line item is not populated in you system module.

Update this and the formulas should work.

• edited November 2022
Options

Hi,

I have checked again the role line item is populated in sys08 module on the 10th line you can see,Iam not getting where do I have to update.

• edited November 2022
Options

One of your previous posts contained a picture of the SYS08 module grid view.

The Role line item was blank.

I believe this is the reason no values are coming through as the mapping lookup this line item does not have a value/list item to reference.

Update the contents of this Role line item and the formula should generate values.

• edited November 2022
Options

Thanks , now data is populating👍.The content of role item were not updated so it was not populating .

• edited November 2022
Options

It is great news that the data is now successfully coming through.

If you feel my reply helped solve your query can you please mark it as the solution and Kudo the replies that resulted in the final answer.

• edited November 2022
Options

can you help with the formula