One of the mostly requested feature by BI platform administrators is an integrated and easy to use Reporting & Analysis solution for the CMS database. As of now this is provided by the BI platform through the Query Builder, an HTML application to query the metadata (see BusinessObjects Query builder - Basics).

With the new CMS data access driver introduced in SAP BI 4.2 SP3 (see SAP BI 4.2 SP3: What’s New In Semantic Layer) you can use a universe and native reporting clients to query the metadata of the CMS repository database.

While the driver is installed with the product, a universe and sample Web Intelligence documents will be available for download on this site. This will allow us to provide release independent updates for the first version of the universe and samples. Its integration as samples in the installation is planned for a future support package.

Introduction

Most of the data access drivers are using SQL and database middleware to run queries against a data source. However, for the CMS database direct access using SQL drivers is not possible, metadata queries are managed by the Central Management Server (CMS). The CMS controls the database connection and can execute queries using its own query language.

Fundamentals

To use the BI Repository Analysis solution, you should at least have a basic understanding of the CMS system database, how to query InfoObjects metadata, its properties and relationships.

• How to browse CMS repository
• BusinessObjects Query builder - Basics

Requirements

• BI 4.2 Support Package 3

Get started

1. Download the content (universe, Web Intelligence samples and videos)
2. Import the universe from the LCMBIAR into your BI 4.2 system using Promotion Management
3. Watch the videos to get help in getting started using the universe

Planned Activities

Top Contributors

A special thanks goes to the top contributors leading the development of the sample content (universe, Web Intelligence documents and videos):
Former Member

@Sylvain RIBOUD