Comments section is the important attribute for Planning and Variance analysis reporting. It helps the users to provide explanation for the variance and helps the users to explain why the value is being entered, it communicates more than the mere number and adds value to the planning and reporting process. This article helps you to understand some basic concepts around how to enable the comments field in BPC embedded and the steps involved in getting it done.
Comments BPC Classic Vs Embedded
Enabling comments in BPC Classic is a very easy exercise which can be done through EPM Functions save/retrieve comment and by enabling the comments in sheet options to view them. In embedded it requires a creation of a separate ADSO (Advanced Data Store Object – Direct Input). Then this must be connected to the Multiprovider along with other cubes for Actual and Planning and aggregation on top of it. The performance of this comments is better than EPM, as the ADSO is part of the OLAP engine whereas in EPM, the comments can be enabled only by having EPM comment function in each cell where the comment is required.
Steps involved for enabling comments in BPC embedded
Step 1: Create an Infoobject
An Infoobject ZCOMMENT2 is created as CHAR data type and of length 250 (maximum allowed)
Step 2: Create an ADSO
Create an ADSO (ZCOMM in the example below) use “Planning in Direct Update” template and apply it. This will make the ADSO as the direct update ADSO.
Add infoobjects for G/L Account, Cost Center and ZCOMMENT2 to the ADSO created and click on the ZCOMMENT infoobject and enable the check box “Use Characteristic as Key Figure”.
Additionally note that you should make all the non-key figure info objects participating in direct-update-ADSO to be Key. This can be done by using the “manage keys” option in the screen above.
Step 3: Add the Comment ADSO to the Composite Provider
Add the comment ADSO to the Composite Provider along with the other cubes/ADSOs.
Map the source infoobjects to the target infoobjects under scenario tab and activate the Composite Provider.
Step 4: Create an Aggregation Level on top of the CompositeProvider
Create an aggregation level on top of the Composite Provider “ZACTPL_CP”
Add InfoProvider fields to the “Output” tab of the Aggregation Level.
Step 5: Create a Query on top of Aggregation Level
Check the check box “Start Query in Input Mode” under General tab.
Map the infocube to the infoobject under selection details under sheet definition tab for “General” Properties.
Select Input-Ready under Planning properties under sheet definition tab for Plan, Amount and Comment Infoobjects.
Select Master Data for G/L Account under Extended category under sheet definition tab.
Step 6: Analysis for Office
Now you should be able to open the query in analysis for Office and save comments from it.
BPC Embedded provides similar functionality as the BPC classic when it comes to this aspect of SAP BPC (Business planning and consolidation). Please contact us for your implementation requirements, support or consulting requirements.