UTILITIES


Today, we are going to discuss something about the “Utilities” feature in Admin tool. This Utility feature is very helpful  in the development, maintenance and administration of repository.
Accessing Wizards and Utilities
Start > Programs > Oracle BI > Administration
In Administration tool, go to  tool > Utilities
Utilities 1Click on Utilities , Now the next screen will look like this
utilities
Step by step will discuss all…
1) Replace Column or Table in Logical Table Source
Select Replace column or table in logical table source and click ” Execute”
utilities 1-1
With the help of this wizard we can replace single column or entire table. We can see that from the screen shot.
2) Oracle BI Event Tables
Oracle BI Event tables Utility allows us to Identify a table as an Oracle BI Event Polling table. An Event pulling table is a way to notify the Oracle BI Server  that one or more physical tables have been updated.
To mark the table object as an Event Polling Table
1 Click on the Tools > Utilities menu item.
2 Select the option Oracle BI Event Tables from the list of options.
3 Click Execute.
4 Select the table to register as an Event Table and click the >> button.
5 Specify the polling frequency in minutes, and click OK.
The default value is 60 minutes.
BI Event table
3) Externalize Strings
We will discuss this later…
4) Rename Wizard
Rename Wizard allows us to rename BMM Layer and Presentation layer table and columns. I t provides a convenient way to transform physical names to User -Friendly names.
Rename
Here you can select  Layer and add the tables or columns which you want to rename.
5) Update Physical Layer Wizard
This wizard allows you to update database objects in the Physical layer of a repository based on their
current definitions in the back-end database.
update phy layer
6) Repository Documentation
To run the Repository Documentation utility
1 From the Tools menu, choose Utilities.
2 In the Utilities dialog box, select Repository Documentation, and then click Execute.
3 In the Save As dialog box, choose the directory where you want to save the file.
4 Type a name for the file.
5 Choose a type of file and an Encoding value and click Save.
7) Remove Unused Physical Objects
Large repositories use more memory on the server and are harder to maintain. Additionally,
development activities take longer on a large repository. This utility allows you to remove objects
that you no longer need in your repository. You can remove databases, initialization blocks, physical
catalogs, and variables.
To remove unused physical objects
1 From the Tools menu, choose Utilities > Remove Unused Physical Objects, and then click Execute.
2 In the Remove Unused Physical Objects dialog box, from the Type drop-down list, select the type
of object.
3 In the list of objects, verify that only the objects that you want to remove are checked.
Below the list of objects, the number of checked and the total number of objects appears.
4 To remove the checked objects, click Yes.
5 To cancel, click No.