There’s great documentation around using dates, but does GoodData have any support for date_time types? This would be really useful for continued drill down beyond day level, into the hour/minute. This would be particularly useful dealing with a data set like IoT sensor readings.
Has anyone any suggestions for workarounds, or am I missing something?
Thanks
James
Best answer by Joseph Heun
View original
The following article discusses a bit on how to create a custom time dimension.
However, this article is based on CloudConnect to model the data, but this can also be done in the modeler of your project under the Data Integration Console. You will just need to model the dimensions as shown in the article. Then, you will need to prepare the data in your datawarehouse, and load it to GoodData.
Hello James,
What about separation of hour information into new attribute in fact table where specific date dimension is connected to ? That gives you potential to better use information stored and also you can visualise your information on hourly level.
Richard
Thanks
Thanks
James
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.
