1. |
In the Presentation layer, expand the Products presentation table. |
---|---|
2. |
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
Product"."Lob". |
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 , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Rename Presentation Columns
Subscribe to:
Post Comments (Atom)
Popular Posts
-
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...
-
https://forums.oracle.com/forums/search.jspa?forumID=378&threadID=&q=%22timestampadd%22+&objID=f378&dateRange=all&userI...
-
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 create time series calculation measures using Oracle BI time series functions. Time series functions include AGO, T...
-
In OBIEE, the dashboard prompts are aligned to the left by default. One of the OBIEE developers I am working with asked me to fin...
-
I was requested the other day for a custom job within OBIEE. The request was for an extra “Go” button which would be placed on to...
-
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 presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
-
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? ...
No comments:
Post a Comment