Time Settings (From/To) on Excel Template

[willsuus]

Is there a way to show the Planning View Time Settings - From/To - on the Excel Template. I do not see any Named Ranges for these attributes as I do for SOP_Filter, for example.

When we do a summary tab that just gives totals for the months that we have included in the planning view, we would like to be able to show what the horizon is along with the data.

[lingaiahvanam · Accepted solution]

Hi,

Time settings will be updated during the planning view parameter selection.

Based on your selection parameters (attributes, time settings, key figures) data will be populated in the planning view and it carries the time buckets data accordingly.

Please let me know if you still have any questions.

Best Regards,

Lingaiah

[willsuus · Accepted solution]

Thank you for your response. Unfortunately, it doesn't address the question I asked. I understand how planning views work but need to know how to show the from/to values on the excel worksheet. If we place just a total on the sheet - for a range of months that roll, for example - we would like to be able to show what the start and end points are. For other planning view "attributes", like UOM, filters and currency, there are named ranges. I don't see one set up for the horizon starting and end points and was hoping there was another way to pull this information.