topic Log report for Analysis Authorization in Application Development and Automation Discussions

Log report for Analysis Authorization

sanjeevagatpa — Mon, 20 Jun 2016 10:45:29 GMT

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

Re: Log report for Analysis Authorization

Former Member — Mon, 20 Jun 2016 13:19:21 GMT

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

Re: Log report for Analysis Authorization

sanjeevagatpa — Mon, 20 Jun 2016 14:46:06 GMT

Thank you Vishnu