L3 Quarterly initial sales target
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
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!!!