Creating SAP BO Custom Audit reports
Just recently, I was tasked to develop a Business Objects Webi report that displays the list of all users within the system along with their last login dates. As simple as this project may sound, it involved some crucial steps and tweaks to the SAP BO Audit universe that is provided by SAP. In this blog, I will share information on how I was able to successfully accomplish my goals for creating this Webi report.
I was working with SAP BI 4.1 sp6 with a SQL server database back-end for storing the infostore and audit data.
Here is the list of steps that I had to go through in order to successfully complete the project:
Date user last accessed BOBJ
Number of days in prior month user accessed BOBJ"
Step1: Open Web Intelligence tool from BI Launchpad and select Universe as source:
Step2: Select BI Platform Auditing universe
Step3: Select required fields as shown below
Step4: Specify your period
Step5: Select "Start datetime" column and apply "MAX" function as shown in the picture
Step7: To convert date formats Select "User last Accessed" column->Select "Formatting" tab->Select "Numbers" subtab and then select required Date format..
Step8: Now create a new Variable to find out no of users logged in for the given period
Step9: Give the formula as shown in the picture
Step10: Drag the new variable into result pane as shown
Step11: In order to have the column heading as shown in the screen shot use the below formula at the heading cell
="No of Times User Logged Between : "+ FormatDate(ToDate(UserResponse("Events Started After") ;""); "MM/dd/yyyy") + " -" + FormatDate(ToDate(UserResponse("Events Started Before") ;""); "MM/dd/yyyy")
Hope it is useful...
Mary Margaret Reddy
Mouritech Global Enterprise Solution.