Exporting Time Periods differences for different layout

I know it's written on Anapedia:
https://help.anaplan.com/export-layouts-and-time-period-labels-a274b42d-c982-4c87-9c70-626f1c446c60

Date format for Grid export layout is MMM YY while Tabular Single Column is YYYY-MM.

But why?

Accepted answers

All comments

yraviteja

Hello,

Because, this helps in filtering data in columns. YYYY-MM format data can be filtered easily. In Grid view, time will be considered as Headers. Hence, time format is MMM YY

Thanks,

Ravi

matthewman

Thanks - it gives some insight to why. In terms of filtering on Excel after export, I would imagine both can be filtered easily.

Moreover, if Anaplan can choose what date format we are importing from a .csv file, why can't we choose what date format we are exporting to a .csv file? Or even specify something as date formats before we export?

SriNitya

@mathewman Currently in Anaplan we don't have any date format selection for exports.

1636583

choosing date format before export would be a good modeling enhancement suggestion to the community @matthewman , and again it depends on our system time related settings how it looks in excel after export, I think 🤔.

Quick Links

Can you help?

Unanswered questions

Anaplan XL: About “Use Embedded Workbook Formatting (Preview)” option
We are currently experiencing an issue with the behavior when grid Auto Refresh is disabled. For our use case, it is important that the configured formatting is reflected before any manual refresh is performed. Therefore, we have enabled “Use Embedded Workbook Formatting (Preview)” as a workaround to have the formatting…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…