Oracle Analytics Cloud and Server

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

Changing the Data model connection to point to different database and data not being reflected

Received Response
41
Views
5
Comments

Summary

Changing the Data model connection to point to different database and data not being reflected

Content

Hi all,

We are developing a use case in OAAC. Initially, we had a connection named "Test". In that, we had a database named "A" and made it point to the data model. Later on, we changed to database "B" in the connection "Test" (which has the same set of tables as the database "A") After this, the data in the reports is only referring to the old database "A" instead of pulling the data from the database "B".

For example:

A table named "ABC" has a record count of 81 in the database "A" while the same table has record count of 94 in database "B".

After changing the database, a report is created for the table "ABC" using the connection "Test", the result should have 94 records but it still shows only 81 records.

Steps we tried:

1.Synchronization with the database in the data model.

2. Cleared cache data in the data model level.

3. Disabled cache via the parameter "SET VARIABLE DISABLE_CACHE_HIT=1;"

But in vain. Would be pleased if someone can help me with this.

Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Hi Prakash.

    If you edit the data model and click View Data how many records return (if you set the Rows  = 200)? 81 or 94?

    Can you see the active connections on the database side (A and B)? Like querying the V$SESSION table?

    Cheers.

    Fernando

  • Rank 6 - Analytics Lead

    Hi Prakash.

    Sometimes we change the default data source connection of the Data Model but the Data Set may still point to a different one.

    Just checking.

    Fernando

  • Rank 2 - Community Beginner

    Hi Fernando,

    Thanks.. how can we get past this issue?

    Prakash M

  • Rank 6 - Analytics Lead

    Hi Prakash.

    It is just a hunch.

    See the images on my sample data model.

    First image is the Data Model Default Data Source

    Second image is the Data Set Data Source.

    Just check if is the correct one on the data set. May not be the problem but worth checking.

    Cheers.

    Fernando

    DataModelDataSource.JPG

  • Rank 6 - Analytics Lead

    Data Set Connection

    DataModelDataSetDataSource.JPG

Welcome!

It looks like you're new here. Sign in or register to get started.