Strategy ONE
Define Column Data Types for MDX Cube Data
To Define Column DataTypes for MDX Cube Data
You can define column data types for MDX cube data when you are mapping MDX cube data to Strategy objects. The following procedure assumes you are defining column data types as part of the mapping procedure for an MDX cube using the MDX Cube Catalog. However, you can define column data types as a later modification using the MDX Cube Editor.
- In Developer, log in to a project that is connected to an MDX cube source. Only one user can edit a project at a time.
-
Choose Schema > MDX Cube Catalog.
If the project connects to more than one MDX cube source, choose an MDX cube source database instance from the Select the Database Instance drop-down list, and then select an MDX cube source database instance and click OK to open the MDX Cube Catalog.
- Choose Cube Mapping.
- From the Catalog\Cube drop-down, choose an MDX cube to map to Strategy objects.
- In the Physical view column, expand the MDX cube data until you find the MDX cube column data for which to manually set the data type.
-
If you want to include MDX cube data and data from the data warehouse together on a document, you must map your MDX cube data to attributes that are part of the project's relational schema. See Mapping MDX Cube Data to Project Attributes for details.
Using the automatically created managed object attributes enables you to combine data from multiple MDX cubes on the same document, but no data from the data warehouse can be included.
- Under Logical view, right-click the Strategy object mapped to the MDX cube column data and choose Data Type.
- Clear the Use default from source check box.
-
From the Datatype drop-down, choose which data type to map the MDX cube data as in Strategy.
The Integer data type is commonly used as an ID form data type.
- Depending on the data type chosen, specify the byte length, precision, and scale for the data type.
- Click OK.
Resolving Incompatible Data Type Errors
Defining your MDX cube data with an incompatible data type can cause errors to occur when running a Strategy MDX cube report. An MDX cube report that includes MDX cube data mapped to an incompatible data type fails and no data is returned. When an MDX cube report fails for this reason, an error message is displayed that identifies the data that has been mapped to an incompatible data type.