Skip to Content
0
Former Member
May 19, 2010 at 08:16 AM

Account formula performance impact

25 Views

Hi

We have a solution where we use the account formula to calculate a number of KPI's, none of them are too complicated. Typically one account/parent divided by another account/parent.

My problem is that, when using these accounts in a report performance is terrible. In some cases adding 4 or 5 KPI's to a report, make the expand run for 5 to 10 minutes and that is not acceptable.

I have reviewed the calculations to see if they could be moved to business rules, but since they use division, that doesn't seem to be a solution.

Could properly move some of them to logic, but that would make maintenance a bit technical. Finally I could calculate them in the report.

Our environment is BPC 5.1 (will be upgraded soon), SQL Server 2005 all installed on one Windows 2003 server with a quad core CPU and 10 GB RAM. We have around 50 users

My question is what are my options in getting a significantly better performance on my MDX account formulas?