Hi all, working on SAP HANA SP12; Eclipse Oxygen with latest SAP Developement Tools.
I want to create a CUBE Calculation view with star join. The data foundation (fact) is a another calculation view, which has a column of the DATE datatype which I want to use to join to my Date dimension.
The Date dimension is also a calculation view of the DIMENSION type, subtype: Time variety, having a Date granularity. This gives me a calculation view having a DATE_SQL column, which is of the DATE type. I want to use this column to link to my data foundation.
Now the trouble starts. In my top-level CUBE calculation view, I created a projection node on my Fact calcview, which I then connect to the Star Join Node. I also dragged my Date dimension calcview into the star join. But I cannot make the join because of this error:
"Model inconsistency. Create Scenario failed: Datatype seconddate(8) of DATE_SQL does not match to datatype daydate(4) of attribute DATE_SQL "
The data type of the columns in both underlying calc views is DATE, so it should be fine to join them. But it turns out that, for some reason, the projection on my fact calcview uses SECONDDATE rather than DATE for the DATE column. I cannot seem to be able to change the data type in my projection.
Thoughts or suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.