Page tree
Skip to end of metadata
Go to start of metadata

The lengthy JSON strings on the page are recommended to be copied out to a notepad++ with JSONViewer plugin to make it more readable.

GeoPointAttribute (1GEOPOINT)

BW INA Metadata Response

  • Geographical data can be requested via geographical attributes. Depending on the GISTP (for more information please see wiki page) different geographical attributes are set by the BW backend as part of the BW INA Metadata response.
  • Geographical characteristic with GISTP 1 (Shape), 2 (Point Data) and 4 (Shape and Point Data) gains GeoPointAttribute (Cube.Dimensions.GeoPointAttribute) which is a meta attribute 1GEOPOINT.KEY. By using Geographical characteristic GA_GEO8, the GeoPointAttribute is GA_GEO8.1GEOPOINT.KEY. 
  • Geographical characteristic with GISTP 3 (Derived Point Data of an Attribute) only gains GeoPointAttribute (Cube.Dimensions.GeoPointAttribute) which is a meta attribute 1GEOPOINT.KEY, if the attribute is a navigation attribute and it already has geographical table generated.

SAC INA ResultSet Request

  • Client can request geographical point data as an attribute by using 1GEOPOINT (Analytics.Definition.Dimensions.Attributes) with presentation .KEY (GA_GEO8.1GEOPOINT.KEY) in the SAC INA ResultSet Request.

BW INA ResultSet Response

  • BW as a result can returns geographical point data for attribute 1GEOPOINT (Grids.Axes.Dimensions.Attributes) in presentation .KEY format (GA_GEO8.1GEOPOINT.KEY) in the BW INA ResultSet Response.

GeoShapeAttribute (0GSHAPE3857)

BW INA Metadata Response

  • Geographical characteristic with GISTP 1 (Shape) and 4 (Shape and Point Data) gains GeoShapeAttribute (Cube.Dimensions.GeoShapeHierarchies) which is a meta attribute 0GSHAPE3857. By using Geographical characteristic GA_GEO8__GA_NAV1, the GeoShapeAttribute is GA_GEO8__GA_NAV1.1GSHAPE3857.KEY.
  • It means that later on the Client can request shapes as an attribute by using 1GSHAPE3857 with presentation .KEY.

SAC INA ResultSet Request

  • Client can request geographical shapes as an attribute by using 1GSHAPE3857 (Analytics.Definition.Dimensions.Attributes)  with presentation .KEY (GA_GEO8__GA_NAV1.1GSHAPE3857.KEY) in the SAC INA ResultSet Request.
  • Shapes van be requested with additional parameter TextTransformation (Analytics.Definition.Dimensions.Attributes.TextTransformation). TextTransformation: "SpatialAsGeoJSON" tells the server to provide the shapes in Json format that is the preferred format for SAC.

BW INA ResultSet Response

  • BW as a result returns shapes for attribute 1GSHAPE3857 (Grids.Axes.Dimensions.Attributes) in presentation .KEY format (GA_GEO8__GA_NAV1.1GSHAPE3857.KEY) in the BW INA ResultSet Response.

GeoLevelAttribute (0H_TLEVEL)

BW INA Metadata Response

  • For Default Choropleth layer, a technical navigation attribute 0GEOFEATID is used. It gains GeoLevelAttribute (Cube.Dimensions.GeoLevelAttributewhich is a meta attribute 0H_TLEVEL. By using Geographical characteristic with 0GEOFEATID navigation attribute GA_GEO8__0GEOFEATID, the GeoLevelAttribute is GA_GEO8__0GEOFEATID.0H_TLEVEL.KEY.
  • It means that later on the Client can request the hierarchy levels of SAPBWWORLDHIERARCHY  which is available for 0GEOFEATID, by using 0H_TLEVEL with wither presentation .KEY, or DISPLAY_KEY.
BW INA Metadata Response
		"Dimensions": [{
				"Name": "GA_GEO8__0GEOFEATID",
				"ID": 108917,
				"Description": "Feature ID/Region",
				"DimensionType": 3,
				"DataType": "NUMC",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY", "GA_GEO8__0GEOFEATID.LONG_TEXT", "GA_GEO8__0GEOFEATID.KEY", "GA_GEO8__0GEOFEATID.DISPLAY_KEY", "GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY"],
					"DefaultKeyAttribute": "GA_GEO8__0GEOFEATID.KEY",
					"DefaultTextAttribute": "GA_GEO8__0GEOFEATID.LONG_TEXT",
					"DefaultDisplayKeyAttribute": "GA_GEO8__0GEOFEATID.DISPLAY_KEY",
					"Name": "GA_GEO8__0GEOFEATID",
					"Description": "Feature ID/Region",
					"HierarchyKeyAttribute": "GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY",
					"HierarchyNavigationAttribute": "GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY",
					"HierarchyTextAttribute": "GA_GEO8__0GEOFEATID.LONG_TEXT",
					"HierarchyDisplayKeyAttribute": "GA_GEO8__0GEOFEATID.DISPLAY_KEY",
					"DefaultResultSetAttributes": ["GA_GEO8__0GEOFEATID.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__0GEOFEATID.0GSHAPE3857",
							"Description": "",
							"DefaultResultSetAttributes": ["GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__0GEOFEATID.0H_TLEVEL.DISPLAY_KEY", "GA_GEO8__0GEOFEATID.0H_TLEVEL.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__0GEOFEATID.0H_TLEVEL.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__0GEOFEATID.0H_TLEVEL",
							"Description": "Hierarchy Level",
							"DefaultResultSetAttributes": ["GA_GEO8__0GEOFEATID.0H_TLEVEL.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__0GEOFEATID.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__0GEOFEATID.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__0GEOFEATID.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8__0GEOFEATID"],
				"HierarchyActiveDefault": "false",
				"TextAttribute": "GA_GEO8__0GEOFEATID.LONG_TEXT",
				"KeyAttribute": "GA_GEO8__0GEOFEATID.KEY",
				"GeoShapeAttribute": "GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY",
				"GeoLevelAttribute": "GA_GEO8__0GEOFEATID.0H_TLEVEL.KEY",
				"GeoPointAttribute": "GA_GEO8__0GEOFEATID.1GEOPOINT.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"HierarchiesPossible": true,
				"NumberOfHierarchies": 1,
				"Attributes": [{
						"Name": "GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.LONG_TEXT",
						"Length": 60,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "LongText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.KEY",
						"IsKey": true,
						"Length": 60,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY",
						"InfoobjType": "ATR",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": false,
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.0H_TLEVEL.DISPLAY_KEY",
						"Length": 2,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.0H_TLEVEL.KEY",
						"Length": 2,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__0GEOFEATID.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 15,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_GEO8__GA_NAV1",
				"ID": 108918,
				"Description": "GA_GEO8__GA_NAV1",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8__GA_NAV1.KEY", "GA_GEO8__GA_NAV1.DISPLAY_KEY", "GA_GEO8__GA_NAV1.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV1.1GSHAPE3857.KEY"],
					"DefaultKeyAttribute": "GA_GEO8__GA_NAV1.KEY",
					"DefaultTextAttribute": "",
					"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV1.DISPLAY_KEY",
					"Name": "GA_GEO8__GA_NAV1",
					"Description": "GA_GEO8__GA_NAV1",
					"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV1.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8__GA_NAV1.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV1.1GSHAPE3857.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV1.1GSHAPE3857.XXL",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV1.1GSHAPE3857",
							"Description": "Geographical Shape",
							"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV1.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV1.1GSHAPE3857.KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__GA_NAV1.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV1.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV1.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8__GA_NAV1"],
				"HierarchyActiveDefault": "false",
				"KeyAttribute": "GA_GEO8__GA_NAV1.KEY",
				"GeoShapeAttribute": "GA_GEO8__GA_NAV1.1GSHAPE3857.KEY",
				"GeoPointAttribute": "GA_GEO8__GA_NAV1.1GEOPOINT.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_GEO8__GA_NAV1.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV1.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV1.1GSHAPE3857.XXL",
						"InfoobjType": "XXL",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "XXL",
						"Description": "Geographical Shape",
						"IsFilterable": false,
						"DataType": "String",
						"MIMEType": "application/vnd.geo+json"
					}, {
						"Name": "GA_GEO8__GA_NAV1.1GSHAPE3857.KEY",
						"InfoobjType": "ATR",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": false,
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8__GA_NAV1.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 5,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_GEO8__GA_NAV11",
				"ID": 108919,
				"Description": "GA_GEO8__GA_NAV11",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8__GA_NAV11.KEY", "GA_GEO8__GA_NAV11.DISPLAY_KEY", "GA_GEO8__GA_NAV11.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV11.1GSHAPE3857.KEY"],
					"DefaultKeyAttribute": "GA_GEO8__GA_NAV11.KEY",
					"DefaultTextAttribute": "",
					"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV11.DISPLAY_KEY",
					"Name": "GA_GEO8__GA_NAV11",
					"Description": "GA_GEO8__GA_NAV11",
					"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV11.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8__GA_NAV11.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV11.1GSHAPE3857.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV11.1GSHAPE3857.XXL",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV11.1GSHAPE3857",
							"Description": "Geographical Shape",
							"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV11.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV11.1GSHAPE3857.KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__GA_NAV11.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV11.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV11.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8__GA_NAV11"],
				"HierarchyActiveDefault": "false",
				"KeyAttribute": "GA_GEO8__GA_NAV11.KEY",
				"GeoShapeAttribute": "GA_GEO8__GA_NAV11.1GSHAPE3857.KEY",
				"GeoPointAttribute": "GA_GEO8__GA_NAV11.1GEOPOINT.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_GEO8__GA_NAV11.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV11.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV11.1GSHAPE3857.XXL",
						"InfoobjType": "XXL",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "XXL",
						"Description": "Geographical Shape",
						"IsFilterable": false,
						"DataType": "String",
						"MIMEType": "application/vnd.geo+json"
					}, {
						"Name": "GA_GEO8__GA_NAV11.1GSHAPE3857.KEY",
						"InfoobjType": "ATR",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": false,
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8__GA_NAV11.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 5,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_GEO8__GA_NAV12",
				"ID": 108920,
				"Description": "GA_GEO8__GA_NAV12",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8__GA_NAV12.KEY", "GA_GEO8__GA_NAV12.DISPLAY_KEY", "GA_GEO8__GA_NAV12.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV12.1GSHAPE3857.KEY"],
					"DefaultKeyAttribute": "GA_GEO8__GA_NAV12.KEY",
					"DefaultTextAttribute": "",
					"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV12.DISPLAY_KEY",
					"Name": "GA_GEO8__GA_NAV12",
					"Description": "GA_GEO8__GA_NAV12",
					"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV12.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8__GA_NAV12.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV12.1GSHAPE3857.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV12.1GSHAPE3857.XXL",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV12.1GSHAPE3857",
							"Description": "Geographical Shape",
							"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV12.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV12.1GSHAPE3857.KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__GA_NAV12.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV12.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV12.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8__GA_NAV12"],
				"HierarchyActiveDefault": "false",
				"KeyAttribute": "GA_GEO8__GA_NAV12.KEY",
				"GeoShapeAttribute": "GA_GEO8__GA_NAV12.1GSHAPE3857.KEY",
				"GeoPointAttribute": "GA_GEO8__GA_NAV12.1GEOPOINT.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_GEO8__GA_NAV12.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV12.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV12.1GSHAPE3857.XXL",
						"InfoobjType": "XXL",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "XXL",
						"Description": "Geographical Shape",
						"IsFilterable": false,
						"DataType": "String",
						"MIMEType": "application/vnd.geo+json"
					}, {
						"Name": "GA_GEO8__GA_NAV12.1GSHAPE3857.KEY",
						"InfoobjType": "ATR",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": false,
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8__GA_NAV12.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 5,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_GEO8__GA_NAV21",
				"ID": 108921,
				"Description": "GA_NAV21Custom Shape",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8__GA_NAV21.KEY", "GA_GEO8__GA_NAV21.DISPLAY_KEY", "GA_GEO8__GA_NAV21.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV21.1GSHAPE3857.KEY"],
					"DefaultKeyAttribute": "GA_GEO8__GA_NAV21.KEY",
					"DefaultTextAttribute": "",
					"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV21.DISPLAY_KEY",
					"Name": "GA_GEO8__GA_NAV21",
					"Description": "GA_NAV21Custom Shape",
					"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV21.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8__GA_NAV21.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV21.1GSHAPE3857.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV21.1GSHAPE3857.XXL",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV21.1GSHAPE3857",
							"Description": "Geographical Shape",
							"DefaultResultSetAttributes": ["GA_GEO8__GA_NAV21.1GSHAPE3857.XXL", "GA_GEO8__GA_NAV21.1GSHAPE3857.KEY"]
						}, {
							"AttributeNames": ["GA_GEO8__GA_NAV21.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8__GA_NAV21.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8__GA_NAV21.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8__GA_NAV21"],
				"HierarchyActiveDefault": "false",
				"KeyAttribute": "GA_GEO8__GA_NAV21.KEY",
				"GeoShapeAttribute": "GA_GEO8__GA_NAV21.1GSHAPE3857.KEY",
				"GeoPointAttribute": "GA_GEO8__GA_NAV21.1GEOPOINT.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_GEO8__GA_NAV21.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV21.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8__GA_NAV21.1GSHAPE3857.XXL",
						"InfoobjType": "XXL",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "XXL",
						"Description": "Geographical Shape",
						"IsFilterable": false,
						"DataType": "String",
						"MIMEType": "application/vnd.geo+json"
					}, {
						"Name": "GA_GEO8__GA_NAV21.1GSHAPE3857.KEY",
						"InfoobjType": "ATR",
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": false,
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8__GA_NAV21.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 5,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_PROD",
				"ID": 99775,
				"Description": "GA_PROD Product",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Free",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_PROD.SHORT_TEXT", "GA_PROD.KEY", "GA_PROD.DISPLAY_KEY"],
					"DefaultKeyAttribute": "GA_PROD.KEY",
					"DefaultTextAttribute": "GA_PROD.SHORT_TEXT",
					"DefaultDisplayKeyAttribute": "GA_PROD.DISPLAY_KEY",
					"Name": "GA_PROD",
					"Description": "GA_PROD Product",
					"DefaultResultSetAttributes": ["GA_PROD.DISPLAY_KEY"],
					"Children": []
				},
				"DefaultResultSetAttributeNodes": ["GA_PROD"],
				"HierarchyActiveDefault": "false",
				"TextAttribute": "GA_PROD.SHORT_TEXT",
				"KeyAttribute": "GA_PROD.KEY",
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_PROD.SHORT_TEXT",
						"Length": 20,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "ShortText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_PROD.KEY",
						"IsKey": true,
						"Length": 20,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_PROD.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "",
					"ResultStructure": [{
							"Result": "Total",
							"Visibility": "Visible"
						}, {
							"Result": "Members",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 25,
				"Hierarchies": [],
				"LevelHierarchies": []
			}, {
				"Name": "GA_GEO8",
				"ID": 108496,
				"Description": "GA_GEO8 Attribute Hi",
				"DimensionType": 3,
				"DataType": "CHAR",
				"AxisDefault": "Rows",
				"AxisConstraints": ["Rows", "Columns", "Free"],
				"DefaultResultSetAttributes": [],
				"HasCheckTable": true,
				"SupportsCummulative": true,
				"AttributeHierarchy": {
					"AttributeNames": ["GA_GEO8.KEY", "GA_GEO8.DISPLAY_KEY"],
					"DefaultKeyAttribute": "GA_GEO8.KEY",
					"DefaultTextAttribute": "",
					"DefaultDisplayKeyAttribute": "GA_GEO8.DISPLAY_KEY",
					"Name": "GA_GEO8",
					"Description": "GA_GEO8 Attribute Hi",
					"DefaultResultSetAttributes": ["GA_GEO8.DISPLAY_KEY"],
					"Children": [{
							"AttributeNames": ["GA_GEO8.0ALTITUDE.DISPLAY_KEY", "GA_GEO8.0ALTITUDE.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0ALTITUDE.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.0ALTITUDE",
							"Description": "Geographical Height",
							"DefaultResultSetAttributes": ["GA_GEO8.0ALTITUDE.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.0GEOFEATID.DISPLAY_KEY", "GA_GEO8.0GEOFEATID.LONG_TEXT", "GA_GEO8.0GEOFEATID.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0GEOFEATID.KEY",
							"DefaultTextAttribute": "GA_GEO8.0GEOFEATID.LONG_TEXT",
							"Name": "GA_GEO8.0GEOFEATID",
							"Description": "Feature ID/Region",
							"DefaultResultSetAttributes": ["GA_GEO8.0GEOFEATID.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.0LATITUDE.DISPLAY_KEY", "GA_GEO8.0LATITUDE.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0LATITUDE.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.0LATITUDE",
							"Description": "Latitude",
							"DefaultResultSetAttributes": ["GA_GEO8.0LATITUDE.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.0LONGITUDE.DISPLAY_KEY", "GA_GEO8.0LONGITUDE.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0LONGITUDE.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.0LONGITUDE",
							"Description": "Longitude",
							"DefaultResultSetAttributes": ["GA_GEO8.0LONGITUDE.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.0PRECISID.DISPLAY_KEY", "GA_GEO8.0PRECISID.SHORT_TEXT", "GA_GEO8.0PRECISID.MEDIUM_TEXT", "GA_GEO8.0PRECISID.LONG_TEXT", "GA_GEO8.0PRECISID.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0PRECISID.KEY",
							"DefaultTextAttribute": "GA_GEO8.0PRECISID.SHORT_TEXT",
							"Name": "GA_GEO8.0PRECISID",
							"Description": "Geo-precision",
							"DefaultResultSetAttributes": ["GA_GEO8.0PRECISID.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.0SRCID.DISPLAY_KEY", "GA_GEO8.0SRCID.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.0SRCID.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.0SRCID",
							"Description": "DatSrc.ID of GeoLoct",
							"DefaultResultSetAttributes": ["GA_GEO8.0SRCID.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.1GEOPOINT.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.1GEOPOINT.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.1GEOPOINT",
							"Description": "Geopoint",
							"DefaultResultSetAttributes": []
						}, {
							"AttributeNames": ["GA_GEO8.GA_NAV1.DISPLAY_KEY", "GA_GEO8.GA_NAV1.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.GA_NAV1.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.GA_NAV1",
							"Description": "GA_NAV1",
							"DefaultResultSetAttributes": ["GA_GEO8.GA_NAV1.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.GA_NAV11.DISPLAY_KEY", "GA_GEO8.GA_NAV11.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.GA_NAV11.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.GA_NAV11",
							"Description": "GA_NAV11",
							"DefaultResultSetAttributes": ["GA_GEO8.GA_NAV11.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.GA_NAV12.DISPLAY_KEY", "GA_GEO8.GA_NAV12.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.GA_NAV12.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.GA_NAV12",
							"Description": "GA_NAV12",
							"DefaultResultSetAttributes": ["GA_GEO8.GA_NAV12.DISPLAY_KEY"]
						}, {
							"AttributeNames": ["GA_GEO8.GA_NAV21.DISPLAY_KEY", "GA_GEO8.GA_NAV21.KEY"],
							"DefaultKeyAttribute": "GA_GEO8.GA_NAV21.KEY",
							"DefaultTextAttribute": "",
							"Name": "GA_GEO8.GA_NAV21",
							"Description": "GA_NAV21Custom Shape",
							"DefaultResultSetAttributes": ["GA_GEO8.GA_NAV21.DISPLAY_KEY"]
						}
					]
				},
				"DefaultResultSetAttributeNodes": ["GA_GEO8"],
				"HierarchyActiveDefault": "false",
				"KeyAttribute": "GA_GEO8.KEY",
				"GeoPointAttribute": "GA_GEO8.1GEOPOINT.KEY",
				"GeoShapeHierarchies": [{
						"Name": "KDV42ST19XZCGEBTBFBIHWU1B",
						"Description": "GA_NAV1~GA_NAV11",
						"Levels": [{
								"Level": 1,
								"NavAttr": "GA_GEO8__GA_NAV1",
								"Description": "GA_NAV1"
							}, {
								"Level": 2,
								"NavAttr": "GA_GEO8__GA_NAV11",
								"Description": "GA_NAV11"
							}
						]
					}, {
						"Name": "KB6FU5OPPMP79UCZL7MVCWPN3",
						"Description": "GA_NAV1~GA_NAV12",
						"Levels": [{
								"Level": 1,
								"NavAttr": "GA_GEO8__GA_NAV1",
								"Description": "GA_NAV1"
							}, {
								"Level": 2,
								"NavAttr": "GA_GEO8__GA_NAV12",
								"Description": "GA_NAV12"
							}
						]
					}, {
						"Name": "IUC9WUG8XVILQXYIO80OABAOM",
						"Description": "GA_NAV1~GA_NAV21Custom Shape",
						"Levels": [{
								"Level": 1,
								"NavAttr": "GA_GEO8__GA_NAV1",
								"Description": "GA_NAV1"
							}, {
								"Level": 2,
								"NavAttr": "GA_GEO8__GA_NAV21",
								"Description": "GA_NAV21Custom Shape"
							}
						]
					}
				],
				"SelectorReadMode": "BookedAndSpaceAndState",
				"DefaultSelectorReadMode": "BookedAndSpaceAndState",
				"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
				"ResultSetReadMode": "BookedAndSpaceAndState",
				"DefaultResultSetReadMode": "BookedAndSpaceAndState",
				"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
				"VariableReadMode": "BookedAndSpace",
				"DefaultVariableReadMode": "BookedAndSpace",
				"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
				"Attributes": [{
						"Name": "GA_GEO8.KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.DISPLAY_KEY",
						"IsKey": true,
						"Length": 0,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 1,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0ALTITUDE.DISPLAY_KEY",
						"Length": 23,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0ALTITUDE.KEY",
						"Length": 9,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0GEOFEATID.DISPLAY_KEY",
						"Length": 15,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0GEOFEATID.LONG_TEXT",
						"Length": 60,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "LongText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0GEOFEATID.KEY",
						"Length": 15,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0LATITUDE.DISPLAY_KEY",
						"Length": 17,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0LATITUDE.KEY",
						"Length": 8,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0LONGITUDE.DISPLAY_KEY",
						"Length": 17,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0LONGITUDE.KEY",
						"Length": 8,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0PRECISID.DISPLAY_KEY",
						"Length": 4,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0PRECISID.SHORT_TEXT",
						"Length": 20,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "ShortText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0PRECISID.MEDIUM_TEXT",
						"Length": 40,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "MediumText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0PRECISID.LONG_TEXT",
						"Length": 60,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "LongText",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "Range"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0PRECISID.KEY",
						"Length": 4,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0SRCID.DISPLAY_KEY",
						"Length": 4,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.0SRCID.KEY",
						"Length": 4,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.1GEOPOINT.KEY",
						"Length": 250,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "Geometry",
						"DataTypeAsInt": "10"
					}, {
						"Name": "GA_GEO8.GA_NAV1.DISPLAY_KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV1.KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV11.DISPLAY_KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV11.KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV12.DISPLAY_KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV12.KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV21.DISPLAY_KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "DisplayKey",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}, {
						"Name": "GA_GEO8.GA_NAV21.KEY",
						"Length": 5,
						"Decimals": 0,
						"InitialValue": "",
						"SortOrder": 0,
						"PresentationType": "Key",
						"Description": "",
						"IsFilterable": true,
						"FilterCapability": {
							"ComparisonGroup": "SingleValue"
						},
						"DataType": "String"
					}
				],
				"DefaultResultStructure": {
					"ResultAlignment": "Bottom",
					"ResultStructure": [{
							"Result": "Members",
							"Visibility": "Visible"
						}, {
							"Result": "Total",
							"Visibility": "Visible"
						}
					]
				},
				"MultipleValues": true,
				"NameExternal": "",
				"Length": 5,
				"Hierarchies": [],
				"LevelHierarchies": []
			}
		]
SAC INA ResultSet Request
{
	"Analytics": {
		"Capabilities": ["AttributeHierarchy", "AttributeHierarchyHierarchyFields", "CartesianFilterIntersect", "CatalogServiceV20", "ClientCapabilities", "ClientInfo", "ComplexTupleFilter", "Conditions", "CubeBlending", "CubeBlendingPersistanceType", "CustomMeasureSortOrder", "CustomMemberKeySortOrder", "DatasourceAtService", "DefinitionReturnsVariableValues", "DetailedResponseExpansion", "DimF4SelectionWithCompoundment", "DimensionDescription", "DimensionHierarchyLevels", "DynamicRestrictionOnFormula", "ExceptionAggregationDimsAndFormulas", "Exceptions", "ExceptionsV2", "ExpandHierarchyBottomUp", "ExtHierarchy", "ExtendedDimensionTypes", "ExtendedVariableDefinition", "F4FilterForTextField", "FastPath", "HierarchyLevelOffsetFilter", "HierarchyNameVariable", "HierarchyNavigationCounter", "INACurrentMember", "InAPersisted", "InitialDrillLevelRelative", "MDMHierarchyDrillLevel", "MDSLikePaging", "MaintainsVariableVariants", "MaxResultRecords", "MetadataBaseMeasureName", "NewValuesExtendedFormat", "NewValuesImplicitUnlock", "Obtainability", "PagingTupleCountTotal", "PresentationLength", "QDataCells", "QueryCurrencyTranslation", "RRI", "ReadMode", "ReadModesV2", "RemoteBlending", "RespectUnassignedNodeSetting", "ResultSetAxisType", "ResultSetInterval", "ResultSetUnitIndex", "RsCellValueTypes", "SAPDate", "SemanticalErrorType", "ServerStructureNames", "SpatialChoropleth", "SpatialClustering", "SpatialFilterSRID", "StatefulServer", "StructureRestrictionsInValueHelp", "SubmitReturnsVariableValues", "Supplements", "SupportsCalculatedKeyFigures", "SupportsCummulative", "SupportsDataCellMixedValues", "SupportsDataRefresh", "SupportsDataRefreshAndDataTopicality", "SupportsDimensionFilterCapability", "SupportsDimensionTypeTime", "SupportsEncodedResultSet", "SupportsExtendedSort", "SupportsHierarchySelectionAsFlatSelection", "SupportsIgnoreExternalDimensions", "SupportsKeyfigureHierarchies", "SupportsMemberVisibility", "SupportsOperatorTotals", "SupportsOperatorVariance", "SupportsOriginalTexts", "SupportsRestrictedKeyFigures", "SupportsSetOperand", "SupportsSpatialFilter", "SupportsSpatialTransformations", "SupportsUniversalDisplayHierarchies", "SupportsVariableVariants", "SuppressKeyfigureCalculation", "SuppressSupplements", "TransientHierarchy1", "UnifiedDataCells", "UniversalDisplayHierarchyCustomDimensions", "ValueHelpWithAttributes", "VariableAutoSubmit", "VariableMasking", "VariableReSubmit", "ZeroSuppression"],
		"DataSource": {
			"InstanceId": "785dc783-b35d-07c8-fab1-291aa96c60c7",
			"ObjectName": "GA_QUERY15",
			"Type": "Query"
		},
		"Definition": {
			"Dimensions": [{
					"Attributes": [{
							"Name": "GA_GEO8.KEY",
							"Obtainability": "Always"
						}, {
							"Name": "GA_GEO8.DISPLAY_KEY",
							"Obtainability": "Always"
						}, {
							"Name": "GA_GEO8.1GEOPOINT.KEY",
							"Obtainability": "Always",
							"TextTransformation": "SpatialAsGeoJSON"
						}
					],
					"Axis": "Rows",
					"ClusterDefinition": {
						"Active": true,
						"ClusterAlgorithm": "K-Means",
						"ClusterParameters": {
							"Clusters": 1000,
							"MaxIterations": 128,
							"Threshold": 0
						},
						"GeometryAttribute": "GA_GEO8.1GEOPOINT.KEY"
					},
					"IsCummulative": false,
					"Name": "GA_GEO8",
					"NonEmpty": false,
					"ReadMode": "BookedAndSpaceAndState",
					"ResultSetReadMode": "BookedAndSpaceAndState",
					"ResultStructure": [{
							"Result": "Members",
							"Visibility": "Visible"
						}, {
							"Result": "Total",
							"Visibility": "Always"
						}
					]
				}, {
					"Attributes": [{
							"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K.LONG_TEXT",
							"Obtainability": "Always"
						}, {
							"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K.KEY",
							"Obtainability": "UserInterface"
						}
					],
					"Axis": "Columns",
					"Members": [{
							"MemberOperand": {
								"AttributeName": "Measures",
								"Comparison": "=",
								"Value": "1ROWCOUNT"
							},
							"Visibility": "Visible"
						}
					],
					"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K",
					"NonEmpty": true,
					"ReadMode": "Booked",
					"ResultSetReadMode": "Booked"
				}
			],
			"Filter": {
				"Selection": {
					"Operator": {
						"Code": "And",
						"SubSelections": [{
								"SetOperand": {
									"Elements": [{
											"Comparison": "IS_NULL",
											"IsExcluding": true
										}
									],
									"FieldName": "GA_GEO8.KEY"
								}
							}
						]
					}
				}
			},
			"ResultSetFeatureRequest": {
				"IgnoreAutoSubmit": true,
				"MaxResultRecords": 5000000,
				"ResultEncoding": "None",
				"ResultFormat": "Version2",
				"ResultKeepOriginalTexts": false,
				"SubSetDescription": {
					"ColumnFrom": 0,
					"ColumnTo": -1,
					"RowFrom": 0,
					"RowTo": 20001
				},
				"UseDefaultAttributeKey": false
			}
		},
		"Language": "en"
	},
	"ClientInfo": {
		"Identifier": "AnalyticsCloud"
	},
	"Options": ["StatefulServer"]
}
BW INA ResultSet Response
{
	"Grids": [{
			"DataSource": {
				"ObjectName": "GA_QUERY15",
				"Type": "Query",
				"Description": "GA_QUERY15 Custom Shape 4 Attribute Hierarchy Geo Type 1",
				"InstanceId": "785dc783-b35d-07c8-fab1-291aa96c60c7",
				"DataArea": "DEFAULT",
				"DataLastRefresh": "20220412122925",
				"DataRollupMin": "20200123115511",
				"DataRollupMax": "20200123115511",
				"InstanceHandle": "0018"
			},
			"Axes": [{
					"Name": "ROWS",
					"Type": "Rows",
					"Dimensions": [{
							"Name": "GA_GEO8",
							"Description": "GA_GEO8 Attribute Hi",
							"Attributes": [{
									"Name": "GA_GEO8.KEY",
									"Description": "Internal Key",
									"IsKey": true,
									"Obtainability": "Always",
									"Values": ["1 ", "2 ", "3 ", "4 ", "5 "]
								}, {
									"Name": "GA_GEO8.DISPLAY_KEY",
									"Description": "External Key",
									"IsKey": false,
									"Obtainability": "Always",
									"Values": ["1 ", "2 ", "3 ", "4 ", "5 "]
								}, {
									"Name": "GA_GEO8.1GEOPOINT.KEY",
									"Description": "Internal Key",
									"IsKey": true,
									"Obtainability": "Always",
									"Values": ["{\"type\": \"Point\", \"coordinates\": [1022239.3031, 6236912.1434]}", "{\"type\": \"Point\", \"coordinates\": [1008292.4118, 6194079.5729]}", "{\"type\": \"Point\", \"coordinates\": [1163458.51764, 6650655.10785]}", "{\"type\": \"Point\", \"coordinates\": [1002269.4925, 6217654.1886]}", "{\"type\": \"Point\", \"coordinates\": [962108.62854, 6327006.728]}"]
								}
							],
							"MemberTypes": {
								"Encoding": "None",
								"Size": 5,
								"Values": [0, 0, 0, 0, 0]
							}
						}
					],
					"TupleCount": 5,
					"TupleCountTotal": 5,
					"ExceptionAlertLevel": {
						"Encoding": "",
						"Size": 5,
						"Values": [0, 0, 0, 0, 0]
					},
					"ExceptionName": {
						"Encoding": "",
						"Size": 5,
						"Values": ["", "", "", "", ""]
					},
					"Tuples": [{
							"MemberIndexes": {
								"Encoding": "None",
								"Size": 5,
								"Values": [0, 1, 2, 3, 4]
							},
							"ParentIndexes": {
								"Encoding": "None",
								"Size": 5,
								"Values": [-1, -1, -1, -1, -1]
							},
							"DisplayLevel": {
								"Encoding": "None",
								"Size": 5,
								"Values": [0, 0, 0, 0, 0]
							},
							"Level": {
								"Encoding": "None",
								"Size": 0,
								"Values": []
							},
							"DrillState": {
								"Encoding": "None",
								"Size": 5,
								"Values": [0, 0, 0, 0, 0]
							}
						}
					]
				}, {
					"Name": "COLUMNS",
					"Type": "Columns",
					"Dimensions": [{
							"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K",
							"Description": "Key Figures",
							"Attributes": [{
									"Name": "1ROWCOUNT.LONG_TEXT",
									"Description": "Long Text",
									"IsKey": false,
									"Obtainability": "Always",
									"Values": ["Number of Records"]
								}, {
									"Name": "1ROWCOUNT.KEY",
									"Description": "Internal Key",
									"IsKey": true,
									"Obtainability": "UserInterface",
									"Values": ["1ROWCOUNT"]
								}
							],
							"MemberTypes": {
								"Encoding": "None",
								"Size": 1,
								"Values": [0]
							}
						}
					],
					"TupleCount": 1,
					"TupleCountTotal": 1,
					"ExceptionAlertLevel": {
						"Encoding": "",
						"Size": 1,
						"Values": [0]
					},
					"ExceptionName": {
						"Encoding": "",
						"Size": 1,
						"Values": [""]
					},
					"Tuples": [{
							"MemberIndexes": {
								"Encoding": "None",
								"Size": 1,
								"Values": [0]
							},
							"ParentIndexes": {
								"Encoding": "None",
								"Size": 1,
								"Values": [-1]
							},
							"DisplayLevel": {
								"Encoding": "None",
								"Size": 1,
								"Values": [0]
							},
							"Level": {
								"Encoding": "None",
								"Size": 0,
								"Values": []
							},
							"DrillState": {
								"Encoding": "None",
								"Size": 1,
								"Values": [0]
							}
						}
					]
				}
			],
			"Units": [],
			"Cells": {
				"Exceptions": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"LockedValue": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"InputEnabled": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"ExceptionAlertLevel": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"ExceptionName": {
					"Encoding": "None",
					"Size": 5,
					"Values": ["", "", "", "", ""]
				},
				"Values": {
					"Encoding": "None",
					"Size": 5,
					"Values": [1, 1, 1, 1, 1]
				},
				"ValuesFormatted": {
					"Encoding": "None",
					"Size": 5,
					"Values": ["1 ", "1 ", "1 ", "1 ", "1 "]
				},
				"ValuesRounded": {
					"Encoding": "None",
					"Size": 5,
					"Values": ["1 ", "1 ", "1 ", "1 ", "1 "]
				},
				"QueryDataCellReferences": {
					"Encoding": "None",
					"Size": 5,
					"Values": ["1", "1", "1", "1", "1"]
				},
				"CellValueTypes": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"NumericRounding": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"NumericShift": {
					"Encoding": "None",
					"Size": 5,
					"Values": [0, 0, 0, 0, 0]
				},
				"CellFormat": {
					"Encoding": "None",
					"Size": 5,
					"Values": ["0", "0", "0", "0", "0"]
				}
			},
			"CellArraySizes": [5, 1],
			"DataEntryMask": {
				"NumberofInputEnabledCells": 0,
				"QueryCellNames": []
			}
		}
	],
	"DataAreas": [{
			"Name": "DEFAULT",
			"Environment": "",
			"Model": "",
			"CellLocking": "",
			"IsWorkStatusActive": false,
			"HasChangedData": false,
			"ChangeCounter": 0
		}
	],
	"Messages": [],
	"PerformanceData": {
		"SessionId": "4VGQIK77R2ZTE0IJE942NU72S",
		"StepId": "4VGQIK77R2ZTE0IJE942NU0R8",
		"Runtime": 1.31027,
		"Timestamp": "2022-04-12 12:29:25.837130",
		"Measurements": [{
				"Description": "ABAP BICS: Get Rs Data",
				"Calls": 1,
				"Time": 0.564574
			}, {
				"Description": "ABAP BICS: Render Result Set",
				"Calls": 1,
				"Time": 0.140034
			}, {
				"Description": "Execution",
				"Calls": 1,
				"Time": 0.730203
			}, {
				"Description": "InA: Geocluster Render Columns",
				"Calls": 1,
				"Time": 0.000112
			}, {
				"Description": "InA: Geocluster Render Data Cells",
				"Calls": 1,
				"Time": 0.000037
			}, {
				"Description": "InA: Geocluster Render Rows",
				"Calls": 1,
				"Time": 0.001802
			}, {
				"Description": "InA: Geographic Clustering",
				"Calls": 1,
				"Time": 0.13744
			}, {
				"Description": "JSON Parser",
				"Calls": 1,
				"Time": 0.003862
			}, {
				"Description": "Prepare",
				"Calls": 1,
				"Time": 0.576205
			}, {
				"Description": "RSBOLAP: GetResultSet",
				"Calls": 1,
				"Time": 0.564474
			}, {
				"Description": "RSBOLAP: OLAP Accesses",
				"Calls": 4,
				"Time": 0.304499
			}
		]
	}
}
  • No labels