OBIEE Analytics report with 250+ columns

Question

Hi All,

We are working on an OBIEE fit analysis; client is looking for a self-service reporting solution and the number of columns in most of the reports is 250+. Number of rows can vary from 10,000 to 100,000.

a) As per our analysis, OBIEE Analytics may not be recommended as it might lead to browser/performance issues because of the large number of columns. Please respond if you have worked on any such implementations.

b) OBIEE Smart view can be leveraged here? If yes what are the major challenges?

If yes, how Oracle Smart View connects with OBIEE in a SSO enabled environment?

Any pointers will be highly helpful. Thanks!

Regards,

Dennis

user10995416 · Answer

Currently these reports are built on SQR and most of the reports are being sent to external clients. Currently whenever there is a change request, there is an IT team dependency, which adds cost and time. That's why they are looking for a self-service reporting solution where business users can modify the report (mainly add, remove columns, change filters etc.) without much IT support. The data source is Oracle and client is fine with building a data mart (dimensional data model) for OBIEE.

rmoff · Answer

When you say "self service", do you mean the user self-serves by loading up a pre-built report with 2.5M cells of data, presumably into Excel?

What's being done with those 250+ columns and thousands of rows of data? That should be driving the tool choice. If they genuinely want self-service analytics then OBIEE is good for that; but 2.5M cells of data is not "analytics", is a "data dump".