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 you can use a universe and native reporting clients to query the metadata of the CMS repository database.
|Sample content version 2||Enhanced universe and more Web Intelligence documents|
(download see Get Started)
|21 Dec, 2016|
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 available since support package BI 4.2 SP4.
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.
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.
- BI 4.2 SP03
- Starting with BI 4.2 SP04, the universe and samples can be found in the samples folder of the installation (..\SAP BusinessObjects Enterprise XI 4.0\Samples\bionbi).
The old sample LCMBIAR files for 4.2 SP03 can be found in the attachments section of KBA:
2399962 - CMS database with new data access driver from BI 4.2 SP03
- Import the universe from the LCMBIAR into your BI 4.2 system using Promotion Management
- Watch the videos to get help in getting started using the universe
Session ID: ANP266
Meet us at Teched to practice / train on this new driver, talk about the universe, create complex reports and share your feedback.
|September, October, November 2016|
|ASUG + BI Conference, New Orleans||PLT6083: BI 4.2: The New BI-on-BI Capabilities in BI 4.2 SP03 Release||October 18, 2016|
|Git Hub repository||We plan to create an open source project on the SAP Git Hub platform to collaborate on Universes and Web Intelligence documents||open|
A special thanks goes to the top contributors leading the development of the sample content (universe, Web Intelligence documents and videos):