SAP BI Platform Support Tool

If you are a SAP BO administrator or a consultant, you will find the following SAP tool very helpful.

SAP BI Platform Tool is designed for supporting BI Platform administration. It simplifies the process of reporting on the landscape configuration, performing root cause analysis tasks, and delivering performance optimization and go-live services.

This tool is free of charge and is maintained by SAP.

You can find more details and download the tool from the tool’s page on SAP Community Wiki

Unx Universe Documentation

You can quickly create PDF documentation of a Unx universe from IDT (Information Design Tool). But PDF is not good if you need to analyze universe in some way. For this purpose, it is better to have Unx metadata in Excel spreadsheet. You can use Biclever Unx Documenter (UnxDoc) to extract Unx information to Excel spreadsheet. In this post we will describe both ways of documenting Unx universe.

Creating PDF documentation from IDT

You can create separate PDFs for business layer, data foundation, and connection.

Open IDT and login.

Retrieve Unx universe to IDT.

Right click on the item you want to document (for instance, business layer), and select Save as.

Creating PDF documentation of UNX in IDT

After this, you will be able to select the destination and metadata elements to be exported:

Selection of elements for PDF documentation of UNX in IDT

The documentation looks good and ready for printing. If you need to create some documentation of your universes quickly, this is the easiest way.

PDF documentation of UNX created in IDT

However if you need to use the documentation for any practical purpose, you will need a more structured format.

Creating XLSX documentation using Biclever Unx Documenter

Download Biclever Unx Documenter from Software > Unx Documenter. Unpack it to a preferred folder. Check if you have Semantic Layer SDK enabled.

Start the tool using unxdoc.bat and log in.

Select a universe

Click Process and then Export result. Select destination XLSX file.

The universe metadata will be exported to Excel spreadsheet. Now you can easily filter, search and analyze the information in Excel.

BI-on-BI in BO 4.2 SP3

In BO 4.2 SP3, you are finally able to run queries against CMS database without 3rd party tools! SAP has introduced a new CMS data access driver. So it is now possible to use a universe and standard BO tools to query the metadata of the CMS repository database.

Download “The LCMBIAR contains the connection to CMS database “SAP BI platform CMS system database” and a sample universe universe “SAP BI platform CMS system database”.

Now you can easily get a list of all your Web Intelligence documents:

Or you can find dependency between universe and Webi document: