Error during import of Oracle Analytic-Views Metadata into rpd — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error during import of Oracle Analytic-Views Metadata into rpd

Received Response
71
Views
4
Comments
kalikhan
kalikhan Rank 3 - Community Apprentice
edited Nov 15, 2024 1:33AM in Oracle Analytics Cloud and Server

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:

rpd_import.PNG

Answers

  • Pete Monteiro-Oracle
    Pete Monteiro-Oracle Mod

    Hi Nasar, just to clarify you are attempting to import your AVs that currently reside in your ADW currently correct? What version of the OAC Client tool are you using, you should see the option of Oracle Analytics Views

    Screenshot 2024-11-15 110306.png
  • kalikhan
    kalikhan Rank 3 - Community Apprentice
    edited Nov 19, 2024 10:42PM

    Hi Pete,

    Sorry for late reply.

    I did use 'Oracle Analytic Views' as Connection Type when I added new database in Physical layer. It still shows 'Oracle OLAP' during Import Metadata step, and also ask for some URL.

    I am now thinking about creating regular sql views on top of ATTRIBUTE DIMENSION hierarchies, and ANALYTIC VIEW and then import all those as regular sql views in Physical layer. Define all the joins and Keys after that.

    During old days, I did that type of work when I was working with Oracle OLAP cubes and OBIEE. So I have some experience with defining sql views on top of OLAP cubes and then doing the work in BMM layer so that no SUM..GROUP BY queries are generated, as the all data already exists at all levels of all dimensions (in Analytic View).

    BTW.. I noticed that Oracle Analytic Views is not a data source in the new 'Semantic Modeler' of OAC. I hope that it will be added at some point in future.

    Nasar

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    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.

  • kalikhan
    kalikhan Rank 3 - Community Apprentice
    edited Nov 19, 2024 10:59PM

    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:

    1. Take an existing RPD file and create a new database.
    2. Select 'Database Type = Oracle Analytic Views'
    3. Define a Connection Pool. You will only see 'Oracle Call Interface' and 'ODBC' option there.
    4. I selected 'OCI' and entered my autonomous database tns string in 'Data Source Name' alongwith username and password.
    5. 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