The Available Fields section on the left side of the mappings screen will be populated with all of the information associated with the view that was defined in the View Properties and Advanced View Properties screens. Each view returned from TM1Connect returns a well defined structure with the view results as well as meta data regarding the view.
View Fields
CubeName
|
Name of the cube which was queried.
|
[String]
|
RowSet
|
RowSet returns the row count as well as the data rows returned from the query. (see RowSet Fields below)
|
[Object]
|
TitleDimensions
|
Array of dimensions assigned to the titles (filters). Each dimension will contain a number of fields (as described below).
|
[Array of Title Dimensions]
|
ViewName
|
Name of the requested TM1Connect view.
|
[String]
|
|
Title Dimension Fields
DataType
|
DataType is a numeric value which identifies the type of field the dimension ID is being returned as. For title dimensions, this value will always be 1. (See DataTypes below for the list of values and their meanings)
|
[Numeric]
|
DimName
|
Name of the dimension.
|
[String]
|
ID
|
Member ID of the dimension that was selected as a filter.
|
[String]
|
Name
|
If the dimension member contains the alias attributed called Name, the value of that attribute will be returned in this property. If not, the Member ID will be returned and will be the same value as the ID property.
|
[String]
|
|
RowSet Fields
ColDims
|
String containing a list of dimensions that have been used in the columns of the view.
|
[String]
|
RowCount
|
Total number of rows returned from TM1.
|
[Numeric]
|
Rows
|
Array of rows containing the data returned from the view. The
|
[Array of Rows]
|
|
Row Fields
Columns
|
Array of columns that will be returned with data.
|
[Array of Columns]
|
RowDimensions
|
Array of dimensions which have been assigned to the rows of the view.
|
[Array of Row Dimensions]
|
|
|
Row Dimension Fields
DataType
|
DataType is a numeric value which identifies the type of field the dimension ID is being returned as. For row dimensions, this value will always be 1. (See DataTypes below for the list of values and their meanings)
|
[Numeric]
|
DimName
|
Array of columns that will be returned with data.
|
[String]
|
HierarchyLength
|
Array of dimensions which have been assigned to the rows.
|
[Numeric]
|
ID
|
Member ID of the row dimension which represents the data returned from the query.
|
[String]
|
Name
|
If the dimension member contains the alias attributed called Name, the value of that attribute will be returned in this property. If not, the Member ID will be returned and will be the same value as the ID property.
|
[String]
|
|
|
Column Fields
DataType
|
DataType is a numeric value which identifies the type of field the value is being returned as. For row dimensions, this value will always be 1. (See DataTypes below for the list of values and their meanings)
|
[Numeric]
|
FormattedValue
|
If a member on the columns contain a TM1 Format applied to it, this field will be returned with the Value field. This is helpful when using TM1 to centrally manage numerical and date formatting.
|
[String]
|
ID
|
Member ID of the column dimension which represents the data returned from the query.
|
[String]
|
Name
|
If the dimension member contains the alias attributed called Name the value will be returned in this property. If not, the Member ID will be returned and will be the same value as the ID property.
|
[String]
|
SourceDataType
|
This field identifies the type of TM1 field the data was sourced from, and will always be 1 (String) or 2 (Numeric). This is important in cases where a date field is used; because, in TM1, a date can either be stored as a numeric value or as a string value, which will assist in dealing with the Value field.
|
[Numeric]
|
Value
|
Value of the data returned from the query.
|
[String or Numeric]
|
|
|
DataTypes
0
|
Unknown
|
|
1
|
String
|
|
2
|
Numeric
|
|
3
|
Date
|
|
4
|
Boolean
|
|
5
|
Time
|
|
6
|
Currency
|
|
7
|
Picture
|
|
8
|
Blob
|
|
9
|
DateTime
|
|
10
|
HTML
|
|
11
|
CSS
|
|
12
|
JavaScript
|
|
13
|
Object
|
|
14
|
URL
|
|
15
|
Formula
|
|
16
|
PickList
|
|
17
|
Percent
|
|
|
|