Changing the name of a Subject Area in OBIEE 10g (in preparation for upgrade to 11g)

This article shares a few steps for renaming a “Subject Area” in OBIEE 10g.  OBIEE 10g allowed leading spaces in Subject Area names. You may have done this to alter the sort order of your Subject Areas without using leading numbers. This would result in only a Warning message when you checked the repository’s consistency.  However, leading spaces in Subject Area names is not allowed in OBIEE 11g, and will result in an Error.

So, if you are upgrading to OBIEE 11g then you will need to change the Subject Area name(s) to remove leading spaces or you may need to change Subject Area name(s) for other reasons.

Here are a few steps to consider but I recommend that you perform these steps for one subject area first, confirm all is well, then repeat steps for all subject areas.

  1. Stop the Presentation Server.
  2. In the Oracle BI Administration Tool, manually rename the Subject Area(s) in the Presentation Layer (and remove the leading spaces if that was the reason for the rename).
  3. Log into Catalog Manager in online mode, and navigate to Tools –> XML Search and Replace
  4. Carefully set the text you would like to replace with the new text – but make sure the text string is unique enough so that you do not inadvertently changed text that you don’t want to change.  Repeat for each name change that is required.
  5. You may need to manually open your prompts in Answers to change the Subject Area names in the custom SQLs used to generate defaults and drop down lists.
  6. Restart the Presentation Server and test your changes.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: