cancel
Showing results for 
Search instead for 
Did you mean: 

Performance of BPC 10 report

former_member481715
Participant
0 Kudos

Hello,

I have a BPC report that has about 45,000 rows and 10 columns. it takes about 5 minutes to refresh. I do have surpress On, not a lot of formating, not a single dimension formula. How do I improve performance? the reason why it has 45k rows, because dpending on what the user selects in context, the different set of rows have data. so usually report only has about 200 rows with data, but it has to look at 45k rows. please adivse.     

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Manny,

From the front end, there is no other way of improving the performance; since you have already ruled out the dimension formulae, formatting, etc.

You have a total of 4,50,000 data cells. Without suppression, how many data cells will be there? The usual behavior is that it will first fetch all the records depending on the context, and then the suppression will be applied.

Moreover, if the number of records in the system is huge, then it might have an impact. You can try to full optimize the model with zero suppression.

Hope this helps.

former_member190501
Active Contributor
0 Kudos

Hi,

Optmization of model will increase performance.

Check below notes related to performance.

Note 1634922 - BPC 10.0 NW Collective Note for Performance Improvement

Note 1792408 - BPC Parallel Execution Framework

Thanks,

Raju