Obiee - How to create a dummy table ?

Bi Server Architecture With Client


A dummy table is a virtual table where you can perform a select even if it does't exist.

In oracle, the name of this table is “dual” and you use it for several reasons. The most common is :

select REGEXP_INSTR(' 2343  LM  ', '^([[:blank:]]*[0-9]{4}[[:blank:]]*[A-Z]{2}[[:blank:]]*)$') from dual

You don't need any table as you give the data.

  • to handle data. The example below will return always two rows : Month and Quarter.

Article Related

Steps to perform

  • In the physical layer, right click on a physical schema and choose New Physical Table
  • select “Select” as Table Type from the drop down menu
  • and enter the Sql below

Obiee Dummy Table

Second, you need to create the column report_level from the sql statement.

  • click on the column tab and create it

Obiee Dummy Table Columns

If you choose this column in a query, the values MONTH and QUARTER will be returned.

Discover More
Bi Server Architecture With Client
OBIEE - Repository Design

... .. A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:OBIEE Analytics/Reporting...
Obiee Parameter Prompt Result
OBIEE 10G - A special subject area to handle the dashboard parameters prompts

All the prompts in OBIEE are column based prompt. You can't create a list if you don't select a column. And as it's the only way to set up a variable for a formula, it's impossible to bypass this constraint....

Share this page:
Follow us:
Task Runner