Skip to Content
avatar image
Former Member

Time Based Modelling using Calculated Column VS Generated Time Dimension

Hi All,

Below is my Data Model.

DSO (BW) --> Analytic View (HANA Studio) --> Cal View (HANA Studio) --> Virtual Provider (BW)

Now, in my base DSO there is no CalYear but there is a WorkDate. So, I have created a Calculation Column in a projection

of my Calc View with the logic "midstr("WORKDATE",0,4)".

My model is working fine and I'm able to get my desired output.

Now I have read a few blogs and came to know about Time base modelling using Time Dimension in HANA Studio

i.e you would generate a Time Dimension in HANA Studio and then use this Time Dim in your Analytic View using

a JOIN between your FACT and TIME_DIM.

Could anyone shed some light on which is a better approach ?

PS : In my base fact table i.e my DSO I don't have a time dimension for me to do a JOIN between HANA generated Time Dimension

       all I have is WORKDATE

Kind Regards,

Ashwin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 21, 2015 at 11:15 AM

    hi, Ashwin, the answer will largely depend on your exact situation, most importantly on two factors: data volume and requirements.

    If if we talk about a CalculatedView without forced SQL Execution, your data volume is large and your requirement is to display the data on aggregated level only (just the year and month, without the WORKDATE itself), I would use the formula (like you did) and immediately aggregate.

    If your data volume is ok, you anyway really need CATS document number, dates, etc., I would probably join to time dimension. Plus add the texts for quarters/months/weeks, too.

    And then test with PlanViz and post your outcome back here 😊

    Cheers,

    Dmitry

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      I have found an easy way to do it in BW, I just brought in Time Dimension into my BW DSO and

      then went ahead with my current model.

      DSO (BW) --> Analytic View (HANA Studio) --> Cal View (HANA Studio) --> Virtual Provider (BW)

      Kind Regards,

      Ashwin