Level 1 exam - model building activity 2

fabianmp
fabianmp
in Academy Discussions

Hi, 

I'm trying to do the activity 2: 

"update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes module". And tried the formula: 

'DATA02 SKU Volumes'.Volumes
 
but I get the error message: 
Level mismatch on common dimension
 
Can 

fabianmp_0-1663877688932.png

 

Comments

  • R_Goza
    R_Goza

    @fabianmp 


    Check the dimensions of your DAT02 module.  The dimensions should be: 

    1.G3 Location
    2. P3 SKUs 
    3. Time Scale = Month 

    The screenshot of your REV02 module looks correct. 

  • fabianmp
    fabianmp

    Hi Goza

    I already have the dimensions in the DATA02 Module but still came up the message of 

    fabianmp_0-1663896963991.png

     

  • R_Goza
    R_Goza

    @fabianmp 

     

    Can you share a screenshot of the general lists section and a screenshot of your modules.  Like the one you have above, but that includes REV02.  

  • fabianmp
    fabianmp

     

     

    Hey Goza

    thanks for your answer. I already got a solution. I had to change the hierarchy of P3 Sku List. I had the parent to product family and I changed to P2 product and ran the formula in REV02 and worked. 

     

    thanks  

     

    fabianmp_0-1663981831540.png

     

  • fabianmp
    fabianmp

    Goza,

    Sorry, I change it but now I have another error.

    Now I have zeros. 

    dont know why and how continue 

    Can you please help me?

     

     

     

    fabianmp_0-1663986062935.png

    fabianmp_0-1663986405582.png

     

    fabianmp_1-1663986107062.png

     

    fabianmp_2-1663986163595.png

     

     

     

  • fabianmp
    fabianmp

    Can anyone please help me?

  • R_Goza
    R_Goza

    @fabianmp 

     

    I would trace the formula back to identify the issue.  Your formula is referencing the DATA02 module, do you have data populated in the module for the intersections in your screenshot (Japan and Chocolates)?  If not, then you may need to look at the import you created to populate DATA02 and make sure it's working correctly.  You might also need to run the action again, changes you made in the model could have cleared the data you initially imported. 

  • GeraldineEntoma
    GeraldineEntoma

    we have the same problem

  • GeraldineEntoma
    GeraldineEntoma

    @fabianmp may you help me?

  • bhushanshastrakar
    bhushanshastrakar

    What is the time format for file import?

    PFA- error

    image.png

  • KamranKalantarli
    KamranKalantarli

    Check if you have SYS08 SKU Details module in the newly downloaded "Level 1 FP&A _Your Name" module. I did not, and had to create it. You can reference SYS08 in the Supply Chain Model for the structure & formulae.

    DATA02 SKU Volumes module is at SKU level where as REV02 Volume Inputs module is at Product level. Anaplan needs to be explained how to connect SKU to Product and this is done via SYS08 module where you got to map each SKU to a Product using formula: PARENT(ITEM('P3 SKU'))

    Once your SYS08 module is set up, this formula will sum all SKU volumes related to a certain Product from DATA02 module: 'DATA02 SKU Volumes'.Volumes[SUM: 'SYS08 SKU Details'.Product]

    Good luck!

Categories