Problems reporting against an OLAP database.
December 21, 2012
Problems reporting against an OLAP database.
Score 6 out of 10
Vetted Review
Software Version
3.1, 4.0 SP
Overall Satisfaction
- I would score an 8 if reporting on a relational database - performance is good and the product works well.
- Features and options are good. It can cater to many different use cases, depending on end-user requirements.
- The suite contains multiple tools - OLAP, Explorer, Dashboards. It's highly versatile with a great variety of tool-sets. It doesn't force people to do things one way using a single tool.
- However, continuing problems in reporting against an OLAP database reduce the overall score to a 6.
- BW / Business Objects integration: SAP has more work to do here. Version 4.0 has removed major obstacles in stability, but we still have a lot of performance issues. The Business Objects features have been limited by the BW background. I would give this a score of 5 overall.
- SAP is pushing an in-memory database solution - HANA. SAP resources are focused on moving BW to HANA database. I believe BO performance will improve significantly as a result of this. We want to re-evaluate our data warehousing strategy, middle of next year. We are going on two paths currently. We want to take a step back and re-evaluate if SAP has a better solution.
- Dashboard tool sub-standard relative to Tableau. Takes weeks to get working vs. days in Tableau to build.
- Mobile compatibility is far ahead in Tableau.
- From the admin perspective, Business Objects is not fine tuned out of the box.
- Rolling out support packages is not disciplined -sometimes every 2 weeks, sometimes every 2 months.
- No good alerting and monitoring systems.
- No handshake to BW - e.g. send something on a trigger basis from another system to Business Objects.
- Sales - helps track revenue, shipments, pay commissions to reps.
- Operations - usability of tool is good - one common repository for every body to see reports. This really is a one-stop-shop for reporting.
- Inter-operability of analysis views.
Product Usage
300 - Operations
Finance
Sales
Finance
Sales
2 - One is a DBA, the other is SAP Basis person.
- Operations: We use Business Objects to create operational reports on manufacturing processes. We pull data from SAP ERP into BW and then report on that data.
- Finance: We bring in data from SAP ERP to BW and report using the native BW reporting tool called BusinessExporer (BEx). This has all GL information, and we use a profitability analysis tool called CO-PA (cost and profitability analysis) to track revenue, and sales goals.
- Sales:we pull data from all systems - SAP ERP, Salesforce.com, SAP CRM - and bring the data intoto BW, for where we report on it using Business Objects. We use Business Objects to build pipeline reports, revenue reports, shipment reports. and also to track the revenue quarter to quarter. We have another system called Adexa Collaborative Demand Planning (CDP) - for trend analysis and forecasts.
- We are not using Salesforce as revenue system. Everything related to revenue has to come from SAP. Primary report that SAP is looking for is revenue. We collect all data from transactional systems into BW.
Evaluation and Selection
We were using the SAP Business Warehouse (SAP BW) for reporting, visualization etc.
Originally, Business Objects was implemented before I joined.
When we had issues with Business Objects Version 3, we evaluated:
1) Tableau - This is a great product, really rich/appealing, and good mobile finctionality, but the price and the ETL functionality were issues. Allso performance of Tableau against OLAP data was not that good. It was much better against relational databases.
2) SQL BI - This had most of the features looking for. We have started to use SQL BI tools - not in production, we are stilltesting. We are not using with OLAP - we bring data from BW and store in a SQL data mart, stage, transform if required, model, then report.
- Finance still using old SAP BW tools.
- Operations is using BO 4.0
- Another group using Business Objects 3.1, and is going to try out SQL BI tools
We also evaluated another product called Greenplum (acquired by EMC). This has no front end to it, and is essentially a data warehouse.
When we had issues with Business Objects Version 3, we evaluated:
1) Tableau - This is a great product, really rich/appealing, and good mobile finctionality, but the price and the ETL functionality were issues. Allso performance of Tableau against OLAP data was not that good. It was much better against relational databases.
2) SQL BI - This had most of the features looking for. We have started to use SQL BI tools - not in production, we are stilltesting. We are not using with OLAP - we bring data from BW and store in a SQL data mart, stage, transform if required, model, then report.
- Finance still using old SAP BW tools.
- Operations is using BO 4.0
- Another group using Business Objects 3.1, and is going to try out SQL BI tools
We also evaluated another product called Greenplum (acquired by EMC). This has no front end to it, and is essentially a data warehouse.
Implementation
- Vendor implemented
- Implemented in-house
- Professional services company
Training
- Online training
- In-person training
- Self-taught
We learned through on the job training as administrators.
End users learn through documentation, online training and classroom training that we put on. We put on a class whenever we roll out a new report.
End users learn through documentation, online training and classroom training that we put on. We put on a class whenever we roll out a new report.
Support
Yes - Seeing how difficult the tool is to keep up and running, our CIO decided to do this.
Usability
Reliability
Integration
- SAP Business Warehouse
- SQL relational database tool called Planview
Data from SAP CRM, etc, into BW.
- SAP ERP directly
SAP has given a few direct integration points for specific use cases. This helps us to avoid ETL processes.