1 . | In the Presentation layer, right-click the Sample Sales subject area and select New Presentation Table to open the Presentation Table dialog box. |
---|---|
2 . | On the General tab, enter Customer Regions in the Name field. |
3 . | Click OK to close the Presentation Table
dialog box. Confirm that the Customer Regions presentation table is
added to the Sample Sales subject area in the Presentation layer. |
4 . | In the BMM layer, expand Sample Sales > D3 Customer. |
5 . | Drag the following logical columns from D3 Customer to Customer Regions in the Presentation layer: Address 1 Address 2 Area City Country Name Estab Name Postal Code Region State Province State Province Abbrv Your column names may be slightly different depending on how you renamed them. |
6 . | Reorder the Customer Regions presentation columns in the following order, from top to bottom: Region Area Country Name State Province State Province Abbrv City Postal Code Address 1 Address 2 Estab Name |
7 . | Double-click the Sample Sales subject area in the Presentation layer to open the Subject Area dialog box. |
8 . | Click the Presentation Tables tab. |
9 . | Reorder the presentation tables so that Customer Regions appears after Customers. |
10 . | Click OK to close the Subject Area dialog box. Confirm that the presentation tables appear in the expected order. You now have two presentation tables, Customers and Customer Regions, mapped to the same logical table, D3 Customer. The D3 Customer logical table is mapped to two physical sources: D3 Customer and D4 Address. |
11 . | Save the repository and check global consistency when
prompted. You should receive a message that there are no errors,
warnings, or best practice violations to report. If you do receive any consistency check errors or warnings, fix them before proceeding. |
12 . | Click OK to close the consistency check message. |
13 . | Close the repository. Leave the Administration Tool open. |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Create Presentation Layer Objects
Labels:physical layer
OBIEE 11g
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