Level 2 Sprint 1 Volumes and Has Data? Query

KIRAIKAWAII
Contributor

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?

KIRAIKAWAII_0-1615853353029.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 2 Sprint 1 Volumes and Has Data? Query

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


Jared Dolich

View solution in original post

6 REPLIES 6
JaredDolich
Moderator

Re: Level 2 Sprint 1 Volumes and Has Data? Query

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


Jared Dolich
DaanishSoomar
Certified Master Anaplanner

Re: Level 2 Sprint 1 Volumes and Has Data? Query

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

 

You are very close!

KIRAIKAWAII
Contributor

Re: Level 2 Sprint 1 Volumes and Has Data? Query

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

 

KIRAIKAWAII_0-1615885801252.png

 

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
Moderator

Re: Level 2 Sprint 1 Volumes and Has Data? Query

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


Jared Dolich

View solution in original post

DaanishSoomar
Certified Master Anaplanner

Re: Level 2 Sprint 1 Volumes and Has Data? Query

Good catch @JaredDolich!

KIRAIKAWAII
Contributor

Re: Level 2 Sprint 1 Volumes and Has Data? Query

Thank you @JaredDolich and @DaanishSoomar !