BW Analysis Auth change history

[former_member318517]

Hello all,

Is there a table or report that shows the change history on a BW Analysis Authoirzation?

Thanks,

Tom

[Former Member]

Can't understand what exactly you are looking for "Analysis Auth change history " is that about a role , user , changed data ?

the normal way to get this is by SUIM = > changed data for roles, user and more.

Regards;

[Former Member]

Hi Tom,

The change log table fror analysis auths is RSECVAL_CL. There is a corresponding RSECVAL table which gives the analysis auth definition.

Regards,

Aninda

[former_member318517]

Thanks Aninda. That table doesn't show who made the changes but at least I can see the history of what was added or removed from the AA.

Tom

[sdipanjan]

Hi,

You may need to create a table join by using transaction SQVI. The tables need to be joined are RSECVAL_CL, RSECAUTHTRUSER and RSECLOG_CL. Foreign Key should be like below:

Field BNAME for RSECAUTHTRUSER and RSECLOG_CL.

Field SESSIONID for RSECLOG_CL and RSECVAL_CL.

regards,

Dipanjan