cancel
Showing results for 
Search instead for 
Did you mean: 

Delete the "Generated Time data" HANA Live HANA SPS07

kishore_kumar59
Participant
0 Kudos

Hi Team

as part of completing HANA system setup for HANA Live it is required to  "generate the time data" which i did for all the Granularities i.e., YEAR,Month,week,Day,Hour and Seconds.

and i realized the it will take up too much space on DB, now i wanted to UNDO / delete / get rid of the data which i generated for Hours and Seconds Granularities,

is this something possible or what are the options i have.

thanks

Kishore Ch

Accepted Solutions (0)

Answers (1)

Answers (1)

RashmiAcharya
Advisor
Advisor

Hi Kishore,

Time data generated for granularities Day,Hour and Second will be stored in schema  "_SYS_BI" table "M_TIME_DIMENSION". IF you wanto delete the genrated time data for these you can excecute delete querry from SQL editor on this table.

Delete from "_SYS_BI"."M_TIME_DIMENSION"

Regards,

Rashmi

kishore_kumar59
Participant
0 Kudos

Hi Rashmi

Thanks for the update.

does Delete from "_SYS_BI"."M_TIME_DIMENSION" , will delete all the data or just for the "minutes" and "seconds" granularities.


Thanks

Kishore Ch

Former Member
0 Kudos

Hi Kishore,

Delete from "_SYS_BI"."M_TIME_DIMENSION" This sentence will delete all the data in table "_SYS_BI"."M_TIME_DIMENSION".


Best regards,

Wenjun

Former Member
0 Kudos

i had the same issue with memory full

I delete everything in the table but it did not free memory and i still a a full

/vol/vol_HDB/data file system

how can i clear it