In the BMM layer, expand the D1 Time logical table.
Use Ctrl+ Click to select the following logical columns:
Per Name Half
Per Name Month
Per Name Qtr
Per Name Week
Per Name Year.
|3 .||Drag the selected logical columns to the Time presentation table in the Presentation layer.
|4 .||Repeat the process and add the following logical columns to the remaining presentation tables:|
Products: Drag Brand, Lob, Prod Dsc, Type from D2 Product.
Customers: Drag Cust Key, Name from D3 Customer.
Base Facts: Drag Revenue, Units from F1 Revenue.
OBIEE 11G Create 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...