L3 Quarterly initial sales target

Options
mickynike7
mickynike7 Member, ALL USERS Posts: 4 Occasional Contributor
in Planning & Modeling

I am actually stuck in this and need some help

 

1. In the Level 3 Sales Planning Model I have created a module and successfully imported the data from the data hub for Actual Sales Revenue. Its dimension include - A1 Accounts, P2 Products

mickynike7_0-1618846531319.png

 

 

2. I have another module in which I have dimension as G2 Country, P2 Product Family, A2 Account>Product#

 

I am not able to do a lookup from the earlier module and using the SYS03 Account>Product Details. It says level mismatch on common dimension.

 

I am just stuck here please can you help me how to move forward after importing the data from the data hub - I understand I will have to use LOOKUP and SUM and I have used those formulas earlier - In this particular scenario I am not able to understand how to use them - what should be the dimensionality of the new module.

 

Thanks a lot!!!

Tagged:

Comments

  • mickynike7
    mickynike7 Member, ALL USERS Posts: 4 Occasional Contributor

    Thanks for the reply.

     

    I am importing the data as is from the Data Hub. So I have kept A1 Accounts and P2 Products as dimensions.

     

    Please can you give me more details on the lookup part. If I only keep one module with the dimensionality of Account-Product#  and use the system module to lookup the product family and country I get level mismatch error and I am not able to lookup.

     

    Thanks!

  • mickynike7
    mickynike7 Member, ALL USERS Posts: 4 Occasional Contributor

    Thank You @Misbah! You have solved my problem!

Categories