Level 1 Cert Exam - Data02 SKU Volumes

Highlighted
New Contributor

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.

6 REPLIES 6
Highlighted
Valued Contributor

Re: Level 1 Cert Exam - Data02 SKU Volumes

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.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 1 Cert Exam - Data02 SKU Volumes

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]

Highlighted
Valued Contributor

Re: Level 1 Cert Exam - Data02 SKU Volumes

HI @JimMcL 

When do need 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? 

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 1 Cert Exam - Data02 SKU Volumes

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.

 

 

Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Cert Exam - Data02 SKU Volumes

@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.

 


Jared Dolich
Highlighted
Valued Contributor

Re: Level 1 Cert Exam - Data02 SKU Volumes

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

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"