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