Level 1 Cert Exam - Data02 SKU Volumes

[JimMcL]

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.

[einas.ibrahim]

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.

[JimMcL]

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]

[einas.ibrahim]

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? 

[JimMcL]

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.

[JaredDolich]

@JimMcL 

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.

[JosephA]

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

[wadetse]

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.

[noelle_murphy]

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

[einas.ibrahim]

Hello @JimMcL 

No data as in blank or zeros?

1. Follow what @JaredDolich said. He is way more generous than me in giving directions.
2. Check the Summary method of the Volume Line Item in the target module.
3. Ensure that you actually have data in the source module

Let us know and probably provide screenshots of the blueprints.

Good Luck