Switching from Model Calendar to Time Ranges

Megha27
Megha27
in Modeling

Hi Community Members,

My model currently has 6 future years in it, with Calendar Type as Months/Quarters/Years and no time ranges. I dont need month level data outside of next year so instead of months for years say FY25 and so on.. I only want them on the consolidated FY level so I can reduce my model size. I would also like to be able to have the FY number evenly spread out when I want it across months, if possible. I believe time ranges would help me do that but I have no idea how. Can anybody help me get started here?

Thanks,

Megha

Answers

  • AlejandroGomez
    AlejandroGomez

    Hi @Megha27

    You are right, time ranges is what you need!

    There is no functionality to have telescopic time ranges in Anaplan in the way you describe it. In other words, using filters we can display time at different granularity creating a telescopic report but the underlying time granularity will remain in months, hence consuming all that space you want to save.

    So, my suggestion to you in order to optimise space is:

    1. Create a time range with 1 year, the one you want to display in monthly buckets. Then use it in module A.
    2. Create a new time range, with years 2 to 6 (the ones you want to display in yearly buckets). Then use this time range in module B. (Please, note that Modules A and B are exact copies, the only difference is the time calendar and time granularity settings)
    3. Publish modules A and B on the same page, with the time dimension across columns

    In this way you will get to report the same data with different time granularity without creating sparse modules.

    About this: "I would also like to be able to have the FY number evenly spread out when I want it across months, if possible". If I have understood correctly, you can use the function yearvalue and split by 12, to get the annual value evenly spread across all months in the year. Something like this:

    To get the annual sales value evenly spread across all months within the year, you need 2 lines items:

    1. Line item "Sales" contains the actual sales per month
    2. Line item "Even Sales", which function is: YEARVALUE(Sales) / 12

Categories