Using excel from front end for reporting in OBIEE

Question

Hi All,

is it possible to use  Microsoft Excel to generate report in analytics with out importing  Excel file in RPD. Basically we don't want to use any connection pool in RPD related to this excel.

We like to use this Excel to create graphs, tables, pivots in the dashboard.

Thanks

Gianni Ceresa · Answer

Yeah, in 11g there is no other way than going through the RPD, sorry ...

Without mentioning that in 12c the VA/DV option is an extra license probably.

920799 · Answer

Thank you for the Reply,

I would have mentioned my OBIEE version, we are still on 11.1.1.7, Based on your reply I assume there is no possibility to achieve our requirement with out using RPD.

[Deleted User] · Answer

+1 to Gianni. It's called data source mash-ups via external Subject Areas using the Data Set Service

https://www.rittmanmead.com/blog/2016/06/obiee-12c-extended-subject-areas-xsa-data-set-service/