how to recognise any four-digit numeric value as the year while the data is loading into client workspaces, for example, 0202
Best answer by Jakub
View originalhow to recognise any four-digit numeric value as the year while the data is loading into client workspaces, for example, 0202
Best answer by Jakub
View originalHi,
I have a data value of "0202-08-12" for one of the date fields. The following error is being thrown while the data loads into the workspaces of the clients. Could someone please tell me how to accept these types of values in GoodData?
thanks,
Kavi
Hi Kavi,
Â
Using the date dimensions has some rules for both range (1900-2050Â ) and format
as specified here:Â
Â
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/manage-custom-date-dimensions/
Â
there is also an existing article here on community:
Â
Can you tell us little bit more about the use case and also confirm which product do you use ?Â
(above links are related to the GoodData Platform)
Â
Thanks,
Jakub
Hi Jakub,
Â
Thank you for the details. The goddata platform is what we use. I need to display "0202-08-12" in gooddata reports in this use case. Can dates below 1900 and above 2050 be displayed in Gooddata reports?
Â
Thanks
Â
Hi,
and thank you for the confirmation. You can create a custom date dimension and redefine the range but we do not recommend to go outside of range 1900 - 2100
Â
Second link I provided contains relevant info:
Extended Date Dimensions
By default, theÂ
urn:custom_v2:date
 date dimension template contains data for the Gregorian calendar from 01/01/1900 to 12/31/2050. You can extend date dimensions in custom calendars beyond the default to cover dates from 01/01/1900 to 12/31/2100. However, wider defined ranges may result in slower performance. To improve performance when using custom date dimensions, do not use unnecessary ranges outside of your data and analytical use cases. For example, if you only need to analyze 2010 to 2030, keep your custom dimension between those dates.If you need to cover dates up to 12/31/2100 but you want to avoid potentials performance issues, you can download urn_custom_v2_date_2100.csv.zip. This date dimension template contains dates from 01/01/1950 to 12/31/2100.
Â
Â
Does the 0202 mean year 202 ? Or is it just a formatting issue and it should be 2020 ? In that case you can reformat the data before you load it.
Generally he functionality is built to work with gregorian calendar and custom fiscal calendars.
We do not see many requests for bigger range that is why I wonder about the use case.
I remember a customer question, I think it was about use of Nepali calendar and unfortunately the custom calendar that you want to upload and the current calendar must be also consistent in terms of time intervals. Otherwise, uploading can cause big inconsistencies.
Regards,
Jakub
Hi Jakub,
Â
Thanks for the valuable information.
Â
Thanks,
Kavi
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.