Time dimension ala OLAP

Hi,
I am working with KNIME mostly half year.
It quit impressive tool.
Unfortunately I do not understand how Knime handle time.
There are some time series but it is not how I am expecting .
When I want to see data on granularity Year I have to extract data from date.
When I want to see data on granularity Mont I have to extract data from date.
It is quit common function to create time dimension with functionality drill down.
See picture !
Here is example of cognos from IBM (http://bsc.ipportalegre.pt/documentation/en/images/ug_cogtr_relative_time_categories.gif)

image

Here is example from knime

Hi Marek,

Welcome to KNIME forum!

You can handle time in KNIME in a similar way as “congos” using this verified component " Aggregation Granularity" on KNIME Hub.

Here is a screen shot from the configuration of the component:

Feel free to explore KNIME Hub for workflows and components related to time series.

Best regards,
Hannan

1 Like

Hi,
uff no sure what should I do with this .
Thisa is only time dimension only?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.