BI on BI – Metadata Browsing – BOBJ 4.2 SP3

BI on BI – Metadata Browsing – BOBJ 4.2 SP3

BI on BI – metadata repository reporting

 

It is always a good practice and needy thing for IT managers to know what is happening with in their BI environment. Use cases to browse metadata of BI tool are quite many including report inventory, user analysis, Schedules and the metadata combined with Audit records this is make the house cleaning activities simple.

 

The CMS database, which holds the BOBJ metadata, has always been locked (encrypted to be precise) to query. Hence connecting via standard SQL tool was nit possible. We need to develop an SDK solution , in order to accomplish the same. The in-built admin tool has capability to query the CMS, but that is more HTML bases form kind of reporting.

 

With the new 4.2 SP3 , SAP released inbuilt CMS driver, which can be used for creating universes and can be consumes in bobj suite of reporting tools.

 

1

 

After successful installation of 4.2 SP3 client tools, you can find CMS database driver under SAP drivers.

2

 

Using the session token will use the current CMS session and credentials used for IDT login.

3

4

Creating the data foundation and unx is regular standard process.

5

6

 

Once the universe is published, you can use the native BOBJ reporting tools and consume the universe.

Below is the sample user – folder mapping report

7

Sample report – unx mapping

8

Here are the detailed documents on query Builder basics and CMS database tables

 

http://scn.sap.com/docs/DOC-42952

 

References: http://scn.sap.com/docs/DOC-74580

 

Karthik Addula – Tek analytics

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s