Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Using excel from front end for reporting in OBIEE
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
Answers
-
Hi,
You can as long as you upgraded to OBIEE 12c. In 12c you can use Visual Analyzer / Data Visualization which allows you to load an Excel file in the front-end and use it for analysis.
0 -
+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/
0 -
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.
0 -
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.
0
