SAP BO Universe and Reports Utilities

All these utilities are available in Forumtopics website and I have just collected some of the major utilities and given reference to the original website and I am not storing any of the utilities in this blog.

Document a universe using Excel and the Designer SDK

This utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the “Document a Universe” button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:
Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions

Also u can customize this excel for your own and get / fetch more information on the universe.

To download “Document a universe”, please click here.

““““““““““““
Business Objects 4.0 BIAR Backup Scripts

This application can be run on any SAP Business Objects 4.0 server to generate a .BIAR file (backup) of the repository. You can then use the UMT, LCM or BIARENGINE.JAR to restore the file.

Please click here to get BIAR backup scripts.

““““““““““““““““““““

BO Reports scheduling instances viewer

This macro generates information about instances finished/running/pending. It accepts a date range. If start date is omitted it shows instances statuses for a given day starting 12 AM until time of run. End date is also option and will default to current date/time.
Rows returned are limited to 64000 rows. But please be careful not to run for a big date range as it may overload your CMS.

BO Report Schedule Instance Viewer – click

“““““““““““““““
XI3.1 – Recurring Instance Detail List – Excel 2007 Macro

This macro to be able to retrieve certain information about recurring instances, specifically event dependency and destination email addresses (if applicable to the schedule). This program is an Excel macro that will extract a list of all recurring instances in the repository and provide some stats about each : Name, update date, create date, parent report folder path, name of event dependency, destination email addresses and output type.

To download “Schedule Recurring Instance Detail List”, please click here.

““““““““““““““““““““““““““““
XI31_Retrieve Report Statistics

This utility would fetch complete information about report and below is the utility process flow detail.

1. Connect to the CMS
2. First Loop – Loop through the three types of reports: Crystal, Webi, Deski
2. Second Loop – Extract the list of reports.
3. Third Loop – Count up the number of instances and calculate the avg run time and sum the size of the instance files in MB.

To download “Retrieve Report Statistics utility”, please click here.

“““““““““““““““““““““`

BOXI Repository Documenter

This spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too – as returned when querying via the query builder.

It should be run under the administrator account for the best results, but also works for delegated administrators/users.

The first tab has a section on the supported types and usage guide. It also mentions some limitations – so PLEASE READ this first.

Changing the reference to that of the version 11.x libraries should enable this to work for XI R2, the ones that need changing are:

Crystal Enterprise Framework Library 12.0
Crystal Enterprise Infostore Library 12.0
Business Objects Designer 12.0 Object Library

If you need to change the Referenced Libraries this can be accomplished by opening the document, select Tools > Macros> Visual Basic and then Tools > References.

This utility should be run on a workstation which has the full BO client installation as it requires access to Designer and also libraries provided by the install.

This utility only works for XI R2 & XI 3.x version.

To download “XIR2/R3 Repository Document utility”, please click here.

““““““““““““““““““““““““““““““““““““

SAP BI Repository Documenter

This utility spreadsheet for SAP BI (BO 4) will retrieve information about the object (Reports, Universes, Connections, Categories, QaaWS and disk usage) in the SAP BI environment.

It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too – as returned when querying via the query builder.

It should be run under the administrator account for the best results, but also works for delegated administrators/users.

The first tab has a section on the supported types and usage guide. It also mentions some limitations – so PLEASE READ this first.
This utility should be run on a workstation which has the full SAP BI client installation as it requires access to the libraries provided by the install.

To download “SAP BI Repository Documenter utility”, please click here.

““““““““““““““““““““““““““““““`
Method of extracting lost / forgotten credentials from Designer.

In a large Business Objects installation, connection credentials can often get lost or forgotten.
Usually, the only way to resolve this is to reset the database password. Unfortunately, this may cause additional problems, particularly if the account is shared by another application or other BO connections.

As a result, there may be a legitimate need to recover lost credentials.
The encryption scheme used by Business Objects XI appears to be secure. Universe Designer, however, as part of the process of displaying the connections dialog box queries the CMS for connection objects and creates a class instance internally to hold all the details should the user wish to view or change them.

It appears from examining the heap of the designer process directly after the connections window is displayed that each connection instance holds an XML fragment containing all the connection properties including the clear text password.

As Designer has helpfully filled its heap with easily identifiable clear text credentials, it is relatively easy to extract these details and populate a spreadsheet with the connection properties.

Limitation: Connection name is not available. If you need this, InfoObjects is probably the best source.

Please click here.

To get more BO downloads please visit to BOB Downloads.

Advertisements

One thought on “SAP BO Universe and Reports Utilities

  1. I was trying to get a macro that will extract all SQLs defined in Row level security. In designer after importing a universe, If you go to tool, manage security then manage access restrictions, You can see all the available restrictions. I was wondering if there is an excel tool that will extract all the security restrictions available in the universe.

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