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...
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...
TABLE SALESPEOPLE SNUM SNAME CITY COMM 1001 Pe...
You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing...
1) I would like to know in which cases we will use ' select object(s) only ' , ' object(s) and direct joins ' and '...
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...
In this set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, whic...