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.