Search code examples
datetimegooddata

How to load time in GoodData?


How can I refer hour of day (HH:) from Date type attribute for which I have uploaded data by the format of yyyy-MM-dd HH:mm:ss from the source? Date attributes seem only to provide date without hour as default.


Solution

  • We are currently working on new implementation of date dimensions. So to have some solution now, what I suggest you is to follow this steps.

    1. Execute MAQL DDL that will create time dimension (only once)

    2. Open LDM model -> Import from previously created Model -> Finish manually your model (connect time dimension to the rest of your model)

    3. Load Data to Time Dimension (see the comment in the attached example)

    4. Transform original date time on input to fit in the Model -> See the Reformat component in the step 3

    Download full example and go through each step to understand the workflow here. As I said this is kind a workaround. We are working on making this smooth and straightforward. After we launch the new Date dimension implementation, the process will be much more easier.

    Feel free to contact me directly if you need any assistance! ([email protected])