How to host Multiple RPD and Multiple Presentation.
Tags: Cascading prompts, choice list in prompt, Constrained Prompts in OBIEE 11g, Default SQL Query in Prompts, Default value, Default value in Constrained prompts, OBIEE 11g Prompts, OBIEE Presentation Variable, populate choice list in obiee 11g, populate default value in OBIEE 11g prompt, Presentation variable, Prompt Constraining.
This selection is represented in OBIEE for variables with % as a default value. Add a new filter condition, click on Add More Options, select a variable type (Session Variable, Repository Variable or Presentation Variable), in Variable Expr field specify the name of the variable and in (default) field add the percentage sign (%): Click on OK.
Create multiple aliases for using the same table for different purposes.. This can be done by click on the Name sections under Columns section of the presentation table. OBIEE Report Design. Tours and Travels, Shipyard Constructions, Financial Services and Health Insurance. Avik has worked in different modules such as Finance, HR, Supply.
OBIEE 11G Using a Presentation Variable A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentation varaible is part of a column prompt, it is associated with a specific column and takes on that column's value.
The DataMart or Subject Area that you will query with OBIEE contains two types of tables: DIMENSION tables contain descriptive attributes; FACT tables contain Numbers or Dollars. Dimensional HIERARCHIES are built by OBIEE Repository developers in conjunction with the owners of the data, to allow users to DRILL down into Dimensional data.
The OBIEE has couple of predefined presentation variables which we can reference in analyses, dashboards, KPIs, and agents. we can take advantage of these varaibles and can be used in analysis for better presentation. The below table contains a list of the predefined presentation variables.
This could have multiple benefits as end users may want to rank their customers or rate their regional business based on performance, and be able to use this data from time to time. This converts OBIEE into a useful reporting tool and mini application for modifying business data. 1. Requirements for implementing the functionality.