OBIEE - Expression Builder

Bi Server Architecture With Client


Obiee Expression Builder


You can use the Expression Builder dialog boxes in the Administration Tool to create :

  • constraints,
  • aggregations,
  • and other definitions within a repository.

The expressions you create with the expression builder are similar to expressions created with SQL. Except where noted, you can use all expressions constructed with the expression builder in SQL queries against the Oracle BI Server.

You can access the expression builder from the following dialog boxes:

  • Logical Table Source—Content tab
  • Logical Table Source—Column Mapping tab
  • Logical Column—General tab
  • Logical Column—Aggregation tab
  • Logical Foreign Key
  • Physical Foreign Key
  • Session Variable—Variable tab
  • Static Repository Variable—Variable tab

Discover More
Obiee Case When Lookup
OBIEE - Case When Statement

This article is the case expression in OBIEE Logical SQL. This operator calculation have two type: the the In a CASE statement, AND has precedence over OR. If no ELSE expression is specified,...
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...
Exp Builder Ago Td
OBIEE - Time Series Conversion Functions : AGO and TODATE

Time series functions in OBIEE. The implementation of the time serie function is based on the time dimension. ( See set up time dimensions) At query time, the Oracle BI Server then generates SQL that...

Share this page:
Follow us:
Task Runner