_sys_bi.M_TIME_DIMENSION no data available

[hasila_amjath]

Hi experts,

generate time data is done without errors,

but there is no data in the time dimension table.

kindly help me if i am missing some other steps before running the time generation.

Regards,

Hasila

generatetiemdata.jpg

m-time-dimension.jpg

[pfefferf]

Please can you share what options you have used to generate the data?

[Former Member]

Hi,

It depends on the granularity of the data with which the time is generated.

There are different tables now for different granularity.

If you generate data for day or any lower (hour, minute or second) granularity, it shall appear in the M_TIME_DIMENSION table else it shall go to respective time tables in the same schema.

Thank you.

Best Regards,

Anjali.