understanding the audit
play

Understanding the Audit Database in SAP BI 4.x - PowerPoint PPT Presentation

Mar 08, 2024 •5 likes •245 views

Understanding the Audit Database in SAP BI 4.x adam@alangeconsulting.com RESOURCES http://help.sap.com/bobip42 See: Business Intelligence Platform Administrator Guide (Chapters 23 24) ADAM@ALANGECONSULTING.COM SAP WEBINAR

  1. Understanding the Audit Database in SAP BI 4.x adam@alangeconsulting.com

  2. RESOURCES http://help.sap.com/bobip42 See: Business Intelligence Platform Administrator Guide (Chapters 23 – 24) ADAM@ALANGECONSULTING.COM

  3. SAP WEBINAR https://youtu.be/ll9G2JEWb9Q SAP Business Intelligence 4.2: New Auditing Universe and Reports ADAM@ALANGECONSULTING.COM

  4. WHAT IS AUDITING? The SAP BI platform can record activity on the system, such as: – Which users are logging in and when? – Which reports are being run and by whom? – Who deleted an object? – Who is creating or modifying reports? – And so on… • Does not record system content, security, metadata ADAM@ALANGECONSULTING.COM

  5. AUDIT ≠ CMS The audit database records activity. The CMS database records content and configurations. ADAM@ALANGECONSULTING.COM

  7. ODBC Configure 32-bit and 64-bit ODBC connections to the audit database ADAM@ALANGECONSULTING.COM

  8. AUDIT UNIVERSE Download auditing universe and reports (LCMBIAR files) and install via Promotion Management in CMC https://blogs.sap.com/2015/07/15/unlock-the-auditing-database- with-a-new-universe-and-web-intelligence-documents-for-bi41/ ADAM@ALANGECONSULTING.COM

  10. AUDIT UNIVERSE Retrieve a list of Web Intelligence reports viewed (i.e. opened) since February 1, 2018. ADAM@ALANGECONSULTING.COM

  11. AUDIT UNIVERSE List of users logged in since January 1, 2018. ADAM@ALANGECONSULTING.COM

  12. AUDIT UNIVERSE List of users from the Finance Universe Group who have logged in since January 1, 2018. ADAM@ALANGECONSULTING.COM

  13. AUDIT DATABASE TABLES * ADS_Event: Main log table ADS_Event_Type_Str: View, Delete, Logon, etc. ADS_Object_Type_Str: User, Web Intelligence, etc. ADS_User: Table of users and user names ADS_Event_Detail: Supplemental information about each transaction, e.g. universe name, user group * This is a partial list of tables in the Audit (ADS) database

  14. AUDIT DATABASE TABLES * ADS_EVENT * This is a partial list of tables in the Audit (ADS) database

  15. AUDIT DATABASE TABLES * ADS_EVENT_TYPE_STR ADS_EVENT * This is a partial list of tables in the Audit (ADS) database

  16. AUDIT DATABASE TABLES * ADS_EVENT_TYPE_STR ADS_OBJECT_TYPE_STR ADS_EVENT * This is a partial list of tables in the Audit (ADS) database

  17. AUDIT DATABASE TABLES * ADS_EVENT_TYPE_STR ADS_OBJECT_TYPE_STR ADS_EVENT ADS_USER * This is a partial list of tables in the Audit (ADS) database

  18. AUDIT DATABASE TABLES * ADS_EVENT_TYPE_STR ADS_OBJECT_TYPE_STR ADS_EVENT ADS_USER ADS_EVENT_DETAIL * This is a partial list of tables in the Audit (ADS) database

  19. AUDIT DATABASE TABLES * ADS_EVENT_TYPE_STR ADS_OBJECT_TYPE_STR ADS_EVENT_DETAIL ADS_EVENT _TYPE_STR ADS_USER ADS_EVENT_DETAIL * This is a partial list of tables in the Audit (ADS) database

  20. AUDIT SQL EXAMPLES * SELECT E.User_Name, MAX(E.Start_Time) Most_Recent_Logon, COUNT(*) Logins FROM ADS_EVENT E INNER JOIN ADS_EVENT_TYPE_STR T ON E.Event_Type_ID = T.Event_Type_ID AND T.Language = 'EN' WHERE T.Event_Type_Name = 'Logon' AND E.User_Name <> '' AND E.User_Name IS NOT NULL AND E.Start_Time >= CONVERT(DATETIME,'11/01/2017',101) GROUP BY E.User_Name * Syntax applicable to SQL Anywhere

  21. AUDIT SQL EXAMPLES * SELECT E.Object_ID, E.Object_Name Report_Name, FOLDER1.FOLDER_NAME + ISNULL(' > ' + FOLDER2.FOLDER_NAME, '') Folder, COUNT(*) Runs, COUNT(DISTINCT E.User_Name) Users, MAX(CAST(FLOOR(CAST(E.Start_Time AS FLOAT)) AS DATETIME)) Last_Opened FROM ADS_EVENT E INNER JOIN ADS_EVENT_TYPE_STR T ON E.Event_Type_ID = T.Event_Type_ID AND T.Language = 'EN' INNER JOIN ADS_OBJECT_TYPE_STR O ON E.Object_Type_ID = O.Object_Type_ID AND O.Language = 'EN' LEFT JOIN (SELECT F1.Object_ID, MAX(F1.Object_Name) FOLDER_NAME FROM ADS_EVENT F1 INNER JOIN ADS_OBJECT_TYPE_STR O1 ON F1.Object_Type_ID = O1.Object_Type_ID AND O1.Language = 'EN' WHERE O1.Object_Type_Name LIKE '%Folder%' GROUP BY F1.Object_ID) FOLDER1 ON E.Top_Folder_ID = FOLDER1.Object_ID LEFT JOIN (SELECT F1.Object_ID, MAX(F1.Object_Name) FOLDER_NAME FROM ADS_EVENT F1 INNER JOIN ADS_OBJECT_TYPE_STR O1 ON F1.Object_Type_ID = O1.Object_Type_ID AND O1.Language = 'EN' WHERE O1.Object_Type_Name LIKE '%Folder%' GROUP BY F1.Object_ID) FOLDER2 ON E.Folder_ID = FOLDER2.Object_ID WHERE O.Object_Type_Name = 'Web Intelligence' AND T.Event_Type_Name = 'View' GROUP BY E.Object_ID, E.Object_Name, FOLDER1.FOLDER_NAME + ISNULL(' > ' + FOLDER2.FOLDER_NAME, '') ORDER BY COUNT(*) DESC * Syntax applicable to SQL Anywhere

  22. REPORT COMMENTARY Comments posted on Web Intelligence reports are stored in the Commentary_Master table ADAM@ALANGECONSULTING.COM

  23. NEXT STEPS 1) Download and review BI Platform Admin Guide (Chapters 23 – 24) 2) Create 32-bit and 64-bit ODBC 3) Set auditing parameters in CMC 4) Install SAP auditing universe and sample reports ADAM@ALANGECONSULTING.COM

  24. Q&A ADAM@ALANGECONSULTING.COM

Recommend

Understanding Your Degree Audit What Is The Degree Audit +Advising tool used by college advisors

Understanding Your Degree Audit What Is The Degree Audit +Advising tool used by college advisors

Understanding Your Degree Audit What Is The Degree Audit +Advising tool used by college advisors and students to monitor academic progress +Assists students in registering for appropriate courses by breaking down graduation requirements

415 views • 17 slides
The ERISA Audit: Your Fiduciary Responsibilities and Other Considerations Lara E. Fuller, CPA Audit

The ERISA Audit: Your Fiduciary Responsibilities and Other Considerations Lara E. Fuller, CPA Audit

The ERISA Audit: Your Fiduciary Responsibilities and Other Considerations Lara E. Fuller, CPA Audit Senior Manager AGENDA Understanding your responsibilities Communication Understanding common errors YOUR RESPONSIBILITIES The Plan

414 views • 15 slides
Farmersville, Texas Audit Presentation September 30, 2017 Presented By: Louis Breedlove, Audit

Farmersville, Texas Audit Presentation September 30, 2017 Presented By: Louis Breedlove, Audit

Farmersville, Texas Audit Presentation September 30, 2017 Presented By: Louis Breedlove, Audit Manager June 26, 2018 1 OVERVIEW OF THE AUDIT PROCESS Audit Planning and Risk Assessment Audit Standards The audit was performed in

425 views • 13 slides
Guidelines for Planning an IS Audit Agenda Session Objectives Information Systems Audit

Guidelines for Planning an IS Audit Agenda Session Objectives Information Systems Audit

San Francisco Chapter San Francisco Chapter Guidelines for Planning an IS Audit Agenda Session Objectives Information Systems Audit Planning and Scoping Understanding Business Requirements Knowledge of the Organization

596 views • 32 slides
Section 3 Risk ASJ Stages of an Audit Audit Approaches ASJ In this approach, audit

Section 3 Risk ASJ Stages of an Audit Audit Approaches ASJ In this approach, audit

ASJ Section 3 Risk ASJ Stages of an Audit Audit Approaches ASJ In this approach, audit resources are targeted on testing large volumes of transactions and account balances without any particular focus on specified Substantive areas of

271 views • 16 slides
QI TALK TIME Building an Irish Network of Quality Improvers Healthcare Audit for Understanding

QI TALK TIME Building an Irish Network of Quality Improvers Healthcare Audit for Understanding

QI TALK TIME Building an Irish Network of Quality Improvers Healthcare Audit for Understanding &amp; Improving 5 th June 2018 Connect Improve Innovate Speaker Speaker: Cora McCaughan MSc (Hons), BSc (Hons), Dip Project Management (With

986 views • 43 slides
Presentation on Bank Audit Audit Procedures, LFAR, Tax Audit, Certification , Demonetization etc.

Presentation on Bank Audit Audit Procedures, LFAR, Tax Audit, Certification , Demonetization etc.

Presentation on Bank Audit Audit Procedures, LFAR, Tax Audit, Certification , Demonetization etc. VIP Chartered Accountants Study Circle By Rishi Khator FCA, CPA(US), CIFRS March 26, 2017 Traditional banking to high level financial

868 views • 64 slides
Enhancing Governance Through Internal Audit Activities Kaveh Rikhtegar, CPA, CA, CISA, CIA

Enhancing Governance Through Internal Audit Activities Kaveh Rikhtegar, CPA, CA, CISA, CIA

Enhancing Governance Through Internal Audit Activities Kaveh Rikhtegar, CPA, CA, CISA, CIA Director of Internal Audit Canadian Commercial Corporation Key Points Understanding your audience and the Governance framework, Building an

637 views • 53 slides
Striving Towards a Better PRESENTATION HERE&gt; Audit in 2017 Who we are At Audit Solutions

Striving Towards a Better PRESENTATION HERE&gt; Audit in 2017 Who we are At Audit Solutions

&lt;INSERT TITLE OF Striving Towards a Better PRESENTATION HERE&gt; Audit in 2017 Who we are At Audit Solutions Queensland, our focus is on providing a comprehensive, independent and efficient audit process. Our difference is our personal

606 views • 59 slides
Task: Draw up an audit programme Please take the following facts and instructions as a basis: The

Task: Draw up an audit programme Please take the following facts and instructions as a basis: The

Audit Case Workshop about applying the checklist on Financial Audit of Public Procurement Task: Draw up an audit programme Please take the following facts and instructions as a basis: The audit plan for the next six months includes an audit of

229 views • 5 slides
Audit Partner Characteristics, Audit Quality and Audit Pricing in the U.S. Ally Zimmerman,

Audit Partner Characteristics, Audit Quality and Audit Pricing in the U.S. Ally Zimmerman,

Audit Partner Characteristics, Audit Quality and Audit Pricing in the U.S. Ally Zimmerman, Northern Illinois University, azimmerman5@niu.edu Al Nagy, John Carroll University, alnagy@jcu.edu 2016 Deloitte/KU Audit Symposium, May 20 8/16/2016 1

553 views • 17 slides
Audit Committee denvergov.org/Auditor Timothy M. O'Brien, CPA, Auditor 2 Audit Committee

Audit Committee denvergov.org/Auditor Timothy M. O'Brien, CPA, Auditor 2 Audit Committee

1 Audit Committee denvergov.org/Auditor Timothy M. O'Brien, CPA, Auditor 2 Audit Committee Affordable Housing Audit December 2018 Jared Miller, Audit Supervisor Pat Schafer, Audit Supervisor Shaun Wysong, Senior Auditor Chris Wilson,

485 views • 47 slides
MUS Workforce Data Reporting Performance Audit Audit Conducted by the Montana Legislative Audit

MUS Workforce Data Reporting Performance Audit Audit Conducted by the Montana Legislative Audit

MUS Workforce Data Reporting Performance Audit Audit Conducted by the Montana Legislative Audit Division Presented to the Montana Legislature, Legislative Audit Committee on February 2, 2016 Office of the Commissioner of Higher Education

605 views • 25 slides
Dependent Eligibility Audit Dependent Eligibility Audit Purpose: The dependent eligibility audit

Dependent Eligibility Audit Dependent Eligibility Audit Purpose: The dependent eligibility audit

Quick Guide to the Dependent Eligibility Audit Dependent Eligibility Audit Purpose: The dependent eligibility audit will help us comply with regulatory requirements and control costs by confirming that only eligible dependents receive coverage

506 views • 6 slides
TAM Audit for BRC August 2015 TAM Audit 2015 ? Purpose: Close 2014 TAM Audit Inspect

TAM Audit for BRC August 2015 TAM Audit 2015 ? Purpose: Close 2014 TAM Audit Inspect

TAM Audit for BRC August 2015 TAM Audit 2015 ? Purpose: Close 2014 TAM Audit Inspect TAM KPIs Sign-off 2014B Universe Update LSM issues on TAM Panel Improve HH weighting efficiency Preparing TAMS for the future

703 views • 27 slides
Audit in Screening Dr LS Wilkinson What is clinical audit? Clinical audit is a process that has

Audit in Screening Dr LS Wilkinson What is clinical audit? Clinical audit is a process that has

South West London Breast Screening Service London, UK Audit in Screening Dr LS Wilkinson What is clinical audit? Clinical audit is a process that has been defined as &quot;a quality improvement process that seeks to improve patient care and

517 views • 23 slides
Percentage of Residents 100% 80% Initial audit 60% Re- audit 40% 20% 0% MUST on MUST

Percentage of Residents 100% 80% Initial audit 60% Re- audit 40% 20% 0% MUST on MUST

Percentage of Residents 100% 80% Initial audit 60% Re- audit 40% 20% 0% MUST on MUST MUST Care plan Factors Snacks Food admission accuracy monthly reviewed affecting and drinks fortified monthly food Audit Standards

511 views • 3 slides
Framework for Audit Quality Framework for Audit Quality Key Elements that Create an Environment

Framework for Audit Quality Framework for Audit Quality Key Elements that Create an Environment

Framework for Audit Quality Framework for Audit Quality Key Elements that Create an Environment for Audit Quality Jon Grant Page 1 Background to the Audit Quality Project For an external audit to fulfill its objective the users of

297 views • 15 slides
2018 Annual Audit Report to the Commission GCPUD Audit Department 11/13/18 1 Meeting

2018 Annual Audit Report to the Commission GCPUD Audit Department 11/13/18 1 Meeting

2018 Annual Audit Report to the Commission GCPUD Audit Department 11/13/18 1 Meeting Objectives: 1. Principles of Audit Plan Development 2. Status of the 2018 Audit Plan 3. Review 2019 Audit Plan 4. Moving Forward GCPUD Audit Department

807 views • 60 slides
IMPACTFUL COMMUNICATION BETWEEN IA AND THE AUDIT COMMITTEE GOJ AUDIT COMMISSION CONFERENCE

IMPACTFUL COMMUNICATION BETWEEN IA AND THE AUDIT COMMITTEE GOJ AUDIT COMMISSION CONFERENCE

IMPACTFUL COMMUNICATION BETWEEN IA AND THE AUDIT COMMITTEE GOJ AUDIT COMMISSION CONFERENCE Oct-17 OBJECTIVES OF THIS PRESENTATION To clarify governance To discuss setting the right tone at the top. To identify the roles of Audit

641 views • 26 slides
Agenda Internal Controls Audits and Auditors Audit Process Overview How to Prepare

Agenda Internal Controls Audits and Auditors Audit Process Overview How to Prepare

12/11/2017 WA S H I N G T O N S T AT E U N I V E R S I T Y Award Administration ard Administration Part Three: Part Three: Audits and Audits and Audit Issues Audit Issues Presented by: Heather Lopez Chief Audit Executive, Internal Audit

461 views • 25 slides
ROAD SAFETY AUDIT PRACTICE IN MALAYSIA by Ir. RICHARD WONG CHAIRMAN HIGHWAY &amp;

ROAD SAFETY AUDIT PRACTICE IN MALAYSIA by Ir. RICHARD WONG CHAIRMAN HIGHWAY &amp;

ROAD SAFETY AUDIT PRACTICE IN MALAYSIA by Ir. RICHARD WONG CHAIRMAN HIGHWAY &amp; TRANSPORTTION ENGINEERING TECHNICAL DIVISION (HTETD) INSTITUTION OF ENGINEERS, MALAYSIA (IEM) Understanding Road Safety Audit (RSA) 1 RW Consultancy ROAD

671 views • 49 slides
Auditor Presentation of Programmatic Audit Results to the Audit Committee Presented By Bill

Auditor Presentation of Programmatic Audit Results to the Audit Committee Presented By Bill

Auditor Presentation of Programmatic Audit Results to the Audit Committee Presented By Bill Brown, CPA, CFE, MAFF Yoko McCarthy, MBA, CISA, CFE, CGFM April 19, 2018 Agenda Programmatic Audit Overview Three Year Programmatic Audit

223 views • 10 slides
1 L e ve l of Audit Comme nts Sc he dule o f F inding s Ma na g e me nt L e tte r E ffic

1 L e ve l of Audit Comme nts Sc he dule o f F inding s Ma na g e me nt L e tte r E ffic

OHI O AUDI T OR OF ST AT E KEITH FABER Common Audit Comme nts E ffic ie nt E ffe c tive T ra nspa re nt Ag e nda T ype s o f Audit Co mmo n Audit Co mme nts Co mme nts E ffic ie nt

444 views • 6 slides

More recommend