06-20-2016 11:45 AM
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
06-20-2016 2:19 PM
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:
Thanks,
Vishnu
06-20-2016 2:19 PM
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:
Thanks,
Vishnu
06-20-2016 3:46 PM