Skip to Content
avatar image
Former Member

_sys_bi.M_TIME_DIMENSION no data available

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 23, 2017 at 07:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded