Comments on BW/BPC live Connections in SAP Analytics Cloud
For all those who are in a hurry, this picture might explain everything:
All those who are interested in a little more information we would like to invite to continue reading to find out the details of this exciting new feature…
In many reporting or planning scenarios the ability to comment on the numbers is a crucial requirement. In SAP Analytics Cloud we offer an established functionality that allows the end user to either comment data directly in a table (data point comments) or as a sort of summary in a so-called comment widget. Unfortunately, this functionality has only been available with SAC acquired models. That means commenting data that is provided via a live connection has not been possible.
With QRC2 2023 we now offer the ability to comment on data that is provided by a BW live connection or a BPC live connection. Here we take advantage of the commenting solution that has been offered in SAP BW/4HANA before. This solution has been extended to SAP BW 7.50 on Hana and is now available in SAC with the BW live connection and the BPC live connection as well. This implies that the comments are managed and stored in the BW/BPC system and created, displayed, edited, or deleted through SAC. No commenting information will be stored in the cloud – a requirement we often hear from customers in the Defense or Banking Industry or in Public Sector.
The comments are also integrated with other BW Front ends – comments that has been created in SAC can also displayed, changed, or deleted in SAP BO Analysis for Microsoft Office and vice versa.
Comments are stored against a selection. We offer three ways of accessing a comment:
- Data point comments: comments are displayed in a table – either via an indicator in the cell or in a separate column. The chosen model, the table structure (row and column selection), and the general filters (query filters, SAC story and page filters) determine the selection for the given data cell and thus the corresponding comment.
- Comment Widget: the comment is displayed in a special widget similar to a text box – a model and one measure have to be selected (in case of a two-structure query also a member of the second structure has to be defined) and further filters can be defined in the widget itself or can be applied via story or page filters. If the selection for a comment widget is the same as for a certain cell in a table, then the same comment is displayed.
- Script API: comments can also be accessed through a java script API.
Comments can be used in pure reporting queries (BW live connection), and also in planning enabled queries (BPC live connection). The necessary license is determined by the connection – when using a BW live connection an SAC reporting license will suffice to comment. When you are using a BPC connection this connection type already requires an SAC planning license to use the connection.
Comments can be entered on various types of cells: cells on lowest level of aggregation in the InfoProvider, but also on cells that consist of aggregations – cell in queries where certain dimension have been removed from the drill, totals and subtotals, hierarchy leaves and nodes, base measures, restricted measures and even calculated measures. In the case of restricted measures, the restriction will be analysed and the comment will be stored on the base measure with the corresponding restriction (but not on the NAME of the restricted measure). In case of calculated measures, the name of the measure will be used as a key.
Please note that if a comment is stored on a total then this total is seen as an own entity – the comment comments this entity and is NOT some ‘aggregation’ of underlying comments.
As indicated above, we started from the existing BW/4HANA commenting solution and extended it. The commenting feature is now available with:
- BW 7.50 on HANA, SP 23
- BW 7.57 on HANA, SP00
- BW/4HANA 2.0 SP07-SP12 with note 3244228 or SP13 and higher
- BW/4HANA 2021 SP00-SP03 with note 3244228 or SP 04 and higher
Please also check notes 3133846, 3169011, 3242613, 3261834 (not all of them might be necessary).
On the SAC side you need QRC2.2023 for a QRC based tenant and wave 4 2023 for fast track tenants.
Configurations in BW/BPC
In order to use the commenting feature, you have to perform some steps in the backend system.
Comments are stored in so-called document stores. A document store is created in the BW Modelling Tools. Upon creation of the document store you specify a BW InfoProvider. The document store will inherit all dimensions from this InfoProvider. The document store can then be used in any BW query that is defined on this InfoProvider. Please note that you can create several document stores for the same InfoProvider.
You can decide for each individual query whether it should use comments or not. In order to use comments, you have to select a BW/BPC query, go to the tab ‘Runtime Properties’ and set the property ‘Document Support’ to ‘Yes’. You should also select a ‘Default Document Store’. In Analysis for Office, it is possible to set or switch the document store at runtime, in SAC this is not yet possible.
If you have two different queries defined on the same InfoProvider and if they use the same document store, then you can see the same comments in both queries. Here it does not matter whether the query is input enabled or not. However, if you want to see different comments in different queries then you can assign different document stores.
As already indicated above calculated measure can also be commented but you must specify a technical name for the measure in the query designer.
Please note that comments are only available on modelled queries in BW/BPC. Comments are NOT available on CDS queries and thus commenting on S/4 live connections is not possible.
There is an authorization object for the document store (S_RS_DOCA). With this authorization object it can be controlled whether a given user can access comments stored in a given document store and whether the user can only read or also create/change/delete such comments.
We do NOT have a selection-based authorization. However, comments can only be viewed by the end user via a query cell. In case of the data point comments the used cell is obvious, but also in the case of the comment widget the system logically uses a query that is restricted to exactly one cell. If a user does not have sufficient Analysis authorizations to access this cell then also the comment cannot be used.
Please note that only the access control in BW is taken into account. Any such setting in SAC will be ignored.
Comment History and User/Time Stamp
In BW for a given selection there is only one comment. This is different from the SAC acquired case where we have a comment thread and might have several single comments in this thread. But each BW comment has a history. Whenever a comment is changed, the previous comment will be kept in the history (which can be regarded as a change log).
A comment can be changed by any user that has the authorization to do so. The username and a time stamp will be kept with every new version of the comment. Thus, it is obvious who has done changes to a given comment.
CORS Settings in BW system
The comment feature use a new INA endpoint (path: /sap/bw/ina/Documents). You have to make sure that either the path /sap/bw/ina (and thus every sub-path) is allowed in CORS or – in case you have explicitly specified the sub-paths – you have to add the new path /sap/bw/ina/Documents.
Use of Comments in SAC
Once you have customized the BW/BPC system you can use the comments in SAC.
Data Point Comments in a Table
If you want to use comments in a data table, you have to enable the comments using the flag ‘Allow Data Point Comments’ for this table in the design panel (just as with comments on acquired models).
Now you can see the comment indicator in all cells that already bear a comment. By clicking on the indicator, you can open the comment.
You can see the comment, the user who has created the comment (please note that this user is the BW/BPC user, not the SAC user) and the time stamp. Now you can either change the comment, delete the comment, or display the history.
Instead of using the comment indicator you can display the comments in a comment column in the table (just as with comments on acquired models).
By clicking on an existing comment, you can open the comment popup that you know already. If you click on an empty comment cell or start typing on any cell you will jump directly to the edit mode of the comment popup.
Just as a reference let us have a look at the comment we have used above in Analysis for Office.
As you can see, we indeed can access the same comment for Austria/Juice that we have already seen above in SAC.
Finally let us have a look at a comment entered on a total. If you look at the lowest line you can see that we have a comment on the total for all product groups for the country Austria. And the comment does not contain any of the comment entered for a specific product group but is an entity on its own. The same is possible with hierarchy nodes.
When you create a new comment widget you will have to specify the model first. The system will detect the available measures in the underlying query. You will have to select one of those measures for your comment widget. If the underlying query has two structures, you also have to restrict the second structure to a single member.
If you want you can add further widget filters.
You can now enter new comments already.
If there has been a comment already for this selection, then you will see the comment with its history.
If you do not want to see the history and/or the comment details (username, time stamp) you can switch them off individually (in customizing as well as at runtime).
Conclusion and Outlook
As described above you now can use commenting also on BW and BPC live connections. There are certain (small) differences compared to the use of comments on acquired models – mainly as we started from the established BW/4HANA solution and want to ensure the compatibility with the use of the comments across the BW platform.
One of the main differences is that currently it is not possible to enter formatted comments or hyperlinks in the BW based comments. But the good news is that we are currently working on closing this gap and hope to deliver this new feature soon. So stay tuned…
Our BW4HANA version is 2020 SP5 is there any sap note we can implement to activate Data point commenting in SAC or we have upgrade the system
for your specific BW (BW/4HANA 2.0) the minimum requirement is SP7. From that SP on you can implement the feature via the above mentioned note. Unfortunately it is not possible to use this note with SP5. So indeed an upgrade would be required. Sorry…
Thank you for this blog post Gerd !
For those starting the implementation process => only Composite Providers and Data Store objects can be used as Info Providers as mentioned here: creating document store.
(Initially I overread that part and was wondering why only CP & aDSOs were presented when choosing Info Provider).