SAP Analytics Cloud
Page tree
Skip to end of metadata
Go to start of metadata

General Idea

This feature enables the customer to see the part of a compounded key that makes sense in the current query context - the filter on the compounding parent. For example a region is not uniquely identifiable without the country. If there is no filter set on the country we always show the compounded key.  But if we now restrict a widget to a single country we can show the un-compounded key. This restriction can happen via story filter, page filter or widget filter. Instead of the DISPLAY_KEY (external key) we are now showing the DISPLAY_KEY_MIXED (mixed key). The BW backend then decided what part of the compounded dimension should be shown. 

Only the key display of the member values is changed but not the description fields. This means that there is a difference only if the widget shows the key for a dimension. 

Enablement

  • From the Client of view, Enable un-compounded display keys option need to be turned ON, as per the the official documentation.
    It is possible in In SAP Analytics Cloud, select System Administration → Enable un-compounded display keys.

    The Story is also needed to be converted into Optimized View Mode (OVM) and Optimized Design Mode (ODM) as per the the official documentation

  • On the backend side, the following two NOTE needs to be implemented:
    3159902-InA: Support Mixed Display Key

    By having the Story saved into Optimized View and Optimized Design Mode on the Client side, SAC requests Capability MixedDisplayKey in the SAC INA Metadata request from the BW server as a handshake to know, whether the feature is also enabled on the backend side or not.
    In BW INA GetServerInfo response BW also sends Capability MixedDisplayKey, in order to let the client know that BW backend supports the feature.

Analysis

In BW the compounding display is not determined by the resulting data, but by semantic Filter / Context definition. The scenarios below assume, that we stick to this approach. 

The following example presents Dimension GA_CITY (City BP) which is compounded with GA_CNTRY (Country HU). There two ways to achieve un-compounded display, so basically to only display the City, without the Country:

  • Restrict the compounded parent (GA_CNTRY) to a single value in the filter of the query.
Compounded Display, Filter on GA_CITY = HUUn-Compounded Display, Filter on GA_CNTRY = HU

  • Add both characteristics GA_CITY  and GA_CNTRY in compounding order into the drill down of the query
GA_CITY before GA_CNTRYGA_CNTRY before GA_CITY

INA protocol

SAC INA ResultSet Request

If the feature is enabled instead of the DISPLAY_KEY (external key), DISPLAY_KEY_MIXED (mixed key) (Analytics.Definition.Dimensions.Attributes) is requested. 

SAC INA ResultSet Request 
"Dimensions": [{
                    "Attributes": [{
                            "Name": "GA_CITYKT.QUERY_TEXT",
                            "Obtainability": "Always"
                        }, {
                            "Name": "GA_CITYKT.DISPLAY_KEY_MIXED",
                            "Obtainability": "Always"
                        }, {
                            "Name": "GA_CITYKT.KEY",
                            "Obtainability": "UserInterface"
                        }
                    ],
                    "Axis": "Rows",
                    "IsCummulative": false,
                    "Name": "GA_CITYKT",
                    "NonEmpty": false,
                    "ReadMode": "BookedAndSpaceAndState",
                    "ResultSetReadMode": "BookedAndSpaceAndState",
                    "ResultStructure": [{
                            "Result": "Total",
                            "Visibility": "Visible"
                        }, {
                            "Result": "Members",
                            "Visibility": "Visible"
                        }
                    ]
                }]

SAC INA ResultSet Response

The BW backend then decided what part of the compounded dimension should be shown. It is delivered in the BW INA ResultSet response for the DISPLAY_KEY_MIXED array (Grids.Axes.Dimensions.Attributes).

BW INA ResultSet Response 
"Axes": [{
                    "Name": "ROWS",
                    "Type": "Rows",
                    "Dimensions": [{
                            "Name": "GA_CITYKT",
                            "Description": "GA City KT",
                            "DimensionType": 3,
                            "Attributes": [{
                                    "Name": "GA_CITYKT.SHORT_TEXT",
                                    "Description": "Short Text",
                                    "IsKey": false,
                                    "PresentationType": "ShortText",
                                    "Obtainability": "Always",
                                    "ValueType": "String",
                                    "Values": ["Overall Result", "Budapest"]
                                }, {
                                    "Name": "GA_CITYKT.DISPLAY_KEY_MIXED",
                                    "Description": "External Key Mixed",
                                    "IsKey": false,
                                    "PresentationType": "DisplayKeyMixedCompoundment",
                                    "Obtainability": "Always",
                                    "ValueType": "String",
                                    "Values": ["SUMME", "BP"]
                                }, {
                                    "Name": "GA_CITYKT.KEY",
                                    "Description": "Internal Key",
                                    "IsKey": true,
                                    "PresentationType": "Key",
                                    "Obtainability": "UserInterface",
                                    "ValueType": "String",
                                    "Values": ["SUMME", "HU   BP"]
                                }, {
                                    "Name": "GA_CITYKT.KEY_NOT_COMPOUND",
                                    "Description": "Internal Key Non-Concatenated",
                                    "IsKey": false,
                                    "PresentationType": "KeyNotCompound",
                                    "Obtainability": "Service",
                                    "ValueType": "String",
                                    "Values": ["SUMME", "BP"]
                                }
                            ],
                            "MemberTypes": {
                                "Encoding": "None",
                                "Size": 2,
                                "Values": [1, 0]
                            }
                    ]}]




  • No labels