Pentaho: Best way to convert date to cube size measurement?

Question

My datawarehouse table contains only one SQL column date, but I want to be able to expand using normal levels of year / quarter / month / day.

I could manually create a new column using the Pentaho Kettle, and then create the levels one by one in the Pentaho Schema Workbench.

But this is such a common task (I think everyone who creates cubes related to sales should do this), so I'm sure Pentaho has developed something for this in a matter of seconds. What is the recommended way to do this?

Answer 1

I do not know how to do that.

, : "" ​​/, .

:

Date (date) - 2010-09-28
Day (int) - 28
Month (int) - 9
Year (int) - 2010

, : , , , ..

. , , , , .

, , , , , . , .