Object Datatypes

In the Attributes and Facts window, you can set the type for each object. Depending on the type you select, you can configure the datatype for the selected field. For example, you can specify that decimal values are recorded using three decimals of precision for consistency in your GoodData project.

When an object's data type is properly set, the GoodData Portal understands how to manage sorting of the values in reports.

  • When you select a field in a dataset, its datatype information is displayed in the sidebar. To edit the datatype, click the Pencil icon in the sidebar.
  • You can modify datatypes in the Details sidebar when a field is selected.

For the following field types, you can review the list of available datatype options:

Object Type

Object Datatypes

Description

Attribute

Text

Up to 10000 characters


Integer (INT)

Integer values in the range of min(-2147483648) to max(2147483647)

By identifying attributes as numeric data, the GoodData Portal properly sorts them in reports.


Large Integer (BIGINT)

Integer values in the range of min(-1e+15) to max(1e+15)

By identifying attributes as numeric data, the GoodData Portal properly sorts them in reports.

Fact

Decimal

Decimal values can be configured as follows:

  • M = overall precision of the fact indicates total number of digits before and after the decimal point (minimum: -1e+15, maximum: 1e+15)
  • D = number of digits displayed to the right of the decimal point (maximum: 6)


Integer (INT)

Integer values in the range of min(-2147483648) to max(2147483647)


Large Integer (BIGINT)

Integer values in the range of min(-1e+15) to max(1e+15)


Double

Double values are discouraged, as they are approximations of input values. It is possible to specify them through a MAQL DDL statement.

Date

Date

Dates are recorded in YYYY-MM-DD format.

For more information, see MAQL DDL.