Log report for Analysis Authorization

[sanjeevagatpa]

Hi All,

In BI, we have tables to check log for value, hierarchy , text and user assignment for Analysis Authorization.

Let me know to find the creation date of Analsysis Authorization.

below are the tables in which I tried to find the creation date of AA.

RSECHIE_CL

RSECHIE_CL_VIEW

RSECLOG_CL

RSECLOPDLOG_CL

RSECLOWDATE_CL

RSECSESSION_CL

RSECTXT_CL

RSECTXT_CL_VIEW

RSECUSERAUTH_CL

RSECVAL_CL

RSECVAL_CL_VIEW

regards,

sanjeeva

[sanjeevagatpa]

Hi Sanjeeva,

You can use RESECVAL_CL. Last column of your table should be timestamp OLAP which you can convert to the actual date and time using excel. This should give you the creation date and change date.

Please refer to the following on how to convert the timestamp to the realistic date and time:

MrExcel Message Board

Thanks,
Vishnu

[Former Member]

Hi Sanjeeva,

You can use RESECVAL_CL. Last column of your table should be timestamp OLAP which you can convert to the actual date and time using excel. This should give you the creation date and change date.

Please refer to the following on how to convert the timestamp to the realistic date and time:

MrExcel Message Board

Thanks,
Vishnu

[sanjeevagatpa]

Thank you Vishnu