Welcome to Sulekha IT Training.

Unlock your academic potential here.

“Let’s start the learning journey together”

Do you have a minute to answer few questions about your learning objective

We appreciate your interest, you will receive a call from course advisor shortly
* fields are mandatory

Verification code has been sent to your
Mobile Number: Change number

  • Please Enter valid OTP.
Resend OTP in Seconds Resend now
please fill the mandatory fields including otp.

Reporting Tips & Techniques with SAP BPC

  • Link Copied
Reporting Tips & Techniques with SAP BPC

As the SAP BPC evolved as one of the best business planning and consolidation platform, these tips on reporting SAP BPC jobs would help the professionals to great extent.




#Tip1




Drop-down lists help make a worksheet more efficient by provided a controlled list of options that make the report or input template respond to preconfigured options. To create the list use Excel’s Data Validation tool, if there is a need take this a step further by populating the list with EPM reports on a ‘List’ tab within the workbook.  In the snapshot below we are using drop-down list for Company, Cost Centre, Program, and Account. Each drop-down list will have its own report to populate the list.




#Tip2




Cost Centre list - A list of cost centers is created using fixed members that had been input. In this example, the dropdown has a friendly label that is the result of concatenating ID & Description, but the report will only use the dimension ID’s referenced on the list tab by using Excel’s VLOOKUP function to match the concatenated friendly label to the ID from the right row.




#Tip3




Program List is built similarly to cost center but this time, we’ll go with just a list of IDs.  It is using an EPM function to produce the list of members, filtering on a flag account to pick up the correct members dynamically. Any additional members added to the dimension need data sent to this flag to cause the members to be returned on this grid. Users can “maintain” the list by sending in data to the “BPC_FLAG_ACCT” account member. Once sent, the data will drive the inclusion of members in the list.




As a final example, the Company dimension uses a fixed list, which is perhaps the easiest to configure, but this approach has its drawbacks. There is no EPM report and it is manually maintained.  Best practice would be to use a property so it is maintained outside the workbook. For a one-off report this is okay, however if a similar list is required on other reports/schedules consider using a property to drive the list contents.   With a property we would be able to create a dynamic report driven by that specific property.




As you can probably envision, by leveraging the ability to build dynamic lists and include drop downs in the user interface, you should be able to create a superior user experience that is also very low on maintenance. Doing so successfully requires some forethought and detailed execution. Getting it right the first time may take some practice, but once you build a few of these valuable reports, your users will get the best experience without being an ongoing burden on your administrative resources.


Take the next step toward your professional goals

Talk to Training Provider

Don't hesitate to talk to the course advisor right now

Take the next step towards your professional goals in SAP BPC

Don't hesitate to talk with our course advisor right now

Receive a call

Contact Now

Make a call

+1-732-338-7323

Enroll for the next batch

Related blogs on SAP BPC to learn more

Latest blogs on technology to explore

X

Take the next step towards your professional goals

Contact now