There have been scenarios where there is a need to retrieve the information about the access levels applied on a universe for all usergroups/users and have the results in an excel file. This information can not be retrieved using the query builder and can be easily retrieved if you are using the BusinessObjects Enterprise Platform SDKs. However, the Business Objects SDKs do not give you an API call to have these kind of results exported to an excel file.
Using the features of poi jar files, it is possible to include the code for having the results in excel file.
Below is the code for exporting the access levels of universe for all usergroups in an excel file. The code has been designed to get information for the Effective principals. The version poi jars used for compiling this code is 2.5.1-final-20040804
The part of exporting the results to an excel file doesnot come under the support of BusinessObjects as you would be using third party jars with BusinessObjects jar files to have the results exported to excel.
For other scripts and information on how to run these scripts see here:
|Universe Access Level for all UserGroups|
<%@ page import=”java.util.*,
IInfoStore iStore = (IInfoStore)es.getService(“”, “InfoStore”);
//Code to query for the user to test access rights.
String query = “SELECT SI_ID,SI_NAME FROM ci_systemobjects WHERE SI_kind=’usergroup’ “;