LDM Object Datatypes in CloudConnect
CloudConnect is a legacy tool and will be discontinued. We recommend that to prepare your data you use the GoodData data pipeline as described in Data Preparation and Distribution. For data modeling, see Data Modeling in GoodData to learn how to work with Logical Data Modeler.
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:
|
| 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.