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 Enterprise Services returns a well defined structure with the view results as well as meta data regarding the view.  

 

hmtoggle_arrow1        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 Enterprise Services view.

[String]

hmtoggle_arrow1        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]

hmtoggle_arrow1        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]

hmtoggle_arrow1        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]

 

hmtoggle_arrow1        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]

 

hmtoggle_arrow1        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]

 

hmtoggle_arrow1        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