Level 2 Sprint 1 Volumes and Has Data? Query

Hi Everybody,

For some reason, in my Has Data? Query, I get this with the right formula, with everything true?

To get my volume upload to work, I had to change both the module and the volume line to "week" from model calendar - is this the issue? Not sure what else to show, the figures look as per the following models, so not sure how I have set this up wrong...

Thanks,

Kiraikawaii

Accepted answers

JaredDolich

@KIRAIKAWAII

Aha! I see the issue. Change the P3 SKU to SKU Flat. You should only use flat lists in the data hub.

You got this!!

All comments

JaredDolich

@KIRAIKAWAII

Yeah, you're super close. The DAT03 module should use a time range FY19. Your model Calendar should be FY20. I suspect that's the issue. You wouldn't be able to load the data into DAT03 using the model calendar unless you set it to FY19 so you'll need to change that back to FY20. Create a time range that spans FY19. Use that on SYS13.

DaanishSoomar

Agreed with @JaredDolich - keeping track of your time, model calendar, and time periods will help you out.

You are very close!

KIRAIKAWAII

Forgive me both, but this is my setting and not sure when you talk about resetting the calendar

When I the model calendar set, it wouldn't upload the data. Setting both the module AND the line item at 'week' time scale AND 'FY19' time range helped with the volume upload, but then had the above screenshot

Kiraikawaii

JaredDolich

@KIRAIKAWAII

Aha! I see the issue. Change the P3 SKU to SKU Flat. You should only use flat lists in the data hub.

You got this!!

DaanishSoomar

Good catch @JaredDolich!

KIRAIKAWAII

Thank you @JaredDolich and @DaanishSoomar !

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…