Skip to Content
avatar image
Former Member

Dynamic time and NULL values

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…

capture.png (68.4 kB)
capture3.png (6.0 kB)
capture2.png (51.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 12:44 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded