With the CMS Data Access Driver, you can use a universe and native reporting clients to query the metadata of the CMS repository database (Unlock the CMS database with new data access driver for BI 4.2). Additional Plugins can be developed (Get more insights with BI CMS Data Access Driver – add Objects or Virtual Tables)
Metadata from Web Intelligence Documents
With the new Sample Plugin and Content. you can even query the metadata of Web Intelligence documents. Get this Plugin from the SAP Samples GitHub – https://github.com/SAP-samples/boe-custom-cms-data-access-driver and try it on your BI platform.
All the details can be found in the sample project, but in short: just copy the Data Access Driver to your server and deploy the content using the Promotion Management.
Query the Metadata
The reporting and analysis can be done in Web Intelligence, here some screenshots for the metadata results.
How does it work
When you refresh the document, you can enter
- the document name and
- the request which returns the metadata (some more details below)
In the List of Values, you can see some example requests. Each GET request that starts with /documents/<documentID>/… can be used.
More details about the requests can be found in the Help portal BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer here the link of Getting the Variables of a Document.
How would it look like in a REST client
In a REST client, e.g. Postman, you would have to execute
- the logon request, to get a session token
- the Get Document Dataproviders request, using the session token
(or any other request)
The results will be returned as XML or JSON:
With this Plugin you can use the RESTful API without any coding as dataprovider and the results can be displayed and analysed in Web Intelligence.
The sample is designed to work with the RESTFul SDK for Web Intelligence. Semantic Layer and BI Platform requests cannot be used in the current version.