Skip to Content

Dynamic time and NULL values

Sep 21, 2017 at 11:43 AM


avatar image


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…

capture.png (68.4 kB)
capture3.png (6.0 kB)
capture2.png (51.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Florian Pfeffer
Sep 21, 2017 at 12:32 PM

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.


10 |10000 characters needed characters left characters exceeded
Petter Huseby Sep 21, 2017 at 12:44 PM


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.

capture4.png (66.3 kB)
10 |10000 characters needed characters left characters exceeded