Connect to OAC Shared Catalog in DV to use analysis as a dataset

E. van der Poel-Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

OC Customer

Description (Required):

Just like connecting to Fusion OTBI shared catalog, it would be useful to connect to the OAC shared catalog folder itself and use OAC classic analysis as a source.

Use Case and Business Need (Required):

To modernize the dashboards it would be efficient to use existing OAC shared analysis as a dataset/source. The existing method to do this using the logical SQL (https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-dataset-local-analysis.html) is not very efficient considering the maintenance

Enhancement Request / Service Request:

Eric Dumont

It's a good idea to modernize the old Classic Dashboards in Data Visualization.

The advantage is that the classic analysis are correct and error free then you won't have to redo all the tests and for maintenance it's also easier. Think about the fact that the classic analysis takes into account the translations and the data security! If you need new columns it's easier to add them in classic rather than correcting the SQL you copied (https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-dataset-local-analysis.html).

This exists for access to the OTBI catalog of fusion apps so why not for the OAC catalog (see the screenchot)?

Bret Grinslade - Oracle Analytics-Oracle

The goal is to use an analysis as a source for a dataset? Basically a reference to the logic sql?

E. van der Poel-Oracle

The goal is to use an OAC analysis as a source for a dataset (not just the logical SQL). If the classic OAC analysis is changed, we want the dataset to be changed too (automatically). Similar to how this is handled when we use OTBI analysis as a source for a dataset.

ALOK SH-Oracle

Hi,

We can use OAC shared catalog as well. While creating connection with OAC please use Oracle Applications as connection Type and passing the respective details.

Please check.

ALOK SH-Oracle

Host name should be OAC url like https://.../analytics

username: OAC username

password: OAC password

E. van der Poel-Oracle

The documentation (see link in my initial post) says: "Don't create or use an "Oracle Applications" connection to connect to your local Oracle Analytics instance. Using a connection to your local instance results in data caching issues and errors in visualizations"

ALOK SH-Oracle

Yes, now i can see the link. I just created connection and replied.

You are correct. Thanks.