<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">

SAP Analytics
Thought Leadership

BPC User Data Collection Checklist

Posted by
Charles Dagaev
Charles Dagaev
on Wed, Apr 18, 2012 @ 10:04 AM
Find me on:


When testing and enhancing BusinessObjects Planning & Consulting (BPC) performance, it's essential that users provide the correct information about what they are doing. The following checklist can help you ensure you are comparing apples to apples—in other words, that users that are performing the same processes (reports, input schedules, etc.) when determining user performance of that specific process.

1. Make sure no other server or client processes are happening that are not part of testing.

2. Make sure the Performance appset is aligned with any changes from the Production appset—especially ones that may affect performance (logic, reports, schedules, dimensions, dimension formulas, etc.)

3. The following 4 items need to be recorded for each Reporting refresh, current view change, opening the report:

• User current view before opening reports

• User current view during any subsequent retrieves

• How many records are retrieved during opening or refresh/current view change

• How long it takes to do each process and get a response

4. Finally, the following 5 items need to be recorded for each Input Schedule send/refresh cycle, opening the schedule, and current view change, etc.:

• Current view when opening a schedule and any subsequent changes

• Number of records sent

• Number of records accepted and rejected

• Number of comments sent

• How long it takes to do each process and get a response

As an additional checkpoint, it may also be worthwhile to test reporting/retrieve iterations with the following Analysis Service changes:

• No Analysis Services Cache—Analysis Services has been restarted before testing

• Analysis Service Cache is built—run a huge report that pulls back data related to what the actual users would be doing that day. This would be run before users get into the system and start running reports

Interested in finding out more about how Column5's BPC testing and performance tuning can give you an edge—and take your enterprise's EPM capabilities to the next level? Please drop us a line at info@Column5.com.

Charles Dagaev, Column5's Global Director - Technical Services, brings more than 10 years of experience to the EPM technical arena, providing expertise and consulting using all versions of SAP BPC (formerly OutlookSoft) supporting technology platforms and underlying infrastructure components. He can be contacted at cdagaev@column5.com.

 Click me

Topics: Business Intelligence (BI), Innovation, Performance, Data


Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book


2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC


  3. Get Your EPM Assessment  


Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment