Upgrade Old nested folders using the Convert Presentation Folders Utility in OBIEE 11.1.1.7.0 RPD

Starting in Release 11.1.1.6.2, you can designate child presentation tables using the Child Presentation Tables tab in the Presentation Table dialog to give the appearance of nested folders in Answers and BI Composer. However, in previous releases, repository developers could achieve one level of nesting in Answers by adding a hyphen at the beginning of a presentation table name, or by adding an arrow (->) at the beginning of a presentation table description.

For e.g.: In previous versions, if you wanted to move the “more Time Objects” to the table/folder, then we will place the ‘->’ in description as shown below.

If you used these methods to achieve nesting, it is recommended that you run the Convert Presentation Folders utility to convert your metadata to the new structure.

Note:

Achieving nesting by adding hyphens at the beginning of presentation table names or adding arrows at the beginning of presentation table descriptions is deprecated for this release and will be removed in a future release.

To use the Convert Presentation Folders utility:

1. Open your repository in the Administration Tool in offline mode.

Note: Do not run the Convert Presentation Folders utility in online mode.

2. Select Tools, and then select Utilities.
3. Select Convert Presentation Folders and click Execute.

The hyphens and arrows disappear from presentation table names and descriptions, and the affected tables are listed as child tables for the appropriate parent object.

Once you converted, the above example will be converted to the new definition as follows:

There are no limits on nested folders depth. For more information on nested folders, visit https://shivabizint.wordpress.com/2012/06/01/sub-folders-nesting-folders-in-obiee-11g-answers/

Thanks,
Shiva

 

The primary differences between the OBIEE 10g and 11g security models

What are the primary differences between the OBIEE 10g and 11g security models and what happens during upgrade?

 

Thanks,
Shiva

 

OBIEE 11.1.1.6.2 Client Tools

Recently Oracle has released a patch for OBIEE 11.1.1.6.0 to upgrade to 11.1.1.6.2 with the major bug fixes. But once we upgrade the RPD version raises to 11.1.1.6.2 and then we cannot open this new version RPD from available OBI Client (11.1.1.5.0/11.1.1.6.0) Admin tool.

So we need to download another patch set for Admin tool (in fact, it is a full client tool for 11.1.1.6.2)

Download patch 13794002 from oracle support.

This patch contains a zip file called p13794002_111160_Generic.zip. Unzip this into a directory.

e.g.: obiee11162patches

Then navigate to /obiee111162patches/13794002/files/clients/biserver

Here you can see two client tool installers for 32-bit and 64-bit Operating systems. Install them based on your system configurations.

biee_client_install.exe (for 32 bit Operating Systems)

biee_client_install_x64.exe (for 32 bit Operating Systems

A sample screens of 11.1.1.6.2 clients tools

Thanks,

Shiva