Oracle Communities

Oracle Analytics and AI

Child Item

Can .csv files be used as source to OBIEE RPD and Reports?

I am trying to import the CSV file trough the OBIEE RPD and use this as source for Reporting, Instead of going via database.

How can I do this in 12C. Also with any updates in files should also be auto update in obiee reports.

If anyone has done this, pls help.

regards,

Abinash

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Yes that was pretty much one of the core things thatcame with 12c and everybody was talking about 4 years ago

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

obiee

Explained txt/csv files as data source, refer below link

http://www.oraclenerd.com/2010/02/obiee-text-file-as-data-source.html ORACLENERD: OBIEE: Text File as Data Source

process csv files in obiee - Similar forum thread

[Deleted User]

@obiee that isn't necessary anymore at all. That's why Oracle invented the External Data Set concept and the Data Set Service and Storage.

AbinashBehera

Thank You @christian!!

This article is really good. Unfortunately I don't have VA license with my 12C package. In this case how should I go ahead??

Regards,

Abinash

[Deleted User]

Either buy DV/VA - which is anyways the direction the product is moving - or use BI Publisher or put the CSV as a source into the RPD.

Just don't expect any magic with regards to your initial demand for "Also with any updates in files should also be auto update in obiee reports.".

AbinashBehera

Thank You Christian, I was expecting the same.

Robert Angel

If you have a local Oracle database that could be used in conjunction in OBIEE then you also have the option of using external table functionality, there if the source file changes the data changes, but I have not tested performance on this with larger data sets.

AbinashBehera

can you share some reference meta links for implementing this, if you have.?

Regards,

Abinash

[Deleted User]

https://docs.oracle.com/en/database/oracle/oracle-database/18/sutil/oracle-external-tables-concepts.html#GUID-44323E01-7D72-45EC-915A-99E596769D9E