- Created by Attila Giesz, last modified on May 22, 2022
The lengthy JSON strings on the page are recommended to be copied out to a notepad++ with JSONViewer plugin to make it more readable.
General Idea
In the Choropleth layer, a region is geographically assigned to every characteristic value (0LONGITUDE, 0LATITUDE) at every regional level (federal state for example). The Choropleth layer does not display the geographical locations of the geographical characteristic but the regions of the globe (countries, federal states and so on). The key figure of the region is aggregated using the geographically assigned characteristic values. The regions are therefore a navigation attribute of the geo-characteristic.
In SAP BW∕4HANA and >=750 SP16 systems you have to import the regional data via a SAP HANA delivery unit. In such systems these regions are represented by the BI Content characteristic 0GEOFEATID. All regions are sorted in the BW hierarchy SAPBWWORLDHIERARCHY (California is thus inserted as a child of USA). Characteristic 0GEOFEATID is added to the geo-characteristic as a navigation attribute.
Attribute 0GEOFEATID is filled with the region that contains the characteristic value geographically and is situated at the lowest position of all regions in the hierarchy. The association in higher regional levels is then created by the hierarchy at runtime.
For example The region BEVERLY HILLS is assigned to a customer geographically. The assignment provides the assignment at higher levels: Beverly Hills - Los Angeles - California - United States.
At runtime, SAP Analytics Cloud queries the regions as navigation attribute 0GEOFEATID of the geographical characteristic (with active hierarchy SAPBWWORLDHIERARCHY).
Derivation of BW Worldshape Hierarchy (SAPBWWORLDHIERARCHY)
SAPBWWORLDHIERARCHY is built, based on the SAP HANA Region Hierarchy, which is needed to be deployed by a HANA Delivery Unit as per NOTE 2395407 - Spatial Delivery Units for SAP Analytics Cloud
To be able to do it, ABAP program RSD_GEO_SYNC_HIER is needed to be executed. It first check the actual existence of the View in the HANA DB of the BW System.
Checking the existence of View FPA_SPATIAL_DATA.choropleth/CHOROPLETH
SELECT 1 FROM "PUBLIC"."VIEWS" WHERE "SCHEMA_NAME" = '_SYS_BIC' AND "VIEW_NAME" = 'FPA_SPATIAL_DATA.choropleth/CHOROPLETH'
After words the View is being read. It reads the LEVEL, PARENT_AREA_ID, AREA_ID and FEATURE_ID.
Reading of View FPA_SPATIAL_DATA.choropleth/CHOROPLETH
SELECT "LEVEL","PARENT_AREA_ID","AREA_ID","FEATURE_ID" FROM "_SYS_BIC"."FPA_SPATIAL_DATA.choropleth/CHOROPLETH"
At the end the program recursively creates and deploy SAPBWWORLDHIERARCHY, based on View "FPA_SPATIAL_DATA.choropleth/CHOROPLETH", for InfoObject 0GEOFEATID.
Derivation of 0GEOFEATID
750 Systems
0GEOFEATID is needed to filled with the FEATURE_IDs from View "FPA_SPATIAL_DATA.choropleth/CHOROPLETH". In 750 Systems it can be done by running ABAP program RSD_GEO_SYNC_ATTR. The idea is to take the regions that are geographically intersected with the geographic location of the corresponding characteristic value.
The following example fills the FEATURE_IDs for geographic characteristic GA_GEO8.
At first the existence of the View in the HANA DB of the BW System is checked.
Checking the existence of View FPA_SPATIAL_DATA.choropleth/CHOROPLETH
SELECT 1 FROM "PUBLIC"."VIEWS" WHERE "SCHEMA_NAME" = '_SYS_BIC' AND "VIEW_NAME" = 'FPA_SPATIAL_DATA.choropleth/CHOROPLETH'
SID, FEATURE_ID and LEVEL fields are selected. The Join happens between the SID /BIC/SGA_GEO8 and the master data table /BIC/PGA_GEO8 of the geographic characteristic which is then JOINed with the geographic table /BIC/9GA_GEO8 of the geographic characteristic, that is JOINed with HANA View "_SYS_BIC"."FPA_SPATIAL_DATA.choropleth/CHOROPLETH" where the geographic location can be geographically intersected with the shape data of any region from the HANA View, by using HANA Spatial function ST_INTERSECTS.
Because of the fact that several regions can be found for a single geographic location (for example Los Angeles - California - United States, for a characteristic value with geographic location of Beverly Hills), it is always wanted to select the highest level region from the Hierarchy (United States for example). To be able to do that partitioning is done based on SID and sorted by LEVEL in descending order. Later then the first ROWNUM is selected (highest level in the Hierarchy).
Afterwords Master Data update routine updates the master data table with the found FEATURE_IDs.
Filling of 0GEOFEATID with the found FEATURE_IDs of the Regions
SELECT "/BIC/GA_GEO8","SID" ,"FEATURE_ID" FROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY "SID" ORDER BY "LEVEL" DESC,"FEATURE_ID" ASC)AS "ROWNUM" FROM (SELECT "STAB"."/BIC/GA_GEO8" AS "/BIC/GA_GEO8","STAB"."SID" AS "SID","CHORO"."FEATURE_ID" AS "FEATURE_ID" ,"CHORO"."LEVEL" AS "LEVEL" ,"PTAB"."GEOFEATID" AS "GEOFEATID" FROM "/BIC/SGA_GEO8" AS "STAB" INNER JOIN "/BIC/PGA_GEO8" AS "PTAB" ON "STAB"."/BIC/GA_GEO8"="PTAB"."/BIC/GA_GEO8" INNER JOIN "/BIC/9GA_GEO8" AS "9TAB" ON "STAB"."SID"="9TAB"."SID" INNER JOIN "_SYS_BIC"."FPA_SPATIAL_DATA.choropleth/CHOROPLETH" AS "CHORO" ON "9TAB"."POINT".ST_INTERSECTS("CHORO"."SHAPE")=1 )) WHERE "ROWNUM"=1 AND NOT "FEATURE_ID"="GEOFEATID"
There are cases, when no FEATURE_IDs found, meaning the that there is no region that is geographically intersected with the geographic location of the corresponding characteristic value, for example if the location is in the middle of an Ocean. In these case the master data table is updated with FEATURE_ID 0.
Filling 0GEOFEATID with the not found FEATURE_IDs
SELECT "STAB"."/BIC/GA_GEO8","STAB"."SID" FROM "/BIC/SGA_GEO8" AS "STAB" INNER JOIN "/BIC/PGA_GEO8" AS "PTAB" ON "STAB"."/BIC/GA_GEO8"="PTAB"."/BIC/GA_GEO8" INNER JOIN "/BIC/9GA_GEO8" AS "9TAB" ON "STAB"."SID"="9TAB"."SID" LEFT OUTER JOIN "_SYS_BIC"."FPA_SPATIAL_DATA.choropleth/CHOROPLETH" AS "CHORO" ON "9TAB"."POINT".ST_INTERSECTS("CHORO"."SHAPE")=1 WHERE "CHORO"."SHAPE" IS NULL AND NOT "PTAB"."GEOFEATID"='000000000000000'
Afterwords Master Data update routine updates the master data table with the empty FEATURE_IDs.
BW/4HANA 2.0 Systems
In BW/4HANA 2.0 Systems, transformation formula function BW_GEO_FEATURE_ID can be used to fill 0GEOFEATID from 0LONGITUDE and 0LATITUDE.
INA Protocol
BW INA Metadata Response
For more information, check wiki Simple INA Requests and Responses (SAC - BW Interaction).
- Since GA_GEO8 is having GISTP 2, attribute 1GEOPOINT is returned by the server(Cube.Dimensions.Attributes).
- For Default Choropleth layer, a technical navigation attribute 0GEOFEATID is used.
- It gains GeoLevelAttribute (Cube.Dimensions.GeoLevelAttribute) which 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.
- GA_GEO8__0GEOFEATID also has 1GEOPOINT returned by the server (Cube.Dimensions.GeoPointAttribute)
- GA_GEO8__0GEOFEATID gains 0GSHAPE3857 on the top too (Cube.Dimensions.GeoShapeAttribute).
BW INA Metadata Response Expand source
"Dimensions": [{
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K",
"ID": 2000000908,
"Description": "Key Figures",
"DimensionType": 2,
"AxisDefault": "Columns",
"AxisConstraints": ["Rows", "Columns"],
"DefaultResultSetAttributes": [],
"AttributeHierarchy": {
"AttributeNames": ["4VGQIK77R2ZUW1LR8GWRK3H8K.KEY", "4VGQIK77R2ZUW1LR8GWRK3H8K.DISPLAY_KEY", "4VGQIK77R2ZUW1LR8GWRK3H8K.LONG_TEXT"],
"DefaultKeyAttribute": "4VGQIK77R2ZUW1LR8GWRK3H8K.KEY",
"DefaultDisplayKeyAttribute": "4VGQIK77R2ZUW1LR8GWRK3H8K.DISPLAY_KEY",
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K",
"Description": "Key Figures",
"DefaultResultSetAttributes": ["4VGQIK77R2ZUW1LR8GWRK3H8K.LONG_TEXT"],
"Children": []
},
"DefaultResultSetAttributeNodes": ["4VGQIK77R2ZUW1LR8GWRK3H8K"],
"HierarchyActiveDefault": "false",
"KeyAttribute": "4VGQIK77R2ZUW1LR8GWRK3H8K.KEY",
"SelectorReadMode": "None",
"DefaultSelectorReadMode": "None",
"ResultSetReadMode": "None",
"DefaultResultSetReadMode": "None",
"Attributes": [{
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K.KEY",
"IsKey": true,
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "Key",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "SingleValue"
},
"DataType": "String"
}, {
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K.DISPLAY_KEY",
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "DisplayKey",
"Description": "",
"IsFilterable": false,
"DataType": "String"
}, {
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K.LONG_TEXT",
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "LongText",
"Description": "",
"IsFilterable": false,
"DataType": "String"
}
],
"DefaultResultStructure": {
"ResultAlignment": "",
"ResultStructure": [{
"Result": "Members",
"Visibility": "Visible"
}
]
},
"MultipleValues": true,
"NameExternal": "",
"Length": 0,
"Members": [{
"4VGQIK77R2ZUW1LR8GWRK3H8K.KEY": "4VGQIK77R2ZUW1LR8GWRK524K",
"4VGQIK77R2ZUW1LR8GWRK3H8K.ID": 1,
"4VGQIK77R2ZUW1LR8GWRK3H8K.DISPLAY_KEY": "GA_AMOUNT",
"4VGQIK77R2ZUW1LR8GWRK3H8K.LONG_TEXT": "GA_AMOUNT Amount",
"IsSelectionCandidate": true,
"ResultCalculation": "00",
"SingleValueCalculation": "",
"Digits": 0,
"FractDigits": 0,
"Visibility": "Visible"
}
],
"Hierarchies": [],
"LevelHierarchies": []
}, {
"Name": "GA_EMP3",
"ID": 100403,
"Description": "GA_EMP3 Employee3",
"DimensionType": 3,
"DataType": "CHAR",
"AxisDefault": "Free",
"AxisConstraints": ["Rows", "Columns", "Free"],
"DefaultResultSetAttributes": [],
"HasCheckTable": true,
"SupportsCummulative": true,
"AttributeHierarchy": {
"AttributeNames": ["GA_EMP3.$$HierarchyField$$.KEY", "GA_EMP3.SHORT_TEXT", "GA_EMP3.KEY", "GA_EMP3.DISPLAY_KEY"],
"DefaultKeyAttribute": "GA_EMP3.KEY",
"DefaultTextAttribute": "GA_EMP3.SHORT_TEXT",
"DefaultDisplayKeyAttribute": "GA_EMP3.DISPLAY_KEY",
"Name": "GA_EMP3",
"Description": "GA_EMP3 Employee3",
"HierarchyKeyAttribute": "GA_EMP3.$$HierarchyField$$.KEY",
"HierarchyNavigationAttribute": "GA_EMP3.$$HierarchyField$$.KEY",
"HierarchyTextAttribute": "GA_EMP3.SHORT_TEXT",
"HierarchyDisplayKeyAttribute": "GA_EMP3.DISPLAY_KEY",
"DefaultResultSetAttributes": ["GA_EMP3.DISPLAY_KEY"],
"Children": [{
"AttributeNames": ["GA_EMP3.GA_ID.DISPLAY_KEY", "GA_EMP3.GA_ID.KEY"],
"DefaultKeyAttribute": "GA_EMP3.GA_ID.KEY",
"Name": "GA_EMP3.GA_ID",
"Description": "GA_ID",
"DefaultResultSetAttributes": ["GA_EMP3.GA_ID.DISPLAY_KEY"]
}
]
},
"DefaultResultSetAttributeNodes": ["GA_EMP3"],
"HierarchyActiveDefault": "false",
"TextAttribute": "GA_EMP3.SHORT_TEXT",
"KeyAttribute": "GA_EMP3.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_EMP3.$$HierarchyField$$.KEY",
"IsKey": true,
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "Key",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "SingleValue"
},
"DataType": "String"
}, {
"Name": "GA_EMP3.SHORT_TEXT",
"Length": 20,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "ShortText",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "Range"
},
"DataType": "String"
}, {
"Name": "GA_EMP3.KEY",
"IsKey": true,
"Length": 20,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "Key",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "Range"
},
"DataType": "String"
}, {
"Name": "GA_EMP3.DISPLAY_KEY",
"IsKey": true,
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 1,
"PresentationType": "DisplayKey",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "Range"
},
"DataType": "String"
}, {
"Name": "GA_EMP3.GA_ID.DISPLAY_KEY",
"Length": 5,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "DisplayKey",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "SingleValue"
},
"DataType": "String"
}, {
"Name": "GA_EMP3.GA_ID.KEY",
"Length": 5,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "Key",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "SingleValue"
},
"DataType": "String"
}
],
"DefaultResultStructure": {
"ResultAlignment": "",
"ResultStructure": [{
"Result": "Total",
"Visibility": "Visible"
}, {
"Result": "Members",
"Visibility": "Visible"
}
]
},
"MultipleValues": true,
"NameExternal": "",
"Length": 25,
"Hierarchies": [],
"LevelHierarchies": []
}, {
"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",
"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",
"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",
"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",
"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",
"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",
"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_NAV1 - 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",
"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV11.DISPLAY_KEY",
"Name": "GA_GEO8__GA_NAV11",
"Description": "GA_NAV1 - 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",
"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",
"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_NAV1 - 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",
"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV12.DISPLAY_KEY",
"Name": "GA_GEO8__GA_NAV12",
"Description": "GA_NAV1 - 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",
"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",
"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_NAV1 - GA_NAV12 -",
"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",
"DefaultDisplayKeyAttribute": "GA_GEO8__GA_NAV21.DISPLAY_KEY",
"Name": "GA_GEO8__GA_NAV21",
"Description": "GA_NAV1 - GA_NAV12 -",
"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",
"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",
"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 Custom Shape",
"DimensionType": 3,
"DataType": "CHAR",
"AxisDefault": "Rows",
"AxisConstraints": ["Rows", "Columns", "Free"],
"DefaultResultSetAttributes": [],
"HasCheckTable": true,
"SupportsCummulative": true,
"AttributeHierarchy": {
"AttributeNames": ["GA_GEO8.$$HierarchyField$$.KEY", "GA_GEO8.KEY", "GA_GEO8.DISPLAY_KEY"],
"DefaultKeyAttribute": "GA_GEO8.KEY",
"DefaultDisplayKeyAttribute": "GA_GEO8.DISPLAY_KEY",
"Name": "GA_GEO8",
"Description": "GA_GEO8 Custom Shape",
"HierarchyKeyAttribute": "GA_GEO8.$$HierarchyField$$.KEY",
"HierarchyNavigationAttribute": "GA_GEO8.$$HierarchyField$$.KEY",
"HierarchyDisplayKeyAttribute": "GA_GEO8.DISPLAY_KEY",
"DefaultResultSetAttributes": ["GA_GEO8.DISPLAY_KEY"],
"Children": [{
"AttributeNames": ["GA_GEO8.0ALTITUDE.DISPLAY_KEY", "GA_GEO8.0ALTITUDE.KEY"],
"DefaultKeyAttribute": "GA_GEO8.0ALTITUDE.KEY",
"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",
"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",
"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",
"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",
"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",
"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",
"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",
"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",
"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": "J4B7W5Z7SX2CWBTVAXQ47JFBH",
"Description": "GA_NAV1~GA_NAV12~GA_NAV21Custom Shape",
"Levels": [{
"Level": 1,
"NavAttr": "GA_GEO8__GA_NAV1",
"Description": "GA_NAV1"
}, {
"Level": 2,
"NavAttr": "GA_GEO8__GA_NAV12",
"Description": "GA_NAV12"
}, {
"Level": 3,
"NavAttr": "GA_GEO8__GA_NAV21",
"Description": "GA_NAV21Custom Shape"
}
]
}
],
"SelectorReadMode": "MasterAndSpace",
"DefaultSelectorReadMode": "MasterAndSpace",
"SupportedSelectorReadModes": ["MasterAndSpace", "BookedAndSpace", "BookedAndSpaceAndState"],
"ResultSetReadMode": "BookedAndSpaceAndState",
"DefaultResultSetReadMode": "BookedAndSpaceAndState",
"SupportedResultSetReadModes": ["MasterAndSpace", "BookedAndSpaceAndState"],
"VariableReadMode": "MasterAndSpace",
"DefaultVariableReadMode": "MasterAndSpace",
"SupportedVariableReadModes": ["MasterAndSpace", "BookedAndSpace"],
"HierarchiesPossible": true,
"NumberOfHierarchies": 1,
"Attributes": [{
"Name": "GA_GEO8.$$HierarchyField$$.KEY",
"IsKey": true,
"Length": 0,
"Decimals": 0,
"InitialValue": "",
"SortOrder": 0,
"PresentationType": "Key",
"Description": "",
"IsFilterable": true,
"FilterCapability": {
"ComparisonGroup": "SingleValue"
},
"DataType": "String"
}, {
"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": []
}
]
BW INA ResultSet Request
- In the ResultSet request, Client requests GA_GEO8__0GEOFEATID (Analytics.Definition.Dimensions) in the drilldown with active Hierarchy SAPBWWORLDHIERARCHY (Analytics.Definition.Dimensions.Hierarchy).
- Drilling to a Region is handled via a display filter, called as LevelOffset filter (Analytics.Definition.Filter), for more information about it, check wiki page. The Filter tree contains a SubSelection on the correspondent FEATURE_ID of the Region in Drill, from Hierarchy SAPBWWORLDHIERARCHY of 0GEOFEATID.
BW INA ResultSet Request Expand source
{
"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", "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": "4146e63e-7ead-1bdd-fa6d-8bfd2d6e52c7",
"ObjectName": "GA_QUERY15",
"Type": "Query"
},
"Definition": {
"Dimensions": [{
"Attributes": [{
"Name": "GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY",
"Obtainability": "Always"
}, {
"Name": "GA_GEO8__0GEOFEATID.0GSHAPE3857.KEY",
"Obtainability": "Always",
"TextTransformation": "SpatialAsGeoJSON"
}, {
"Name": "GA_GEO8__0GEOFEATID.DISPLAY_KEY",
"Obtainability": "Always"
}, {
"Name": "GA_GEO8__0GEOFEATID.1GEOPOINT.KEY",
"Obtainability": "Always",
"TextTransformation": "SpatialAsGeoJSON"
}, {
"Name": "GA_GEO8__0GEOFEATID.LONG_TEXT",
"Obtainability": "UserInterface"
}
],
"Axis": "Rows",
"Hierarchy": {
"ExpandBottomUp": false,
"HierarchyActive": true,
"HierarchyName": "SAPBWWORLDHIERARCHY",
"InitialDrillLevel": 0,
"LowerLevelNodeAlignment": "Default",
"MemberOfPostedNodeVisibility": "Visible",
"Name": "SAPBWWORLDHIERARCHY",
"NodeCondensation": false
},
"IsCummulative": false,
"Name": "GA_GEO8__0GEOFEATID",
"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": "4VGQIK77R2ZUW1LR8GWRK524K"
},
"Visibility": "Visible"
}
],
"Name": "4VGQIK77R2ZUW1LR8GWRK3H8K",
"NonEmpty": true,
"ReadMode": "Booked",
"ResultSetReadMode": "Booked"
}
],
"Filter": {
"Selection": {
"Operator": {
"Code": "And",
"SubSelections": [{
"SetOperand": {
"Elements": [{
"Comparison": "=",
"Hierarchy": {
"Name": "SAPBWWORLDHIERARCHY"
},
"LevelOffset": 1,
"Low": "0GEOFEATID!000000000599040"
}
],
"FieldName": "GA_GEO8__0GEOFEATID.$$HierarchyField$$.KEY",
"Hierarchy": {
"Name": "SAPBWWORLDHIERARCHY"
}
}
}
]
}
}
},
"Name": "GA_HCPR9",
"Query": {
"Axes": [{
"Axis": "Columns",
"ResultAlignment": "Bottom",
"Type": 2,
"ZeroSuppressionType": 0
}, {
"Axis": "Rows",
"ResultAlignment": "Bottom",
"Type": 1,
"ZeroSuppressionType": 0
}
]
},
"QueryDataCells": [{
"CellValueType": 6,
"Cumulation": false,
"Decimals": 3,
"DimensionMemberReferences": ["4VGQIK77R2ZUW1LR8GWRK524K"],
"DisaggregationMode": "None",
"DisaggregationReferenceCellName": "0",
"Emphasized": false,
"Name": "1",
"ScalingFactor": 0,
"SignReversal": false
}
],
"ResultSetFeatureRequest": {
"IgnoreAutoSubmit": true,
"MaxResultRecords": 5000000,
"ResultEncoding": "None",
"ResultFormat": "Version2",
"ResultKeepOriginalTexts": false,
"SubSetDescription": {
"ColumnFrom": 0,
"ColumnTo": -1,
"RowFrom": 0,
"RowTo": -1
},
"UseDefaultAttributeKey": false
},
"Sort": [{
"Dimension": "GA_GEO8__0GEOFEATID",
"Direction": "Asc",
"SortType": "Hierarchy"
}
],
"UniversalDisplayHierarchies": [{
"Active": false,
"DimensionNames": ["4VGQIK77R2ZUW1LR8GWRK3H8K"],
"InitialDrillLevel": 0,
"LowerLevelNodeAlignment": "Default",
"Name": "1DG_1"
}, {
"Active": false,
"DimensionNames": ["GA_GEO8__0GEOFEATID"],
"InitialDrillLevel": 0,
"LowerLevelNodeAlignment": "Default",
"Name": "1DG_2"
}
]
},
"Language": "EN"
},
"ClientInfo": {
"Identifier": "AnalyticsCloud"
},
"Options": ["StatefulServer"]
}
- No labels