Would you select SAP’s product or another OLAP tool?

In an effort to validate my opinion of SAP BW/Netweaver Capability - In terms of flexibility, KPI Development, and Predictive Analytics, If you had to decide, would you select SAP's product or another OLAP tool and why? Situation: Global Manufacturing Company, multiple lines of business, 2 instances of SAP US & Europe, Growing data requirements, Need to provide " Performance Pacing metrics" monthly for both sales reps, products lines, by region, by sku"

Answer Wiki

Thanks. We'll let you know when a new response is added.


All data warehouse products provide flexibility and good tools to build strategic reports focus on KPI. All of them also provide easy to use tools to display and organize analytic information….. I guess that the decision about what product will be chosen will be based on how difficult is to pull (and keep updated) the data from the transactional systems behind. In other words, if you are running SAP to manage a big part of your day to day transactional system, go for BW / BI.
In SAP BW / BI, you have a large group of extractors and predefined processes that enable you to pull the data from the SAP systems into multidimentional indexed data providers. Once the data is there, you could easily develop your own queries and reports, organizing them in almost whatever way you want and building almost any possible KPI you want. You cloud display and manipulate these queries and reports using almost any single PC product you want……
Now, if your data sources are not base on SAP …… mmmmm …… Well, you have to build your own data extractors . You also have to build your own data warehouse targets (data providers) and your own mapping processes. You will be dealing with normalization and database definition concepts. Being technically feasible, probably is not the best path.
If you have an hybrid situation (some SAP systems and some NO SAP system), you will evaluate how many strategic data sources you have in each size and take a decision base on that.

I hope this helps……

Luis E. Lavieri
City of Vancouver, BC

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Carp
    WIth the acquisition of BO - you should consider there product base as well..they are much better at this type of analytics.
    275 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: