Kapil Malik (Business Objects Developer – B.Sc, B.Tech)

Solution :

Goto Excel options > Advanced tab > General Section:
Make sure “Ignore other applications that use DDE” is unchecked .

Are you getting “Outlook experienced a serious problem with the Business objects live office xi 3.1 add-in.” after installing business objects live office 12.0 ?

To resolve this issue :

1. Navigate to C:\Program Files>Business Enterprise 12.0\Live Office 12.0
2. Click on “enable_addin.exe”
3. Un Check Enable BusinessObjects Live Office XI 3.1 for MicroSoft Office Outlook
4. Press OK.

Here is the link to BOXI 3.1 UserList & Group Extraction tool which was origionally posted on BOBJ Webstie by Julian Brass. I have updated the code to get it working in 3.1.

BOXI_UserListV3 3.1 Version

Thanks.

Click on selection for ‘Left Panel’ at the top under “View” in infoview.

To resolve “CORBA Initialization failed”. (WIS 10901) error in WebI Rich Client 3.1 you will need to restart server intelligence agent .

This Issue is resolved in BO XI R2 SP4 and SP5

1. Only the universe designer needs to know how to write SQL and understand the structure of the target database.

2. The interface allows you to create a universe in an easy-to-use graphical environment.

3. Data is secure. Users can see only the data exposed by the universe. Users only read data, not edit it.

4. The results are reliable and the universe is relatively easy to maintain.

5. Users can use a simple interface to create reports.

6. All users work with consistent business terminology.

7. Users can analyze data locally.

1. Gives Access just to the data the users need for reporting and analysis.

2. Is easy to maintain.

3. Is easy to use. For Example, it does not contain too many objects and Classes and Sub-Classes.

4. Generates efficient SQL.

5. Contains no more than 500 objects and the .unv file is no bigger than 1mb in size.

1. Create a Web Intelligence report with [Date object], other objects, measures#etc
2. After the report is generated define a variable #13-Months-Back# using #RelativeDate()# to approximately minus the current date with 13 months as following
3. 13-Months-Back=RelativeDate([Date Object];-395) .
4. Now insert a new column in the report and place #Thirteen_Months_Back# variable object.
5. Use #13-Months-Back# variable in the graph,#etc

1. In the universe Designer, on the ‘Tools’ menu, click Hierarchies.
2. Choose the desired class from ‘Default Hierarchies’ panel. Add it to the ‘Custom Hierarchies’ area.
3. Click OK.
4. Click Save > Export.

In Web Intelligence document :

1. Add the dimension that is at the top of the hierarchy to the report.
2. Click Drill under the ‘Edit Report’ tab.
3. Save the Web Intelligence document.

Currently in XI R2 there is no option of using templates in Web intelligence.

Following workaround can be utilized for report templates.

1. Create a web intelligence report with the required format that points to a universe(dummy universe) to use it as a template.
2. While creating a new web intelligence report, use the above report and (Select query->Properties tab->Universe) re-point the report to the required universe.

1. The usage of IE is about 30MB when log in infoview.
2. After edit webi report many times, the usage of IE go up to 200MB. The memory usage is up to the time that you do edit action.
3. The memory can not be released after stop editing webi report and log out of infoview.
4. If user continually open and close Java Panel IE will hang.

It was caused by the poorly Memory Collection mechanism of WebI Java Panel. JVM also impact WebI Memory Collection.
Resolution

1. Upgrade BOE to SP5. SP5 has improve WebI Memory collection.

2. Add “-Xincgc” to Java RunTime Paramenter. It is a very important setting for this issue. It means “enable incremental garbage collection”.

Here is how to add this parameter in Java Console.

–Java 1.4 or 1.5:

Go to “Controle Panel”

Open “Java Plug-in”, then go to “Advanced” tag

put “-Xincgc” into “Java RunTime Paramenter”

–Java 1.6

Go to “Controle Panel”

Open “Java”, then click “Java” tag on the pop window

Click “View” button in “Java Applet RunTime Setting” section

put “-Xincgc” into “Java RunTime Paramenter”

Note: Must apply both above two steps to get better performance.

1. Use Draft mode instead of view/page mode.
2. Press Control+F > Type Text and search

1. Create a Crosstab using Dimension and Measure.

2. Add a break on Dimension by clicking on the cell -> Insert -> Break

3. The crosstab will be broken down by that dimension

4. Click on measure in the body of the crosstab and click the SUM # icon

BusinessObjects Products guides

BusinessObjects Enterprise Administrator’s Guide

BusinessObjects Enterprise™ XI. Getting Started Guide

BusinessObjects Enterprise.

InfoView Guide

Here is the site if you are looking fora Service Packs or Hot Fix for Business Objects.
SAP Software Download

A BusinessObjects Universe provides an easy-to-use interface for non-technical BusinessObjects Web Intelligence users to run queries against a database to create reports and perform data analysis.

Accessing a Universe is available through the Query Panel in Crystal Reports to build queries. You can then filter the data that the Query Panel in Crystal Reports returns.

However, there are things you need to know when using Universes as a data source in Crystal Reports. This document describes the limitations and issues you may run into. New features and improvements introduced in Crystal Reports 2008 are also listed.

Click here for more details

Follow these steps to have only PDF option enabled and export to excel disabled on Web Intelligence XI R2 SP4.

Login to CMC with the administrator account->folders->Particular folder->Rights->Particular group or user->Web intelligence document->Deny the right “Export the report’s data” and grant only the right “Export the Reports Data(PDF)”.

Login to infoview with the particular user ->Open the reports in the particular folder -> now we have only the option save the report in PDF format.