Product specifications

Data type conversion reference
14.1 Data type conversion
In the information design tool, data foundations expose tables from one or more relational databases,
which are the basis for business layers. The data type associated with each table column is displayed
in a data foundation with other column details. Business layers expose table columns as metadata
objects, like dimensions and hierarchies, and display the data type associated with each object. The
following table describes the mapping between these two sets of data types:
Data type shown in the business layerData type shown in the data foundation
BLOBBINARY, LONGVARBINARY, VARBINARY
BooleanBIT
DateDATE
DateTimeTIME, TIMESTAMP
Long TextLONGVARCHAR
Numeric
BIGINT, DECIMAL, DOUBLE, FLOAT, INTEGER,
NUMERIC, REAL, SMALLINT, TINYINT
StringCHAR, VARCHAR, XML
UnknownUNDEFINED
Note:
From any database, a time is managed as a DateTime in the SAP BusinessObjects Business Intelligence
platform. The date part of the DateTime should be normally displayed as the current date in end-user
reports.
2012-03-15177
Data type conversion reference