Skip to Content
avatar image
Former Member

How to change Week start day in HANA Table M_TIME_DIMENSION

We have initially generated Time dimension in HANA with week start day as 'Sunday' . Now the business has come back to change the Week Start day as 'Monday' .

Just wondering, how can we change the data in the table M_TIME_DIMENSION. We have delete the data from all the M_TIME tables and try to Re-Generate Time Data. When we try to generate second time, we don't get the option Week Start day. Week Start Day is missing in the Generate Time Data for second time.

First time when we generated, we can able to select the Week start date.

Can you please advice, how to re-generate with changing the week Start day.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 14, 2017 at 07:34 PM

    I am generating at Day level. I tried changing it to week level as well. But it did not shows me, week start day option when we generate second time.

    For now, I found the work around . My SAP HANA Studio Version is 2.3.10 . When i try to change to week level as, it does not give me option second time to change the week start day.

    But my colleague as HANA studio lower version, when we try to generate at week level. It shows the week start day.

    Add comment
    10|10000 characters needed characters exceeded