Time Scale changes

Hello, Please do let me know if there a way to rename the Time period Label of Year? For eg FY2015, FY2016 etc. to 2015 or CY2015. Thanks, Suneesh

Accepted answers

All comments

PrevContributor

Hi Suneesh,

As of right now there is no way to change the standard date format display. However, a workaround would be to use a formula that reformats based on the result in the timescale column. Unfortunately that wouldn't replace the standard timescale column, feel free to let me know if you'd like more details on this workaround approach.

-Chris Weiss

Alessio_Pagliano

Hi,

I would find helpful to see an example/more details on this approach, please .

Thanks,

PaulRitner

Hi,

There are two contexts for examples:

Where we don't like the column headers, or,
Where we have a line item that reformats a date or time period value

For item 1, the only way to change the format of the native timescale column header is to use a false time dimension (for the related reports and map Anaplan time periods into the false time periods). In this case, it might be addressed as follows:

Create a list named TimeList (or something)
- Call the items in the list whatever you need. For example
  - Total
    - Jan
    - Feb
    - Mar
    - etc...
- For each item in the list, we will either map the item to an explicit period, or calculate the mapping if the list is used in conjunction with another dimension (such as native Anaplan time in years)
  - If explicit reference, just create a property and map the period. this implies that the list items are named to specific month/year combinations.
  - If relative to years (which allows for a clean month header, like the list item examples above), Add a module with Time in Years and your TIMElist. Then add a line item to calculate the period based on the intersections between anaplan time in years and the TIMElist items.
    - Note, you will need to map each month in your TIME list to a numeric month value. For example, Jan=1.
    - The intersection of Jan and FY 2018, therefore, should calculate to Jan 2018... the formula will look something like Period( Date( Year(Item(Time)) , TimeList.MonthNumber, 1) )
    - The result can be used as a lookup reference from a source data module.
  - I typically avoid adding this extra layer of configuration, unless there is a strong motivation. It happens most frequently where there is a need to format things as simply as possible for executive types.

I'm a little short on time today, but let me know if you want an example, I can dig one up.

Paul

Alessio_Pagliano

Hi Paul,

That's very helpful. We would need to rename the standard Anaplan FYxx to Year1, Year2, etc.

It seems the first approach I tried was the one you mentioned on point 1 but I was struggling to get the lookups to work.

If there was an example I could look at, that would be super !

Thanks a million for your help.

Alex

PavanKumar

Hi Alex,

Steps to acheive your requirement:

1. Create a dummy time period list (List members will be 2015, 2016, 2017 etc)

2. Create a property in the list created above, say e.g i will name the property as "Anaplan Time Period". And Format that property to "Year".

3. Mannually map the Anaplan time to newly created list.

4. Use the new list created in your reporting modules. And, bring the values from modules using anaplan default time by looking to "Anaplan Time Period" property created above.

Hope this helps.

Regards,

CA Pavan Kumar

PaulRitner

Hi,

Here's a simple example showing how to aggregate Native Anaplan Time data into a False Time (reporting) module (attached).

Cheeers!

Paul

False_Time_Example_35109.docx

Alessio_Pagliano

Very interesting, I will take a better look at it tomorrow !

I might have a question you could easily help with :')

THanks!

Alessio_Pagliano

Good morning,

@PaulRitner, thanks a lot for sharing that approach. I still need to review the attachment 🙂 My first impression is that I might be able to use it in the future but I need to fully understand it and run some tests. If I understand it correctly you have re-engineered the aggregation on a false time dimension.

On the specific use case I'm working on I decided to use the time dimension because there were too many time-specific functions I wanted to make sure I could use eg cumulative, previous, next and others....

I therefore thought the easiest approach was to "plug in" reporting modules at the end and relabel the time accordingly using a list/property.

However 🙂 I've got one last specific example I'm struggling with : this time the relabelled time is on an Input module and the fake time dimension is on the "across", not on the "down" dimension....

Attached picture should give a feeling of what I've got...I was planning to create a module dimensioned by the fake year dimension and then amend the current one to lookup the value typed in by the user. However, it seems I'm failing miserably on the lookup. It seems I'm missing something obvious. Any clues or hints&tips ?

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…