Tuesday, 9 December 2014

OBIEE Projects - Suspect Requests

The second chapter of session Success with Oracle BI? Typical Error Scenarios and their Solution discusses the way how clients describe their issues when trying to manage their current project situation. Please follow our OBIEE project series presenting our process for solving typical OBIEE project issues:

1. OBIEE Project Success - Introduction
2. OBIEE Projects - Suspect Requests
3. OBIEE Projects - Typical Error Scenarios
4. OBIEE Projects - Turn-Around Approach
5. OBIEE Projects - Criteria for Fast Success and Assessment
6. OBIEE Projects - Solution Process

Customer requests nearly always seem to be quite simple in the beginning. Just two examples what clients ask for in OBIEE projects already taking about 6 months up to 3 years implementation time:
  • Oracle BI query performance is completely unacceptable: generated SQL queries are slow and SQL code covers several pages.
  • Business wants to use Oracle Smart View for Office: users want to use Excel pivot tables and they need the ability to calculate their own figures.
What's really amazing at this point - without talking to the customer in detail - is the fact that the client wants to have a new supplier to solve the issues, because the current one already failed several times. If issues described would be the root cause then solving would be easy. Assume that the client has a structural problem in his current OBIEE solution. Coming from the examples you can say:
  • OBIEE performance is more a structural factor than a detailed one, e.g. to find a missing database index isn't really difficult or time-consuming for an expert. If already simple queries from a business perspective are slow and OBIEE generates several pages of SQL code for these queries then the probability for a wrong OBIEE configuration and a crude data warehouse design is very high. By the way, a real expert will deliver a system with good performance from the beginning. He tells you what to do to achieve acceptable OBIEE performance beforehand.
  • It's the same for using OBIEE Smart View as described above. OBIEE pivot functionality is really good and calculation of your own figures within OBIEE is a standard functionality. So, if the client solution doesn't provide such functionalities then there is at least an OBIEE training gap or in the worst case Oracle BI is configured that bad that it cannot unfold its power.
To summarize, we didn't talk to the client concerning any details till now. Already such requests are suspicious, because the issues described don't fit into a state-of-the-art OBIEE configuration. The next part of our OBIEE project series will describe how we manage the first contact with business users and stakeholders. Series content is based exemplarily on the second example above.

Any questions? We provide Oracle BI expert support & coaching regarding all relevant OBIEE topics like architecture, security, configuration, reporting and mobile.

No comments:

Post a Comment