Introduction

This document explains points to be taken care by the universe designers while associating list of values for

attributes in the universes. This demonstrates how it impacts the space consumption in the server and how/what

can be done to minimize this impact. This does not, though, explains all the delete rules for old report instances, or

other space cleanup activities etc for a Business Objects installation. This document assumes that the audience is aware of

generating a simple Web intelligence report and familiar with SAP Business Objects universe concept/universe designer.

Context

In a Business Objects universe, all the objects in a class are associated with a list of values, by default. When these objects are

used in the Query filter pane in web intelligence report, it has a list of values associated with it. When we refresh

the list of values for any object it creates a temporary folder in the storage directory of the Business Objects installation

directory. One temporary folder is created for each universe and inside that one List Of Values file is created for every object

(once refreshed for list of values in any report). This keeps on increasing in size as users run the reports over time

and might give space problems in the server. Demonstration explains how to minimize this impact by removing

the association of list of values wherever not required by the end users.

Demonstration

Create a blank report and add one query filter (I have used my practice universe to demonstrate)

Untitled.jpg

Set Prompt with list of values as shown below:

Untitled.jpg

Add Resource Name (we may add any object, this is just to be able to refresh the report) in the result objects

pane.

Click Run Query


Untitled.jpg

. Now go to the Business Objects installation box and navigate to <<Business Objects installation directory>>/Business Objects

12.0/Data/<<ServerName>>_6400/storage/universes

We see one temporary folder and one temporary .UNV file created for one universe which holds the LOVs

temporarily for every instance of all reports running against one universe.

Untitled.jpg

Total Size of the folder is:

Size: 897 KB

Size of disk: 904 KB

Now I added one more object in Query objects say OBS Path and set it to prompt it with list of values. Click “Run

Queries”.

Now total size of the folder is:

Size: 1.04 MB

Size on disk: 1.05 MB

Notice that if refreshing only two fields with list of values in one instance of any report generates 1.05 MB of data,

then it would grow in GBs very quickly if all the users are using their reports on frequent basis.

Remediation

Delete these folders from the server time to time.

Do not associate list of values for all the objects at the universe level where it does not make sense.

By default, list of values are associated to all the objects. So, we should remove association of LOVs for all objects

where this does not make sense for end users.

Follow the given steps to remove association:

1. As in my case, Resource Key contains internal ID of the resource which does not make sense to end user.

2. Go to the respective universe in the universe designer.

3. Right click on the Resource Key object.

4. Object properties.

5. In Properties sub tab, uncheck “Associate a List of Values”


Untitled.jpg

6. Click on Apply and OK.

                               Thank You

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply