Skip to Content
Former Member
Sep 21, 2017 at 11:43 AM

Dynamic time and NULL values



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)