Re: Regarding "Generate Time Data" Option in HANA
I just have another question on generation of Time data. Is there a way to generate these data in our local schema rather than the standard _SYS_BI schema ? This is because we need to provide additional permissions to access the Time dimension table from _SYS_BI and copy selected columns on to our schema.
Basically, the requirement is, i need to generate all the DATES for the given year. So i will be only interested on DATE_SQL column of _SYS_BI.M_TIME_DIMENSION table. So is there any way i can generate this column alone in our local schema ?