Level 1 Cert Exam - Data02 SKU Volumes
I am struggling with the data pull from Data02 SKU Volumes to Rev Volume inputs. I was using a LOOKUP formula. Am I on the right track and are there any common mistakes on this step.
Comments
-
Hello @JimMcL
Is this question related to the certification exam? (judging from your post title).
If so, we can't really answer, but if not please share with me the activity/step in the training material that you are having troubles with and I'm happy to help you.0 -
In the step where I am supposed to pull the volume data from Data02 SKU Volumes to Rev02. I have tried multiple LOOKUP formulas which have not worked. I initially thought it might be a simple reference but swithced to a LOOKUP formula. The formula listed below in one of the ones that have failed.I believe the syntax is correct. I understand you cannot give an answer, just looking for guidance.
'Data02 SKU Volumes'.Volumes[SUM: 'SYS04 Location Details'.Code]
0 -
HI @JimMcL
When do we generally need to use LOOKUP and SUM ?We need to do so when we are trying to read data from a source module to a target module where the dimensions don't match.
When the dimensions of both modules match then no need for a LOOKUP or a SUM
You say "I initially thought it might be a simple reference but swithced to a LOOKUP formula."
Can you tell me why you thought it wouldn't work? Did you get any error?
2 -
I tried using the following formula to get the data from Data02 SKU Volumes to Rev02. To be more specific n the formula bar for Rev02 on the line item volumes I had the following formula:
'Data02 SKU Volumes'.Volumes
I did not get an error just no data.
0 -
You're so close, so close.
As @einas.ibrahim pointed out you have to think about when to use LOOKUP and when to use SUM. In this case the data is already in the structured hierarchy you want so you actually don't need either. Just reference the line item.
- your data is in G3, P3, and Month
- Your target is in G3, P2, and Month
The only difference is the P3 to P2 and since those two are in the same structured hierarchy, you won't need to use SUM. Anaplan is smart enough to add those up for you since you already defined the relationship between those to levels (P2 is the PARENT of P3 in your lists).
'DATA02 SKU Volumes'.Volumes - Try It!
If that doesn't work then you need to check your dimensions and whether or not the data in SKU Volumes actually loaded.
Good luck! Let us know how it goes.
6 -
Hello @JimMcL
No data as in blank or zeros?
- Follow what @JaredDolich said. He is way more generous than me in giving directions.
- Check the Summary method of the Volume Line Item in the target module.
- Ensure that you actually have data in the source module
Let us know and probably provide screenshots of the blueprints.
Good Luck1 -
I'm also struggling to import the data - sku+volumes.csv into my DATA02 SKU Volumes module. I keep getting this error
it may something wrong with my date structure
0 -
How can I solve this issue?
Invalid formula for 'REV02 Volume Inputs'.Volumes: Automatic sum of 'DATA02 SKU Volumes'.Volumes over P3 SKU hierarchy is not possible as P3 SKU does not have a built-in top level- Please verify you are able to reach other sites on the Internet
- If you are unable to load any pages, check your computer's network connection.
0 -
Hello wadetse,
Unfortunately we can't help answer exam questions. As a general reminder, when you get a formula error, Anaplan will provide you will details on what might have gone wrong.
I would go back and review the information in your model that is relevant to the error below in red.
Invalid formula for 'REV02 Volume Inputs'.Volumes: Automatic sum of 'DATA02 SKU Volumes'.Volumes over P3 SKU hierarchy is not possible as P3 SKU does not have a built-in top level
0 -
Hi @JaredDolich,
Everything imported correctly, I've confirmed my dimensions match, and the REV02 module shows the same data as DATA02...until I add the formula ('DATA02 SKU Volumes'.Volumes ). When I add this, it goes to 0. I am not sure what I am missing or need to further check?
Thanks,
Stephanie
0 -
Sounds like you're really close. Here's some quick observations but hard to say for sure.
- You shouldn't be importing to REV02 so when you say they match, I assume you did it as a test.
- REV02 should have P2,G3 and Month.
- DAT02 should have P3, G3 and Month
- The reason why REV02 formula works without using SUM is because P3 belongs to P2 (child/parent). Anaplan already knows the relationship.
- Reimport to DAT02 if necessary
- When you look at values from REV02, start by looking at the highest P2 and G3 level. If it's still zero make sure the "SUM" summary is on the line item.
If all these things check out then you should be getting values to show up! You got this.
0 -
Hi @JaredDolich
Thanks for your help. I confirmed the detail above. When I use the dropdown, it looks like my locations are not mapping correctly (attached). I am stuck and still unsure of what I am missing?
0 -
Yep. Good catch. Your product hierarchy needs to be cleaned up. Your SKUs are not related to the products (P2). You have two options. Remove the orphaned SKUs by deleting them, or start over and reload the product hierarchy. If you start over you will need to reload all your modules that use product attributes and transactions. Sorry, probably not what you wanted to see. Somehow your product hierarchy didn't get built correctly. Always build it from TOP to BOTTOM. P1 first, then P2, then P3.
0
