Just came out of a meeting where the Houston based customer needs to make a OLAP delivery decision. They have been using BW for the last 3 years and are now migrating to Business Objects OLAP.
Decision 1 whether to stay with BEx reporting or move it all to BO
1. There are many reports that are best run via the BW.
a. Where performance is bad the customer had a BW Accelerator installed.
b. I disagree with SAP’s recommendations that there is no modeling required for BW Accelerator
i. BW Accelerator is a very expensive appliance and modeling can decrease BW footprint anywhere
from 20 to 60%. This means reduction of blades by 20 to 60%, or being able to put 20 – 60% more
cubes into the same number of blades.
ii. The first choice should be to model for performance. We demonstrated increasing some DSO reports
performance from 517 seconds to under 20 seconds in under 2 days of automated modeling. This is
with no BWA or any hardware changes.
2. There are many reports that run more efficiently in Business Objects
a. Core strength is Ad-Hoc capabilities
b. Second core strength is Remote query capabilities
c. Selection is critical
d. Use Xcelsius for standalone visualization
e. Use WebI for remote query capabilities and ad-hoc reporting
f. Use Crystal Reports for fixed pixel reporting and fixed format reporting
The key once again is that OLAP deployment must not be simply a technology decision but that of business needs with OLAP becoming a competitive service provider to meet business needs.