Hi,

I am personnel in a small goverment organization responsible for do reporting related to our operations. Our data come from different sources. So, we've got obiee. We have only 1 IT person who could manage setting up the database and import data from other souces. We designed the dashboards, etc. I am not an IT personnel, so If I do not use proper IT jargon, please bear with me. I have to find a solution for our problem because no one else seems to feel obliged to do it. But if you explain it the way only IT person could understand, that's fine. I can take it to our DBA to perform it.

Since we have 1 person who could  partially work for our obiee needs, we, the non-IT personnel, need to do most of the work ourself, including importing external data, and have to do it without creating repositories or writing scripts/codes. The data in external databases we need to import cannot be connected to repositories but have to be downloaded from the internet as excel files and, now and then, have to be refreshed.

As you may well know, 12c lets you import excel files according to oracle's own tutorials like here:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/cad/cad12c.html

I also found other sources claming it can be done. I tried it but our "add data source" button does not work. It works as" add subject area" and won't let me choose external data but only subject area. Other sources claim that this function comes withe the sample database. It is already installed but still we cannot use this function. We tried other suggestions and now every view looks like a subject area. I was able to import excel files in visual analizer but not in analysis. The fist picture is from the tutorials while the second is from our obiee.

I forgot to mention that the bussiness partner of oracle in my city claimed that it cannot be done, despite the fact that I had sent them the Oracle tutorials explaining the impoting of external sources.

So, can somebody tell me if excel files can be imported into our analysis? If it can be done, can somebody tell me how to do it? Again "our add data source" only works as "add subject area" button.

Kind Regards,

Ahmet.