Report of fields and the reports they are in

Aaron Johnson-40082

Description

A report metadata report to aid in data governance and assessing the impact of changes.

Use Case and Business Need

I would like a report, preferably through OBI that I can pull myself, that will give me the columns that are in each report, their definitions/formulas if they have been aliased (name changed) and what it is if the name has been changed, what it was changed to and from. Ideally, it will include the fields used in filters as well. Bonus if it included the position of the field in the output of the report.

This metadata will aid in data governance efforts to discover what is out there and work towards standardizing reports so that we use the same terminology to describe the same things and not have 5 different terms for the same item.

This will also aid in assessing the impact of changes. Should we re-define an existing term, which reports have this term and will need to be updated to the new formula? In the current set up this is a herculean effort in our implementation as we have well over 1000 different reports and dashboards

Original Idea Number: 271b2f9314

RichardChan

Have you looked at this blog https://shivabizint.wordpress.com/tag/rpd-column-usage-in-reports/

 

Richard

Neodata Australia

Aaron Johnson-40082

The link you give is <sort of> what I would do with such a report I am requesting. But I still want that report! The other post on the blog that describe how to get this data talk about tools that are not available to me. Rather I can download and install them, but don't have the connections/permissions needed to make them work.(I have tried several times)