Dynamic time and NULL values

[Former Member]

Hi

Im trying to create a dynamic time dimension and struggle with NULL values in the start schema. I always see a NULL value that shows the aggregated vault of the records Im not interested in. Here is what I have done:

1. Imported a time table
2. Created two calculated view with script view, one for all the dates and one for the current day.
3. Created a calculated view to run union on the two views created in step 2.
4. Created a start join view and joined the fact table to the date field that has all the dates.

Here is the result… Got any tips for removing the NULL value in HANA? I know I can do it in Lumira but it’s not so user friendly…

[Former Member]

Hi

Thanks your your question, this will make my proplem more clear 🙂

I want to create a time dimension with some time hierarchy. One hierarchy shall contain all the dates(Year-> quarter -> Month-> Week->day) I will then add more hierarchy's to the same view but with other time frames like year to date, current week with additional columns.

In a start join view I can only have one relation between a fact column and a dimension table, so I need to join with the column that has all the dates. I can the use the union functionality to get only the record I like to see, but I also get one NULL value.

[pfefferf]

Stupid question from my side, but why you are not define a filter expression which filters out Null values. If it is correct that the base data source columns have null values you have to do that if you wanna remove that null values already on calc. view level.

Regards,
Florian