Skip to Content
0

_sys_bi.M_TIME_DIMENSION no data available

Jul 20, 2017 at 12:22 PM

103

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

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

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

1 Answer

Anjali Chimnani
Jul 23, 2017 at 07:17 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded