OBIEE - Cast function

Obiee Ceim

About

The cast function is the coercion function of OBIEE

Example

  • to a varchar
cast(database.table.column as VARCHAR2(100)




Discover More
Bi Server Architecture With Client
OBIEE - Date Datatype and Functions

This article contains all information and articles the date datatype in OBIEE. The SQL 92 standard defines three kinds of 'typed' datetime literals, in the following formats: To express...
Obiee Integer Format Wide Default
OBIEE - Integer Datatype

In OBIEE, the integer datatype: follows the rule of an integer division (without the decimal part) is mandatory for some OBIEE intern use such as the LOGLEVEL variable or the indexcol function ...
Obiee Ceim
OBIEE 10G/11G - cast(NULL as INTEGER)

When debugging a report that doesn't retrieve result (with NULL or zero value) for an measure, you may remark that your measure has been replaced with a statement such as: This statement means that OBI...



Share this page:
Follow us:
Task Runner