RSS

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

24 Apr

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.

Convert to Nested folders

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.

  1. Select Tools, and then select Utilities.
  2. 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:

Convert to Nested folders2

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

 
6 Comments

Posted by on April 24, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic

 

Tags: , , , , , , , , , , , ,

6 responses to “Upgrade Old nested folders using the Convert Presentation Folders Utility in OBIEE 11.1.1.7.0 RPD

  1. Raghu Kanaparthi

    April 24, 2013 at 2:20 pm

    Thanks Siva. Its a good piece of info.

     
  2. Jack

    March 26, 2015 at 2:35 pm

    I agree that the folders will be upgraded however, the dashboard prompts that utilize the prior method of nesting tables do not maintain the lineage and must be replaced with the new non-hyphenated table name.field or the field formula needs to have the hyphen removed on the dashboard prompt. Is there something I am missing?

     

Leave a comment