Error during import of Oracle Analytic-Views Metadata into rpd

Question

I am trying to import metadata for Oracle Analytic Views - which used to be Oracle OLAP in old days.

In rpd, I have created a database with Database type = 'Analytic Views'.

In the Connection Pool, I am using 'OCI' connection,  and   Data Source Name=(tns string for our Autonomous database)

When I try to import metadata,  it shows Connection Type = 'Oracle OLAP' (even though I used Database Type as 'Oracle Analytic Views')  and it is asking for a URL.  I am not sure what URL it is asking.

Does anyone remember from old days, what was the URL  when we used to import Oracle 11g OLAP (or 12c OLAP)   cubes into  obiee rpd?

Here is the screenshot:

User_ERVO4 · Answer

Hi Nasar,

have you find a way to import metadata for Oracle Analytic Views inro RPD. I managed to import analytics view and hierarchies but do not see attribute dimensions listed, so not possible to select them to import.

Let me know if find a way to get all properly imported. I use Oracle BI Admin version 12.4.8.0.0.

Thanks!

kalikhan · Answer

Bret,

Thanks for your reply.  I looked at this YouTube video before starting my work.

You maybe able to replicate the issue that I am having.

1. Create a new repository and select 'Oracle Analytic View' as source.

2. Import 'Analytic View' from your database. In my case, it is in my Oracle Autonomous database cloud.

3. After successful import of Analytic View, click on the newly created 'Connection Pool' and try to import Metadata again.  This time the "Import Metadata - Select Data Source" window will show you Connection Type = 'Oracle OLAP'  and there will be a URL input box also.   So it is confusing  why it selected 'Oracle OLAP' as 'Connection Type',  even though I did not mention it anywhere.

I understand that the behind the scenes work in importing Metadata of 'Analytic Views' is similar to old 'Oracle OLAP cubes' metadata import - which used to be: 'OLAP AW',  'Oracle OLAP Dimension', and 'Oracle OLAP Cube'.

But now for 'Analytic Views',  there seems to be Metadata Import issue if we are not creating New Database and trying to only import new objects in existing Analytic View in Physical Layer.

Another related issue (or maybe bug)  I forgot to mention:

* Take an existing RPD file and create a new database.
* Select 'Database Type = Oracle Analytic Views'
* Define a Connection Pool.  You will only see 'Oracle Call Interface' and 'ODBC' option there.
* I selected 'OCI' and entered my autonomous database tns string in 'Data Source Name'  alongwith username and password.
* When you will Import Metadata you will only see regular sources - Table, Views, Keys, Synonyms etc.    It does not show option for 'Analytic Views'.  So how can we add a New Database in existing RPD file (which already has many subject areas in it), and add   a new subject area for 'Analytic Views' in it.

All OAC-AV demos start with new RPD repository, where Analytic Views can be imported.  Try doing that in an existing RPD file.

Nasar

Bret Grinslade - Oracle Analytics-Oracle · Answer

Current Admin tool does support analytic views.

https://www.youtube.com/watch?v=pmhVGvEB98k

Semantic Modeler has AVs on the roadmap but it is not yet available.