Understanding the Relationship Between Field Definition Attributes and Data Cube Formats
Because data cubes receive data from fields, it is important to correctly set both the attributes of field definitions and the formats of data cubes to ensure compatibility.
The following table describes compatibilities between field definition attributes and data cube formats. Cells marked Yes indicate compatibility. Cells marked No indicate incompatibility. Cells marked Warn indicate potential compatibility and yield a warning during design time. During runtime, the analytic calculation engine generates an error if it determines that the mapping is not compatible.
|
Field Definition Attributes |
Data Cube Format: Number |
Data Cube Format: Date |
Data Cube Format: Member |
Data Cube Format: Text |
|---|---|---|---|---|
|
Char |
Warn |
Warn |
Yes |
Yes |
|
Number |
Yes |
No |
Yes |
Yes |
|
Signed Number |
Yes |
No |
Yes |
Yes |
|
Date |
No |
Yes |
Yes |
Yes |
|
Time |
No |
No |
No |
No |
|
Date Time |
No |
Warn Note: When a date-formatted data cube is mapped to a field with a Date Time attribute, time-specific data is truncated in the data cube data. |
Yes |
Yes |
|
Image |
No |
No |
No |
No |
|
Long Char |
No |
No |
No |
No |