Break from Blogging and SAP BPC

Took a break from blogging as much of time was spent towards stabilizing an SAP BPC 7.5 environment.
Weeks of troubleshooting identified a number of performance hogs across the landscape.

We derived some tangible improvements on these fronts:

• Excel report template with more lines than enough had a direct impact on Excel performance due to EV-DRE macros - big saving on Desktops
• Newer Laptops with Intel i7-3740@2.7GHz performed better than Intel i5-3320@2.6GHz because of CPU requirements for BPC reports anyway.
• BW ABAP servers were re-sized to have 4 CPUs and 16GB memory each
• Running reports for YTD measure led to pinning Server CPUs down with the earlier version.
• This problem seemed to have lessened since the upgrade to 7.5 SP15 though
• Computing oracle table stats on an F-Fact table frequently also helped fix catch-me-if-you-can problems during planning cycles - will dedicate a blog for this topic soon.