How to build a model for daily report

Hi, Anaplan does not have daily time dimension, however I want to build a model for daily sales report. Could you tell me how to implement a report on a daily basis? Thanks, Maki Yasuda

Accepted answers

All comments

harish_bk

Hi Yasuda

1) Please create on general list and have the details as day 1, day 2, day 3 so on.
2) Create a module having the day list and one line item which is list formatted time
3) Then look up days to anaplan time like

Day 1 - Jan - 16
Day 2 - Jan - 16
Day 32 - Feb - 16

So on
4) When pulling time to regular anaplan then you can lookup to the module above and write the formulas and get the values by month.

tatsuo_oba

Yasuda-san,

You can choose 'Time Scale' for each line items under monthly calender setting and manage daily based number with Anaplan.
Also you can choose day, week or month under weekly calender for each line items.
Please try that.

Best regards,
Tatsuo Oba

harish_bk

Hi Yasuda

The one which Tatsuo has suggested is more aligned and better than what I have suggested, I missed the time scale at the module level while giving you my solution.

Please follow the solution suggested by Tatsuo

PrevContributor

Hi Harish and Oba-san,
Thank you for the information on 'Time scale'.
This is very helpful for building a model for daily report.
Thanks!
Maki Yasuda

michel_maurel

Hi,
yes the native daily scale from Anaplan is the good solution

Lots of functions only work when having a timescale in modules.

Kind regards.
Michel;

michel_maurel

Hi,
if you are running a daily report, of course you will need Anaplan Connect to feed the data.

I found it usefull to feed the last 6 to 7 days every night. That allows us to cope with potential extracting issues out of databases.

Kind regards.
Michel.

Quick Links

Can you help?

Unanswered questions

Why are users losing connection to the Apps
When a workspace Administrator does a model to model migration and chooses not to take the model offline, does the system still close people out of the Apps?
App Hub
Would someone advise how to find the App hub. I am following the module directions but I do not see it on my end.
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…