nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Use Catalog Manager to generate file that contains columns that are used in a DV-project

User_4TZ3Q

Description

We would like to be able to do an impact analyses before making changes in the RPD. This would require us to know which columns are used in which analysis/dv projects/dashboards. To do so we would like to have the opportunity in the catalog manager to generate an export that contains a list of dv projects with the columns that are used in there in any form.

Use Case and Business Need

To have a good understanding of the impact of a change in your data model (rpd).

More details

InSR 3-26500516511 : How To Check which columns are used in which DV projects we have asked if it is possible to get an extract out of the catalog manager about which columns are used in which dv projects. This is not a supported feature yet.

We already have something similar for analyses, which we create like something:

runcat.sh -cmd report -excelFormat -distinct -online .. -outputFile $REP_PATH/Analysis_Columns.report -type "Analysis" -fields "Name:Path:Table:Column:Subject Area"

It would be great to be able to do something like:

runcat.sh -cmd report -excelFormat -distinct ..... -type "DV Project" -fields "Name:Path:Table:Column:Subject Area"

Original Idea Number: 1fe15bb5f6

Find more posts tagged with

Data Modelling and Datasets

Developers

Needs Votes

Status: Needs Votes

Comments

Jean-Pierre Hoedenaeken

Indeed, catalog manager should offer the same functionnality for DV projects as for objets from classic.