In the Presentation layer, expand the Products presentation table.
Double-click the Lob presentation column to
open the Presentation Column dialog box. On the General tab notice that
"Use Logical Column Name" is selected. When you drag a logical column
to a presentation table, the resulting presentation column inherits the
logical column name by default. In this example the Lob presentation
column inherits the name of the logical column "Sample Sales"."D2
|3 .||Deselect Use Logical Column Name. The Name field is now editable.
|4 .||Enter Line of Business in the Name field.
|5 .||Click OK to close the Presentation Column
dialog box. Notice that the presentation column name is now changed to
Line of Business in the Presentation layer.
|6 .||In the BMM layer, expand D2 Product. Notice that the Lob
logical column name is not changed. The point here is you can change
object names in the Presentation layer without impacting object names in
the BMM or Physical layers.
|7 .||In the BMM layer, rename the Prod Dsc logical column to Product. Notice that the name change is inherited by the corresponding presentation column.
|8 .||Make the following name changes to logical objects in the
BMM layer so that the names of the corresponding presentation columns
are also changed:
For the D3 Customer logical table:
Change Cust Key to Customer Number.
Change Name to Customer Name.
|9 .||Confirm that the corresponding presentation column names are changed. |
OBIEE 11G Rename Presentation Columns
Labels:physical layer OBIEE 11g
A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
How to get a difference between two dates (in terms ) of days,weeks,months what every it may be The below formula gives you no.of days b...
TABLE SALESPEOPLE SNUM SNAME CITY COMM 1001 Pe...
You create a Narrative view to provide information such as context, explanatory text, or extended descriptions along with column v...
A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically...
In this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a...
A dashboard prompt is a special filter that filters analyses embedded in a dashboard. There are two various prompts and this topic dis...
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? ...
You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing...
In this set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, whic...