Datasets based on SAP Universes

When creating a dataset based on data from an SAP univese, data is acquired from the database and retrieved to SAP Analytics cloud. The acquired data can be altered by the succession of serialization processes or business logic of the semantic layer.

The table below details the mapping strategy between the different layers involved:

Data Foundation	Business Layer	SAP Analytics Cloud	Data Loss
BIGINT	Numeric	Number	No
BINARY	Blob	N/A
BIT	Numeric	Boolean	No
CHAR	String	String	No
DATE	Date	Date	No
DECIMAL	Numeric	Numeric	No
DOUBLE	Numeric	Numeric	No
FLOAT	Numeric	Numeric	No
INTEGER	Numeric	Integer	No
LONGVARBINARY	Blob	N/A
LONGVARCHAR	Long Text	String	No
NUMERIC	Numeric	Numeric	No
		High Precision Numeric	Yes
REAL	Numeric	Numeric	No
REF_CURSOR		N/A	No
SMALLINT	Numeric	Integer	No
TIME	Datetime	Datetime	No
TIMESTAMP	Datetime	Datetime	No
TINYINT	Numeric	Integer	No
UNDEFINED		N/A
VARBINARY	Blob	N/A	No
VARCHAR	String	String	No
XML		N/A