Showing posts with label OBI EE. Show all posts
Showing posts with label OBI EE. Show all posts

Wednesday, 27 May 2009

BI Lessons Learnt

Spent an interesting day at a potential customer recently discussing:

- The lessons that I've learnt on recent Oracle BI projects

- How we could apply these lessons to develop an optimum OBIEE rollout strategy.

In no particular order, some of the key lessons that I highlighted and discussed in greater depth were:

1) Releasing too much functionality at once can overwhelm users and support processes.

2) Requirements for Reports and dashboards evolve as users gain more understanding of the tool capabilities.

3) Involve Users as early as possible in Development process.

- Especially if requirements are unclear or poorly understood.

- Report and Dashboard Prototyping often works well.

4) Ensure End Users understand OBIEE Report and Dashboard functionality and capabilities before the Design process starts e.g.

- View selectors, Column Selectors, Dashboard prompts, Delivery options, BI Publisher integration, and so on

5) Develop organization wide Dashboard and Report 'Look and Feel' standards and enforce them.

6) Review quality of data model regularly: e.g. ensure consistent mappings, conforming dimensions, and so on.

7) System performance and perceived 'acceptable' response time is key to end user acceptance.

8) Maintain a library of existing and re-usable solution.

9) End User Training should be focused and timely.


Reviewing my lessons learnt led on to a debate on iterative and agile development methodologies and how they could be best applied in an OBIEE implementation. I'll post some more on that on a future date.

Wednesday, 30 July 2008

OBI EE and .NET Framework V2

As promised to Chetan... I stumbled across a frustrating incompatibility whilst installing OBI EE 10.1.3.3.3 on a Windows machine earlier.

OBI EE requires Version 2 of MS .NET Framework.

During OBI EE installation, it also launches the installer for Microsoft .NET Framework V2.
However, if you already have a later version of .NET Framework loaded, the .NET Framework install will end with an 'Incompatibility' error.

The OBI EE installation completes successfully.

However, it fails to deploy the analytics application to the OC4J instance correctly.

My workaround was to deinstall the later .NET Framework from the machine and then, restart the OBI EE installation process.

Let me know if you have a better solution!