Steps to be followed while accessing Reports based out of Auditing unv/unx.
As most of you are aware that the Sample Auditing unx/unv along with the sample reports are available in SCN @http://scn.sap.com/docs/DOC-53904
However there is a problem observed for one of the dimension part of Auditing universe.
This is for the users who are using the audit reports which are based out of Auditing.unx. where the Event status – successful/failed field is part of the audit report will show most of the status as failed despite they are successfully audited.
This is noticeable only when the users are trying to retrieve the Event status – successful/failed dimension from the Auditing.unx during that time almost all of them are showing it as failed.
The reason for this behavior is the query condition mentioned for the Event status – successful/failed is wrong and need an update.
Here are the steps to modify one of the dimension in the Auditing.unx.
1) Open the Universe using Information Design Tool (IDT) for BOE 4.x.
2) Traverse to the Events table and select the dimension Event status – successful/failed and double click on that, You can notice the query on the Query panel as “ADS_STATUS_STR.Status_ID WHEN 0 THEN ‘Successful’ ELSE ‘failed’ END” which is not the correct condition.
3) Please replace the Query with “ADS_STATUS_STR.Status_ID WHEN 1 THEN ‘failed’ ELSE ‘successful’ END”.
4) Save and Publish the Universe back to repository
5) Refresh the Report.
Note: This is required only to support the Event_Type_ID (1008) Save, the reason being Save has 3 successful status (0,2,3) and 1 failed status where as all other events has only one successful status (0) and one failed status(1).