Work Smarter: 42 Reports
that Boost Productivity for
SAP BusinessObjects Administrators
In Douglas Adams’ The Hitchhiker’s Guide to the Galaxy, it takes a supercomputer known as Deep Thought 7.5 million years to calculate that “the answer to the ultimate question of life, the universe and everything is 42.” Whether Adams chose the number 42 arbitrarily or because it has real significance is a topic for debate. Author Peter Gill ascribed meaning to the number by revealing real-life occurrences of it throughout history in his book 42: Douglas Adams’ Amazingly Accurate Answer to Life, the Universe and Everything. But he missed one: There are forty-two 360Suite reports that are crucial for monitoring various aspects of SAP BusinessObjects.
This ebook contains a comprehensive list of 360Suite reports that boost productivity. It is directed at business intelligence (BI) administrators — the people within an organization who are responsible for installing, maintaining, and administering BI reporting tools. Reports about reporting tools — BI on BI — are important because they provide insight into the efficiency and effectiveness of a sizeable enterprise software investment and answer key questions, such as:
- Is SAP BusinessObjects properly sized to serve user requirements?
- Are users taking full advantage of SAP BusinessObjects?
- Are SAP BusinessObjects reports useful and accurate?
- Are scheduled SAP BusinessObjects reports delivered on time?
- Are SAP BusinessObjects reports in compliance with regulatory requirements?
- Is SAP BusinessObjects secure?
- Do the number of SAP BusinessObjects licenses correlate with actual requirements?
360Suite is a collection of SAP-certified software solutions, developed by GB and Smith, that enhance the value of SAP BusinessObjects. 360Suite reports empower BI administrators to work smarter, not harder, to solve problems and plan for the future. The term “report” is used loosely in this ebook to refer to prebuilt reports, custom reports, monitoring dashboards, watcher results, and Excel downloads.
Platform Usage, Audit & User Adoption Reports
BI administrators must monitor SAP BusinessObjects environments in order to understand how and by whom the platforms are used. Platform usage, audit, and user adoption reports make this possible.
This report provides information about the platform, including the user count by login and access status, document count and size by type, and instance count and size by type. It provides an easy way for BI administrators to view numerous system metrics in a single report.
CMS Through Time
This report provides information about platform changes over time, including the user count by login and access status, instance count and size by type, and document count and size. It helps BI administrators understand the evolution of the SAP BusinessObjects environment and estimate future sizing requirements.
Concurrent User Sessions
This report provides historical information about how many users connected to SAP BusinessObjects at the same time. It helps BI administrators identify session peaks in order to size the server, determine the ideal number and distribution of licenses by type (e.g., NUL, concurrent, mixed), audit license utilization, and estimate future requirements.
This report identifies SAP BusinessObjects user groups that contain no users. It helps BI administrators clean up the platform and maintain security by identifying potential loopholes (e.g., the possibility that users could be added inadvertently to empty groups and thereby obtain access rights to which they are not entitled).
Users by Last Login Date
This report lists all users, ordered by last login date. It allows BI administrators to determine which SAP BusinessObjects users are active, dormant, and inactive (“never connected”) so users can be purged, as needed.
This report provides information about Universe usage. It allows BI administrators to determine which SAP BusinessObjects Universes are used frequently, infrequently, and not at all (“no action”) so unused Universes can be archived or deleted.
Unused Universe Objects
This report lists objects by Universe and provides information about object usage in WebI and Deski documents. It helps BI administrators determine which Universes contain large numbers of unused objects and how frequently Universe objects are used so they can understand adoption rates and clean up and optimize Universes.
This report provides information about monthly changes to the number of documents/instances and actions on documents/instances over time. It helps BI administrators verify that the resources expended to create new content represents a worthwhile investment in useful documents
Failed Login Attempts
This report details failed login attempts by identifying users and providing connection information (date, event message, and IP address). It helps BI administrators identify failed connections so they can investigate the causes (e.g., insufficient number of sessions, attempt to gain unauthorized access to SAP BusinessObjects or a particular document).
This report provides information about all existing connections (Universe and BW), including connection name, network layer, database type, data source, and connection database user. It enables BI administrators to audit database connections in order to perform impact analysis and monitor changes to database versions, drivers, and credentials.
BI administrators are responsible for maintaining the security of data and objects, including managing user access to SAP BusinessObjects folders and content (e.g., Webi, Universes, connections) and monitoring changes over time. Security reports make this possible.
Object Security Matrix
This report provides information about user access to selected objects (e.g., folders, Universes, connections). It helps BI administrators monitor and manage security, including explicit and inherited rights, at the user and/or group level and recertify accounts.
Note: Highlighted cells indicate explicit access rights; all other access rights are inherited.
Compare Object Security
This report provides information about changes to objects security by comparing snapshots of the same or different CMSs at the same or different times and highlighting discrepancies. It helps BI administrators monitor, audit, and manage object security.
This report lists Universe overloads (i.e., Universe-level security restrictions) by name, principal, “where table,” and “where clause.” It helps BI administrators monitor and manage overloads to ensure that users can’t consume data to which they aren’t entitled.
This report provides information about users/groups and documents that have a Document Fine Right Value of “granted” (G) for a selected granular right (e.g., “view objects”). It helps BI administrators manage user-centric and object-level security by identifying all documents that specific users/groups can act on in a particular way and all users/groups that can act on specific documents in a particular way.
Note: Report was filtered to show documents with “view objects” granted.
User Actions List
This report provides information about actions on documents, including user, date, and action type (open, create, save, refresh, no action, etc.). It helps BI administrators identify who acted (or didn’t act) on particular documents.
This report provides information about third-party authentication (e.g., Windows AD, LDAP, SAP), including alias type and login. It helps BI administrators distinguish between native and third-party users and groups, identify users with more than one alias, and locate synchronization issues between third parties and SAP BusinessObjects.
BI administrators must ensure that SAP BusinessObjects platforms support compliance with external (e.g., regulatory) and internal requirements. One way to do this is by tagging sensitive data and running reports to monitor its location and use. Compliance reports make this possible.
Document Usage with Filters
This report, filtered for sensitive data, provides information about the location and use (or non-use) of documents containing data that has been flagged as sensitive. It helps BI administrators monitor sensitive data.
This report, filtered for sensitive data, highlights and identifies Universes containing objects that have been flagged as sensitive in reports (e.g., WebI, Deski, Crystal). It helps BI administrators monitor sensitive data.
Track Unpurged Documents
This report, filtered for sensitive data, provides information about unpurged documents, including document path, name, and type; status (empty or non-empty); and the number of rows. It helps BI administrators identify documents that should be purged in order to eliminate the risk of exposing sensitive data.
User Actions List
This report, filtered for sensitive data, lists user actions on documents containing sensitive data, including the user, action time, and action type. It helps BI administrators manage security.
Note: Report was filtered to show documents flagged as #SENSITIVEDATA.
License Management Reports
BI administrators must ensure compliance with the terms of existing license agreements, analyze license utilization, and estimate future requirements. License management Reports make this possible. It is important to understand the pitfalls to avoid and the best practices to achieve license compliance.
This report provides a general overview of SAP BusinessObjects license utilization, including the number of users who have never connected to SAP BusinessObjects and the number of connected users who have not connected in the past six months. It helps BI administrators evaluate if there’s a license adoption issue to resolve and/or if licenses can be recycled to maximize BI investments.
License Compliance User List
This report facilitates license reviews and compliance by providing a global overview of SAP BusinessObjects license consumption. It helps BI administrators identify users who continue to be associated with licenses even after they have been disabled. It also helps BI administrators determine the number of licenses that are in use and available by type (e.g. Named: Purchased=20; In Use=19; Available=1).
User Actions List
This report identifies SAP BusinessObjects users who have acted on documents. It helps BI administrators determine the ideal license type for different users (e.g., NUL for users who create/modify documents and CSBL for users who only view reports).
Application-centric License Analysis
This report provides detailed information about deployed SAP BusinessObjects licenses from an application-centric perspective. It helps BI administrators determine how many licenses of each type are available for each application. By comparing this information to the SAP BusinessObjects contract, BI administrators can identify compliance problems and take corrective action.
User-centric License Analysis
This report provides detailed information about deployed SAP BusinessObjects licenses from a user-centric perspective. It helps BI administrators determine which users can access what applications with what license type.
Connections Per Group
This report provides information about the number of SAP BusinessObjects connections by group/department/business unit. It helps BI administrators determine what groups are most and least active in order to anticipate requests for additional licenses and address user adoption problems.
BI administrators must monitor system availability to satisfy service-level agreements (SLA), identify and resolve problems before they impact server performance and stability, and fine-tune the SAP BusinessObjects environment. Availability reports make this possible.
This report provides information about SAP BusinessObjects servers, including name, disk space, CPU count and name, memory, operating system, and version. It helps BI administrators understand the configuration of the SAP BusinessObjects environment in order to determine if it’s sized correctly and installed in a way that is fit for purpose.
This report provides information about the configuration of all services running on SAP BusinessObjects servers, including property names and values. It helps BI administrators understand how the deployment is set up so they can determine if the configuration is fit for purpose. It also helps BI administrators with sizing, performance monitoring, and fine-tuning of SAP BusinessObjects.
SAP BusinessObjects Services
This report provides information about the state of monitored services by assigning the following values:
0 = NOT RUNNING
1 = RUNNING
It helps BI administrators determine if there are problems with monitored services that require action.
This report provides information about the distribution of activity across multiple servers. In the case of clusters (multiple servers connected together), it helps BI administrators monitor nodes, identify when action is required to ensure the equal distribution of activity (+/- 10%), and maintain platform health.
Connection to Auditing Database
This report provides information about the communication between SAP BusinessObjects and the auditing database by assigning the following values:
0 = NO CONNECTION
1 = CONNECTION
It helps BI administrators ensure that SAP BusinessObjects is communicating with the auditing database, which is critical for monitoring and recording user interactions with the system. When the report indicates no connection between SAP BusinessObjects and the auditing database, BI administrators can troubleshoot and resolve the problem.
This report provides information about the runtime of WebI reports, whether scheduled, on-demand, ad hoc, or saved. It helps BI administrators identify long-running WebI reports so they can take action before the reports impact server performance. Long-running WebI reports are usually caused by design flaws (e.g., failure to limit queryable data), so this report is particularly useful to organizations that offer self-service reporting. BI administrators can even set up watchers and receive alerts whenever WebI sessions run for longer than a threshold value.
Unbound Documents & Universes
The report lists all unbound documents and Universes — those with weak or broken links (aka orphan) — and includes document name, path, CUID, and type. It helps BI administrators identify weak/broken links so the links can be repaired.
This report lists all objects backed up by 360Plus, including the path, name, CUID, and backup date. It assures BI administrators that the backup system is functional and points them to the folders in which the backups are stored.
Scheduling & Publication Reports
An essential feature of SAP BusinessObjects is the ability to distribute content to users and external destinations. BI administrators are responsible for monitoring scheduled jobs and taking action when failures occur. Scheduling and publication reports make this possible.
Historical Scheduling Analysis
This report contains information about recurring scheduled jobs, including folder name; document name; instance name and type; schedule status, begin date, destination, and duration; and error message. It provides BI administrators with a big picture of scheduled jobs and documents distributed outside the BI platform, and identifies failed jobs for troubleshooting purposes.
Live Scheduling Analysis
This report provides information about the number of concurrent scheduled jobs over a period of time and the maximum (peak) number of concurrent scheduled jobs since the Adaptive Job Server was last started. It helps BI administrators determine if a busy server is the reason for performance problems so they can reschedule jobs for greater equilibrium, if necessary.
BI administrators must ensure the quality and accuracy of SAP BusinessObjects documents. Quality reports make this possible.
360Suite regression testing generates reports that identify differences in data, images, structure, style, and execution times between two instances of the same SAP BusinessObjects document over time and across environments and versions. By locating regressions, regression testing points BI administrators in the right direction so they can identify root causes, analyze impact, and resolve issues.
Versioning and Lifecycle Management
This report shines a light on the report lifecycle and provides a record of events, including date, type, actor, and description. It helps BI administrators monitor report development, whether in-house or offshore, and ensure quality.
Track Duplicated Reports
This report identifies duplicate WebI and Deski reports (i.e., reports that have been copied with few or no modifications), and includes information such as document path, name, and type. It enables BI administrators to clean up environments by deleting or migrating duplicate reports.
Impact analysis reports identify documents that contain specific Universe objects, SQL expressions, or variables. They help BI administrators understand the impact of altering Universe objects and database objects.
Summary with Bad Documents
This report identifies documents with excessive dependencies. (By default, “excessive” is defined as more than 20 reports, 15 data providers, and/or 50,000 fetched rows, but filters are adjustable.) It helps BI administrators find and fix poor-performing reports, which is especially important in self-service environments because report creators may not be aware of best practices and mistakes to avoid.
The Suite Spot
360Suite reports may not be “the answer to the ultimate question of life, the universe, and everything,” but they enhance the productivity of BI administrators who interact with SAP BusinessObjects. By exposing BI on BI, these 42 different 360Suite reports offer critical insight and empower BI administrators to work smarter, not harder, to maximize the potential of a valuable business intelligence asset. They provide a roadmap to the sweet spot — the optimal balance of SAP BusinessObjects costs and benefits.