Level 1 exam - model building activity 2

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

Comments

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

Hi Goza

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

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

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

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

Can anyone please help me?

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

we have the same problem

GeraldineEntoma

@fabianmp may you help me?

bhushanshastrakar

What is the time format for file import?

PFA- error

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!

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…