BI Office Integration
By @lex on Nov 05, 2008
I am often engaged in discussions how the "Excel users" or "Office users" should participate in an Oracle BI EE project. This user group is often characterized as "not needing Oracle BI", "wanting to stick to their beloved spreadsheets" and "not willing to switch to more advanced BI technologies". Sometimes an argument for continuing to use Excel is the mere fact that Excel supports more chart types than Oracle BI (which is true, for example for the Pie of Pie chart - see image below -, one that was on a list of required chart formats once).
Many people have been exposed to slick demos of BI for Office which is of course a very sophisticated and useful solution. But some project teams don't want to install additional software on the client PCs. To please them, I have compiled a list of options that you have - even with older versions such as Siebel Analytics 7.8.
In order to solidify the discussion, I have created a small, maybe incomplete compilation of options that we have to integrate office suites (not necessarily limited to MS Office) with Oracle BI. Just to prepare you: Might be a lot more than you expected.