CODEWITHSUNDEEP
iccube
Philippe
Philippe

Reputation: 11

DATETIME while using "range from-to" link type in icCube

On icCube tools (v 5.1.4), how can I use the link type "Range (from-to)" based on a "DateTime" type on the dimension (instead of a Date type)?

You can reproduce my problem by downloading the cube here and modifying the type of the column "Order Date" and "Ship date" to "DATETIME" instead of "DATE" (line 14 and 15).

The validation process in icCube builder throw the following error: "link with incompatible types for dimension 'Calendar'. Dimension column 'Hour'- to fact column 'Ship date'-"

Many thanks for our help. Philippe

Upvotes: 1

Views: 89

Answers (1)

ic3
ic3

Reputation: 7680

It's a problem between the Time Dimension Wizard and the Validation, no other workaround than not using the Time Wizard if you need an hour level.

We've open an issue (available from 5.1.7)

Upvotes: 1

Related Questions