Smaller Time Range | Less than a year Time Range | Day granularity

Sachinsourav02 · 2024-03-19T08:05:37+00:00

There was an error rendering this rich post.

Anaplanners,

I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter.

We have a business requirement where we have to import and export working hours for each user per project per DAY. This activity will be monthly and may not be necessary to have more than a month, we can however plan to keep a month prior and after as back up data but its more good to have than an actual requirement.

Time ranges being minimum for a year will create a sparsity for the months we do not want to see for now.

Anyone with any previous experience, suggestions or workaround ?

I have tried creating a fake list that captures the month: using logic shared in this https://community.anaplan.com/t5/How-To/Modeling-Video-Series-1-Flexible-Time-Mapping/ta-p/93234 however, I'm hitting roadblocks when it comes to importing data into the fake time, as described in this question:

https://community.anaplan.com/discussion/157884/challenge-with-a-fake-time-list-data-import-native-time

Any suggestions or workaround would be appreciated in this.

Thank you

Accepted answers

All comments

PujithaB

Hi @Sachinsourav02
Try to create fake time list using Native Time , Then it will be helpful in terms of rollover and switching FY
Create a Sys Module with Native Time
Create an option to have how months of days required then you can create accordingly.
This will help you to manage mapping with Native time to Fake time list and can be used for Lookups in User data mappings.

Dikshant

The date that users are entering has to be in the same format. Let's say it should be 20240319, so that once you load it, the format should be the same. Would it be possible for you to share Anaplan screenshots and show how your file looks, and when you load it in Anaplan, what's the challenge?

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385