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

Introduction

Thresholds in SAP Analytics Cloud are used to measure performance and indicate when an action may need to be taken. They also provide context when sharing reports. Using this information, you can dive deeper into your data to determine potential causes and solutions of high and low performing areas of your business.

You can define threshold values (also known as exceptions in the BW world) for a query in the BEx Query Designer, BW Modeling Tools, as well is SAP Analytics Cloud. However only Thresholds created in SAC are evaluated, the ones defined on the BW side are turned off as it is mentioned in the SAC BW Live Connectivity Support Matrix.

Threshold defined in SACBW Exception modeled in the BW Modeling Tools

Unlike as it is shown in the picture, in the BW Modeling Tools,
three Exceptions have been created, in order to achieve the same result as in SAC.

INA Protocol

  • Exceptions defined in the BW Modeling tools are available in the BW INA Metadata Response, however those are set to Active: false (Analytics.Definition.Exceptions.Active) in the ResultSet Request.
  • The scaling factor is ignored during the evaluation of exceptions.
  • The exception shall always apply to the value visible in the UI. This is because of the following example: the user defines an exception keyfigure <= 100 the decimal places are 2, so the value on the UI is 100,00 the actual value is 100,0003 or similar. If the exception is evaluated on the maximum precision only, this value would not be marked by the exception this behavior is not understandable by the user.

ResultSet Request

The array of Exceptions is a child of the Definition object (Analytics.Definition.Exceptions). The technical name is generated on the fly (Analytics.Definition.Exceptions.Name).

In general, the Exception is defined on a data cell, i.e. the crossing point of a measure coordinate and (in case of a 2-structure query) a member of the second structure. The coordinates of the crossing point are contained in the StructureContext node. (Analytics.Definition.Exceptions[i].StructureContext). StructureContext contains a member of the keyfigure structure "KT Key Figure structure" (UID 4VGQIK77R2ZT6FS7SRFV85N3T) and in the case of a 2-structure query, a member of the second structure. Accordingly, the element contains the fieldnames MemberName and DimensionName.

EvaluateDefault: "All" (Analytics.Definition.Exceptions.EvaluateDefault) means, that if the threshold(s) of an Exception object shall be evaluated on values of Keyfigure A, but the Exception shall change the appearance (alert level) of all Datacells of the structure,  a boolean field Exceptions[i].StructureContext[j].EvaluateDefault is set to true.

EvaluateOn (Analytics.Definition.Exceptions.EvaluateOn) node contains the list of members (both Measure structure selections and Dimension members), which defines the Cell restrictions, where the Exception can be applied on. In our case, it contains the Measure structure selection "GA_SAL"' (UID 4VGQIK77R2ZT6FS7SRFV8662H ) from Measure structure "KT Key Figure structure" (UID 4VGQIK77R2ZT6FS7SRFV85N3T), on the top of the dimension members which are defined as a Filter for the the Threshold in SAC. Filters of Thresholds in SAC stands for Cell Restriction in the BW Modeling Tools.

Threshold node (Analytics.Definition.Exceptions.Threshold) contains the list of threshold values, intervals that we would like to highlight. By having a closer look, one can see additional "helper" threshold(s) that are just indirectly defined by the user. For example as it can be seen in the table below in our case as well.

  • Operator BETWEEN means that all the values between High and Low, as well as the High and Low value itself
  • Operator BETWEEN_EXCLUDING means everything between High and Low, besides the High and Low value itself

In order to avoid some potential processing problems, it is needed to make sure that the threshold values are not overlapped. So as an example 3256.48 is included in the OK threshold >= 3256.48 ; <=8516.37, therefore BETWEEN_EXCLUDING used as an operator for WARNING >= 0 ; < 3256.48 threshold to make sure that 3256.48 is not included here as well. At the same time this puts 0 outside of the WARNING threshold too, hence we have the "helper" threshold BETWEEN High: 0, Low: 0. Same stands for BETWEEN High: -9000, Low: -9000, that is needed because of BETWEEN_EXCLUDING High: 0, Low: -9000.

BW cannot handle operator BETWEEN_EXCLUDING, so it is converted to BETWEEN. In order to make sure that result is the same as it would with BETWEEN_EXCLUDING, High and Low values are set to high_exclude and low_exclude. In our example we do not have booked data that is exactly 0, or -9000, so the "helper thresholds" are not needed to be applied.

AlertLevel (Analytics.Definition.Exceptions.Threshold.AlertLevel) is always 1, regardless whether the user sets OK, WARNING, or Critical, the coloring is assigned by the client, once the Exceptions are set by the server to the data cell(s).

Threshold(s) defined in SACThreshold(s) in the ResultSet RequestThreshold(s) converted in BW

OK >= 3256.48 ; <=8516.37
Warning >= 0 ; < 3256.48
Critical >= -9000 ; < 0

BETWEEN High: 8516.37, Low: 3256.48
BETWEEN High: 0, Low: 0
BETWEEN_EXCLUDING High: 3256.48, Low: 0
BETWEEN High: -9000, Low: -9000
BETWEEN_EXCLUDING High: 0, Low: -9000

BETWEEN High: 8516.37, Low: 3256.48
BETWEEN High_Exclude: 3256.48, Low_Exclude: 0
BETWEEN High: 0, Low: 0
BETWEEN High: -9000, Low: -9000
BETWEEN High_Exclude: 0, Low_Exclude: -9000

Exception ResultSet Request
{
  "Analytics": {
    "Capabilities": [
      "AttributeHierarchy",
      "AttributeHierarchyHierarchyFields",
      "CartesianFilterIntersect",
      "CatalogServiceV20",
      "ClientCapabilities",
      "ClientInfo",
      "ComplexTupleFilter",
      "Conditions",
      "CubeBlending",
      "CubeBlendingPersistanceType",
      "CustomMeasureSortOrder",
      "CustomMemberKeySortOrder",
      "DatasourceAtService",
      "DefinitionReturnsVariableValues",
      "DetailedResponseExpansion",
      "DimF4SelectionWithCompoundment",
      "DimensionHierarchyLevels",
      "DynamicRestrictionOnFormula",
      "ExceptionAggregationDimsAndFormulas",
      "Exceptions",
      "ExceptionsV2",
      "ExpandHierarchyBottomUp",
      "ExtHierarchy",
      "ExtendedDimensionTypes",
      "ExtendedVariableDefinition",
      "F4FilterForTextField",
      "FastPath",
      "HierarchyLevelOffsetFilter",
      "HierarchyNameVariable",
      "HierarchyNavigationCounter",
      "INACurrentMember",
      "InitialDrillLevelRelative",
      "MDMHierarchyDrillLevel",
      "MDSLikePaging",
      "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",
      "VariableMasking",
      "VariableReSubmit",
      "ZeroSuppression"
    ],
    "DataSource": {
      "InstanceId": "9b7c30a3-5daf-1b4d-8a4e-710b7f40b37c",
      "ObjectName": "GA_QUERY29",
      "Type": "Query"
    },
    "Definition": {
      "Dimensions": [
        {
          "Attributes": [
            {
              "Name": "GA_EMP3.KEY",
              "Obtainability": "Always"
            },
            {
              "Name": "GA_EMP3.SHORT_TEXT",
              "Obtainability": "Always"
            },
            {
              "Name": "GA_EMP3.DISPLAY_KEY",
              "Obtainability": "Always"
            }
          ],
          "Axis": "Rows",
          "IsCummulative": false,
          "Name": "GA_EMP3",
          "NonEmpty": false,
          "ReadMode": "BookedAndSpaceAndState",
          "ResultSetReadMode": "BookedAndSpaceAndState",
          "ResultStructure": [
            {
              "Result": "Members",
              "Visibility": "Visible"
            },
            {
              "Result": "Total",
              "Visibility": "Visible"
            }
          ]
        },
        {
          "Attributes": [
            {
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.LONG_TEXT",
              "Obtainability": "Always"
            },
            {
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY",
              "Obtainability": "UserInterface"
            }
          ],
          "Axis": "Columns",
          "Members": [
            {
              "MemberOperand": {
                "AttributeName": "Measures",
                "Comparison": "=",
                "Value": "4VGQIK77R2ZT6FS7SRFV8662H"
              },
              "Visibility": "Visible"
            }
          ],
          "Name": "4VGQIK77R2ZT6FS7SRFV85N3T",
          "NonEmpty": true,
          "ReadMode": "Booked",
          "ResultSetReadMode": "Booked"
        }
      ],
      "Exceptions": [
        {
          "Active": true,
          "EvaluateDefault": "All",
          "EvaluateOn": [
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "4VGQIK77R2ZT6FS7SRFV8662H",
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP4",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP5",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP7",
              "Name": "GA_EMP3.KEY"
            }
          ],
          "Name": "85111706-9172-4654-9791-880697804362:0",
          "StructureContext": [
            {
              "DimensionName": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "MemberName": "4VGQIK77R2ZT6FS7SRFV8662H"
            }
          ],
          "Text": "85111706-9172-4654-9791-880697804362",
          "Threshold": [
            {
              "AlertLevel": 1,
              "Comparison": "BETWEEN",
              "High": 8516.37,
              "Low": 3256.48
            }
          ]
        },
        {
          "Active": true,
          "EvaluateDefault": "All",
          "EvaluateOn": [
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "4VGQIK77R2ZT6FS7SRFV8662H",
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP4",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP5",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP7",
              "Name": "GA_EMP3.KEY"
            }
          ],
          "Name": "85111706-9172-4654-9791-880697804362:1A",
          "StructureContext": [
            {
              "DimensionName": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "MemberName": "4VGQIK77R2ZT6FS7SRFV8662H"
            }
          ],
          "Text": "85111706-9172-4654-9791-880697804362",
          "Threshold": [
            {
              "AlertLevel": 1,
              "Comparison": "BETWEEN",
              "High": 0,
              "Low": 0
            }
          ]
        },
        {
          "Active": true,
          "EvaluateDefault": "All",
          "EvaluateOn": [
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "4VGQIK77R2ZT6FS7SRFV8662H",
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP4",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP5",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP7",
              "Name": "GA_EMP3.KEY"
            }
          ],
          "Name": "85111706-9172-4654-9791-880697804362:1B",
          "StructureContext": [
            {
              "DimensionName": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "MemberName": "4VGQIK77R2ZT6FS7SRFV8662H"
            }
          ],
          "Text": "85111706-9172-4654-9791-880697804362",
          "Threshold": [
            {
              "AlertLevel": 1,
              "Comparison": "BETWEEN_EXCLUDING",
              "High": 3256.48,
              "Low": 0
            }
          ]
        },
        {
          "Active": true,
          "EvaluateDefault": "All",
          "EvaluateOn": [
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "4VGQIK77R2ZT6FS7SRFV8662H",
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP4",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP5",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP7",
              "Name": "GA_EMP3.KEY"
            }
          ],
          "Name": "85111706-9172-4654-9791-880697804362:2A",
          "StructureContext": [
            {
              "DimensionName": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "MemberName": "4VGQIK77R2ZT6FS7SRFV8662H"
            }
          ],
          "Text": "85111706-9172-4654-9791-880697804362",
          "Threshold": [
            {
              "AlertLevel": 1,
              "Comparison": "BETWEEN",
              "High": -9000,
              "Low": -9000
            }
          ]
        },
        {
          "Active": true,
          "EvaluateDefault": "All",
          "EvaluateOn": [
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "4VGQIK77R2ZT6FS7SRFV8662H",
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP4",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP5",
              "Name": "GA_EMP3.KEY"
            },
            {
              "Comparison": "=",
              "Evaluate": "All",
              "Low": "EMP7",
              "Name": "GA_EMP3.KEY"
            }
          ],
          "Name": "85111706-9172-4654-9791-880697804362:2B",
          "StructureContext": [
            {
              "DimensionName": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "MemberName": "4VGQIK77R2ZT6FS7SRFV8662H"
            }
          ],
          "Text": "85111706-9172-4654-9791-880697804362",
          "Threshold": [
            {
              "AlertLevel": 1,
              "Comparison": "BETWEEN_EXCLUDING",
              "High": 0,
              "Low": -9000
            }
          ]
        }
      ],
      "Filter": {
        "Selection": {
          "Operator": {
            "Code": "And",
            "SubSelections": [
              {
                "SetOperand": {
                  "Elements": [
                    {
                      "Comparison": "=",
                      "Low": "4VGQIK77R2ZT6FS7SRFV8662H"
                    }
                  ],
                  "FieldName": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY"
                }
              }
            ]
          }
        }
      },
      "Name": "GA_ADSO21",
      "Query": {
        "Axes": [
          {
            "Axis": "Columns",
            "ResultAlignment": "Bottom",
            "Type": 2,
            "ZeroSuppressionType": 0
          },
          {
            "Axis": "Rows",
            "ResultAlignment": "Bottom",
            "Type": 1,
            "ZeroSuppressionType": 0
          }
        ]
      },
      "QueryDataCells": [
        {
          "CellValueType": 5,
          "Cumulation": false,
          "Decimals": 2,
          "DimensionMemberReferences": [
            "4VGQIK77R2ZT6FS7SRFV8662H"
          ],
          "DisaggregationMode": "None",
          "DisaggregationReferenceCellName": "0",
          "Emphasized": false,
          "Name": "1",
          "ScalingFactor": 0,
          "SignReversal": false
        }
      ],
      "ResultSetFeatureRequest": {
        "ResultEncoding": "None",
        "ResultFormat": "Version2",
        "ResultKeepOriginalTexts": false,
        "SubSetDescription": {
          "ColumnFrom": 0,
          "ColumnTo": -1,
          "RowFrom": 0,
          "RowTo": 10000
        },
        "UseDefaultAttributeKey": false
      },
      "Sort": [
        {
          "Dimension": "GA_EMP3",
          "Direction": "Asc",
          "SortType": "MemberKey"
        }
      ],
      "UniversalDisplayHierarchies": [
        {
          "Active": false,
          "DimensionNames": [
            "4VGQIK77R2ZT6FS7SRFV85N3T"
          ],
          "InitialDrillLevel": 0,
          "LowerLevelNodeAlignment": "Default",
          "Name": "1DG_1"
        },
        {
          "Active": false,
          "DimensionNames": [
            "GA_EMP3"
          ],
          "InitialDrillLevel": 0,
          "LowerLevelNodeAlignment": "Default",
          "Name": "1DG_2"
        }
      ]
    },
    "Language": "EN"
  },
  "ClientInfo": {},
  "Options": [
    "StatefulServer"
  ]
}

ResultSet Response

The Exceptions are applied on the data cell(s) during the ResultSet rendering. The Exceptions that are applied on the data cells, can be found in the ResultSet response in node ExceptionName (Grids.Cells.ExceptionName). It is possible to find out out that which Exception applied on which value, by comparing the values array of ExceptionName (ExceptionName(s) can be looked up from the ResultSet request Analytics.Definition.Exceptions.Name) to for example the values array of ValuesFormatted node (Grids.Cells.ValuesFormatted).

As it has been described, AlertLevel (Grids.Cells.ExceptionAlertLevel) is always 1, it is assigned to actual colors on the client side after the ResultSet response. 

Grids.Cells.ExceptionName.ValuesGrids.Cells.ValuesFormatted.ValuesGrids.Cells.ExceptionAlertLevel.Values
0: "85111706-9172-4654-9791-880697804362:0"
1: "85111706-9172-4654-9791-880697804362:1B"
2: ""
3: "85111706-9172-4654-9791-880697804362:2B"
4: ""
5: ""
0: "8.516,37"
1: "2.870,13"
2: "3.256,48"
3: "-8.722,57"
4: "5.681,91"
5: "11.602,32"
0: 1
1: 1
2: 0
3: 1
4: 0
5: 0
Exception ResultSet Response
{
  "Grids": [
    {
      "DataSource": {
        "ObjectName": "GA_QUERY29",
        "Type": "Query",
        "Description": "GA_QUERY29 Exceptions",
        "InstanceId": "9b7c30a3-5daf-1b4d-8a4e-710b7f40b37c",
        "DataArea": "DEFAULT",
        "DataLastRefresh": "20201102125219",
        "DataRollupMin": "20200829083203",
        "DataRollupMax": "20200829083203",
        "InstanceHandle": "0022"
      },
      "Axes": [
        {
          "Name": "ROWS",
          "Type": "Rows",
          "Dimensions": [
            {
              "Name": "GA_EMP3",
              "Description": "GA_EMP3 Employee3",
              "Attributes": [
                {
                  "Name": "GA_EMP3.KEY",
                  "Description": "Internal Key",
                  "IsKey": true,
                  "Obtainability": "Always",
                  "Values": [
                    "EMP4",
                    "EMP5",
                    "EMP6",
                    "EMP7",
                    "EMP8",
                    "SUMME"
                  ]
                },
                {
                  "Name": "GA_EMP3.SHORT_TEXT",
                  "Description": "Short Text",
                  "IsKey": false,
                  "Obtainability": "Always",
                  "Values": [
                    "EMPLOYEE4",
                    "EMPLOYEE5",
                    "EMPLOYEE6",
                    "EMPLOYEE7",
                    "EMPLOYEE8",
                    "Overall Result"
                  ]
                },
                {
                  "Name": "GA_EMP3.DISPLAY_KEY",
                  "Description": "External Key",
                  "IsKey": false,
                  "Obtainability": "Always",
                  "Values": [
                    "EMP4",
                    "EMP5",
                    "EMP6",
                    "EMP7",
                    "EMP8",
                    "SUMME"
                  ]
                }
              ],
              "MemberTypes": {
                "Encoding": "None",
                "Size": 6,
                "Values": [
                  0,
                  0,
                  0,
                  0,
                  0,
                  1
                ]
              }
            }
          ],
          "TupleCount": 6,
          "TupleCountTotal": 6,
          "ExceptionAlertLevel": {
            "Encoding": "",
            "Size": 6,
            "Values": [
              0,
              0,
              0,
              0,
              0,
              0
            ]
          },
          "ExceptionName": {
            "Encoding": "",
            "Size": 6,
            "Values": [
              "",
              "",
              "",
              "",
              "",
              ""
            ]
          },
          "Tuples": [
            {
              "MemberIndexes": {
                "Encoding": "None",
                "Size": 6,
                "Values": [
                  0,
                  1,
                  2,
                  3,
                  4,
                  5
                ]
              },
              "ParentIndexes": {
                "Encoding": "None",
                "Size": 6,
                "Values": [
                  -1,
                  -1,
                  -1,
                  -1,
                  -1,
                  -1
                ]
              },
              "DisplayLevel": {
                "Encoding": "None",
                "Size": 6,
                "Values": [
                  0,
                  0,
                  0,
                  0,
                  0,
                  0
                ]
              },
              "Level": {
                "Encoding": "None",
                "Size": 0,
                "Values": []
              },
              "DrillState": {
                "Encoding": "None",
                "Size": 6,
                "Values": [
                  0,
                  0,
                  0,
                  0,
                  0,
                  0
                ]
              }
            }
          ]
        },
        {
          "Name": "COLUMNS",
          "Type": "Columns",
          "Dimensions": [
            {
              "Name": "4VGQIK77R2ZT6FS7SRFV85N3T",
              "Description": "KT Key Figure structure",
              "Attributes": [
                {
                  "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.LONG_TEXT",
                  "Description": "Long Text",
                  "IsKey": false,
                  "Obtainability": "Always",
                  "Values": [
                    "GA_SAL Salary"
                  ]
                },
                {
                  "Name": "4VGQIK77R2ZT6FS7SRFV85N3T.KEY",
                  "Description": "Internal Key",
                  "IsKey": true,
                  "Obtainability": "UserInterface",
                  "Values": [
                    "4VGQIK77R2ZT6FS7SRFV8662H"
                  ]
                }
              ],
              "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
                ]
              },
              "DrillState": {
                "Encoding": "None",
                "Size": 1,
                "Values": [
                  0
                ]
              }
            }
          ]
        }
      ],
      "Units": [
        {
          "Type": [
            "CUR"
          ],
          "Value": [
            "EUR"
          ],
          "Description": [
            "EUR"
          ],
          "Exp": [
            1
          ]
        }
      ],
      "Cells": {
        "Exceptions": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "LockedValue": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "InputEnabled": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "ExceptionAlertLevel": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            1,
            1,
            0,
            1,
            0,
            0
          ]
        },
        "ExceptionName": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "85111706-9172-4654-9791-880697804362:0",
            "85111706-9172-4654-9791-880697804362:1B",
            "",
            "85111706-9172-4654-9791-880697804362:2B",
            "",
            ""
          ]
        },
        "Values": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            8516.37,
            2870.13,
            3256.48,
            -8722.57,
            5681.91,
            11602.32
          ]
        },
        "ValuesFormatted": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "8.516,37",
            "2.870,13",
            "3.256,48",
            "-8.722,57",
            "5.681,91",
            "11.602,32"
          ]
        },
        "ValuesRounded": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "8516.37",
            "2870.13",
            "3256.48",
            "-8722.57",
            "5681.91",
            "11602.32"
          ]
        },
        "QueryDataCellReferences": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "1",
            "1",
            "1",
            "1",
            "1",
            "1"
          ]
        },
        "CellValueTypes": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "Units": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "EUR",
            "EUR",
            "EUR",
            "EUR",
            "EUR",
            "EUR"
          ]
        },
        "UnitDescriptions": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "EUR",
            "EUR",
            "EUR",
            "EUR",
            "EUR",
            "EUR"
          ]
        },
        "UnitTypes": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            1,
            1,
            1,
            1,
            1,
            1
          ]
        },
        "UnitPositions": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            1,
            1,
            1,
            1,
            1,
            1
          ]
        },
        "UnitIndex": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "NumericRounding": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            2,
            2,
            2,
            2,
            2,
            2
          ]
        },
        "NumericShift": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            0,
            0,
            0,
            0,
            0,
            0
          ]
        },
        "CellFormat": {
          "Encoding": "None",
          "Size": 6,
          "Values": [
            "#.##0,00",
            "#.##0,00",
            "#.##0,00",
            "#.##0,00",
            "#.##0,00",
            "#.##0,00"
          ]
        }
      },
      "CellArraySizes": [
        6,
        1
      ],
      "DataEntryMask": {
        "NumberofInputEnabledCells": 0,
        "QueryCellNames": []
      }
    }
  ],
  "DataAreas": [
    {
      "Name": "DEFAULT",
      "Environment": "",
      "Model": "",
      "CellLocking": "",
      "IsWorkStatusActive": false,
      "HasChangedData": false,
      "ChangeCounter": 0
    }
  ],
  "Messages": [],
  "PerformanceData": {
    "SessionId": "4VGQIK77R2ZUZTBHX4DORPDL3",
    "StepId": "4VGQIK77R2ZUZTBHXU1INMWAW",
    "Runtime": 0.107368,
    "Timestamp": "2020-11-02 12:52:19.457720",
    "Measurements": [
      {
        "Description": "ABAP BICS: Get Rs Data",
        "Calls": 1,
        "Time": 0.039122
      },
      {
        "Description": "ABAP BICS: Render Result Set",
        "Calls": 1,
        "Time": 0.003469
      },
      {
        "Description": "InA: Create Members Table",
        "Calls": 1,
        "Time": 0.000331
      },
      {
        "Description": "InA: Render Columns Axis",
        "Calls": 1,
        "Time": 0.000138
      },
      {
        "Description": "InA: Render Data Cells",
        "Calls": 1,
        "Time": 0.000695
      },
      {
        "Description": "InA: Render Rows Axis",
        "Calls": 1,
        "Time": 0.00028
      },
      {
        "Description": "InA: Transform Axis Objects",
        "Calls": 1,
        "Time": 0.001193
      },
      {
        "Description": "InA: Transform Texts",
        "Calls": 1,
        "Time": 0.000486
      },
      {
        "Description": "RSBOLAP: GetResultSet",
        "Calls": 1,
        "Time": 0.039059
      },
      {
        "Description": "RSBOLAP: OLAP Accesses",
        "Calls": 4,
        "Time": 0.022595
      }
    ]
  }
}

Examples

In order to check how Decimal Places and Rounding could effect the evaluation of Threshold values, please check Example I., Example II. and Example III.

Important NOTEs

It is very important to follow Note 2541557-SAP Analytics Cloud with BW live connection below NW BW 7.50 SP16, BW/4 2.0 SP4 or S/4 1909 and run the attached report to implement the notes in the sequence from top to down. It is needed to make sure that all the NOTES are implemented and also the manual implementation steps are performed. This is the safest way to implement also the NOTEs stated below.

  • No labels