Skip to Content

This document highlights the key benefits available in BPC 10 reporting and details more on the smartness it brings in BPC reporting space.

 

SAP in its latest version for Business Planning and Consolidation has brought in significant changes in two spaces compared to its previous versions. Like in,

  1. System Architecture and
  2. System Reporting

BPC in its earlier versions was matured enough in its reporting and was able to cater most of the business requirement with its EV functions and native Excel functions. It’s not a simple decision to replace a matured reporting tool with a new tool.

Having said that, it is necessary for all BPC consultants to understand the key benefits BPC 10 Reporting is bringing in, compared to what was available in the former versions.

In BPC 10 a user can build Excel reports via three options,

  1. EPM – Report Editor
  2. Drag and Drop Reporting in EPM Pane
  3. Ad Hoc Reporting

  

EPM – Report Editor and Drag and Drop Reporting options are something similar to what we had in previous version of BPC.

Ad Hoc Reporting is the one which draws more attent

ion in BPC 10. This is completely a new feature which is made available for reporting and it benefits all BPC users (Developers and End Users) in performing quick reporting based on their needs.

This approach has two prerequisites,

  1. Enable Member Recognition option in SheetOptions of EPM Tab
  2. Knowledge on the Dimensions and its member ID’s or Descriptions

Pic1.jpg

 

Note:

Member Recognition is specific to a Worksheet and has to be enabled in any worksheet the ad hoc report needs to be built.

 

Building basic Report with Ad Hoc Approach,

To start with this option of building reports,

1. Enter the ID of any dimension member(Here as an example –  Account member) for which the report needs to be built and click enter – This will create a EPMOLAPMEMBER formula for the ID entered

Pic2.jpg
2. Now enter another member ID (Here for example Time member ID) or Description across column this will create a Report with Account in Row and Time in Column.

Pic3.jpg
3. Any Member entered at the top left of the report created will be taken as the Page Axis members as shown in the below figure,

Pic4.jpg

 

Ad-Hoc reporting – Possible Cases:

1. When a Dimension ID is entered in a new Row Axis (Column), it checks if the dimension is duplicated in in the column(Row) axis.

    1. If it is not duplicated the report updates it with the new row axis for the dimension entered
    2. If it is duplicated in column axis, the duplication of the dimension ID will be highlighted as in the error below.

Pic5.jpg

2. When a Dimension ID is entered in the existing axis of a report, it checks for the value with the members of the dimension in the axis,

    1. If the ID entered matches exactly with any member in the dimension, it will be added as a member in the existing report
    2. If the ID entered doesn’t match exactly with the existing members of the dimension, a search will be done automatically based on the value entered, on the dimension available in the report axis

Pic10.jpg

     
3. When a dimension ID of a dimension which exists  in the report  is entered in the same axis(Row/Column), it doesn’t recognize the entry and defaults to the old report structure leaving the ID entered as just a value in the cell

Pic9.jpg

Other Special Reporting Features:

A report layout built using Ad Hoc approach or any other approach can be tweaked to view the data in different format and also few changes can be made ad hoc using few standard functions available like,

  1. Switch Axes
  2. Insert Members
  3. Refresh Selected Data

Switch Axes,

This option switches the dimensions in the Row to Column and Dimensions in Column to Row. Below screen shows how this converted a report with Account in Row and Time and Currency in Column to a report with Account in Column and Time and Currency in Row

Pic6.jpg

Insert Members,

Insert Member option is used in adding members in the report as and when required in the required position. This can be used when the user is not comfortable remembering the ID’s in the system.

Pic7.jpg

Refresh Selected Data,

This option enables the user to refresh data only in the selected cells. If the report retrieves 1000 records and the user wanted to refresh data in certain selected cells, this approach can be used. This enables quick data refresh based on our actual need, rather bringing all data based on the report layout.

  Pic8.jpg

Ad hoc approach of creating reports is very simple and helps users in build quick reports. Still it has certain limitations like,

  1. Building ad hoc Butterfly type reports is not possible
  2. Building ad hoc multiple reports sharing a common Axis is not possible

Note:

The basic Ad hoc report built can be enhanced in building butterfly or shared axis reports using EPM Report Editor Option.

Ad Hoc reports and other new features discussed above on the whole are very useful  for,

1. BPC developers, working on Logic Script, BADI’s, and other Data Loading functions to do quick check on data in the system after the calculation.

2. EndUser perspective it will be more useful to check their relevant data more quickly rather spending time in opening the report which was built before which has many irrelevant data.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Vadim Kalinin

    One more issue with Ad hoc reports – there is no option in the sheet options to disable expand, that was very useful with BPC 7.5 (simply remove expand range reference from EVDRE). It means that if you create an asymmetric Ad hoc report and then do something that requires expand – the report becomes symmetric. Static report issue…

    (0) 

Leave a Reply