Search
  • Linda Stewart

Renaming Presentation Tables in OBIEE 12c

Today I was working in an Oracle Business Intelligence Enterprise Edition (OBIEE) 12c RPD (Version 12.2.1.2, the on-premise Oracle BI solution) and I dragged my table from the logical level to the presentation level.  I wanted to rename the table, but the name in the property sheet was locked.


The solution is to set a property in the “Tools > Option > General” tab.

Let’s walk through the solution:


My logical table object is: “Fact_PC_Reconciliation_Extension” and I want the presentation table object name to be: “Fact – PC Reconciliation Report.”


If I go to the presentation layer and right-click my table, I then can select “Properties” from the menu:


The property sheet has the “Name” value greyed out and it cannot be edited:


To fix this, click “Tools > Options” and then in the “General” tab, check “Edit presentation names” and click “OK:”


Reopen the menu for the table by right clicking on “Presentation Table name”:


Notice that we now have two new menu options: “Rename Wizard” and “Rename.”  Open “Properties:”

The value for “Name” is now unlocked and we can rename the “Presentation Table.”


After renaming:


I hope this blog might save some others some time when working in the RPD.

#OBIEE #oracle #OracleBusinessIntelligence #OracleBusinessIntelligenceEnterpriseEditionOBIEE12c

Computer%20with%20Graph_edited.jpg

BLOGS

© 2006 - 2020 by Performance Architects

  • Facebook
  • Twitter
  • LinkedIn
  • YouTube