Dynamic Time View Settings

0 Kudos

Dynamic Time View Settings

Purpose:
Retain views with multiple types of time scales/periods in the same view during YoY rollover, for multiple line items or list items, in a single view.

Example:
Dimensionality:

Vertical/Columns- Time/ Line Item
Horizontal/Rows- List Members

Display: 
Line item 1 - Year only
Line item 2 - Non-applicable (Display Full Year Only)
Line item 3 - Show all Months and Year as a summation type (SUM, All, Any, etc.)

Current Solution (Non-Sustainable for YoY roll over):
Hide the months for each line item that doesn't require months, use a filter from a time module to hide all Qtrs, and only display Mths and FY values.

 

Current Alternative Solution (For YoY roll over, but inefficient and causes Usability issues):
Create an end user view module, create line items for each intersection of month, year, and non applicable (Eg. Current Quota Jan 19, Current Quota Feb 19,..., Rep Name, etc.) and reference the calculation module and time module. During YoY roll over change the numbers for the line items names.

Intention/Possible Solution with platform change:
Set Dynamic Cell access/filter to booleans based off of intended date types/periods, within the line item as a method to manage referenced time module (use filter feature to target created dynamic period display grouping) I don't know of a good way to explain this clearly, sorry.

Alternative possible solution from a platform change:
Properties being displayed attached to each list member. (Not currently possible; think the 3rd export tab, but on views/modules, no longer having to reference in module if it is a property, displays only once in time utilizing modules after the list member)

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
1 Comment
Community Manager
 
Status changed to: Needs Community Support