Skip to Content

How to change Week start day in HANA Table M_TIME_DIMENSION

Feb 07, 2017 at 09:33 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

On which level you are generating the data (e.g. on day level)?

* Please Login or Register to Answer, Follow or Comment.

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.

10 |10000 characters needed characters left characters exceeded