Is there a tool or function to where I can enter a table from a universe and see all BO reports that contain that table?

[Former Member]

I am trying to locate a tool or function  where I can enter a table from a universe and see all BO reports that contain that table. EX: I have a  report “Trade Information” with a column  called “Date”, when I look at the Query Script Viewer I see the table involved for that column “Date” is DATA_FIELD.ADMIN.DATE, I would like to run a query for “DATA_FIELD.ADMIN.DATE” that would return all reports that would be using the table “DATA_FIELD.ADMIN.DATE”. Ideally it would also tell me the column and the SQP used for that column. Is there a tool or function that can do that? Thanks!!

[CdnConnection]

David,

     If it is a table within the Universe / UNX then the only option I know of that I have used before is SAP Information Steward to do impact analysis.  The tool is from SAP and you can even talk to your sales rep to get a 90day trial copy.

Information Steward | Data Profiling & Integrity | SAP

Regards,

Ajay

[former_member185603]

There is no out of box tool available in BO. There are some 3rd party vendors have the tool which will give the information you are looking for.

[Former Member]

Thank you for the quick response, do you have a list of these vendors?

Thanks!

[DellSC]

Or you can use one of the SDKs to program your own.  I'm in the process of doing something similar for one of my clients.

-Dell

[former_member185603]

APOS and GB& Smith (360)

Information Steward has lot more features than what you are looking for. Profiling the data, impact analysis, lineage etc.

[atul_chowdhury2]

A more complete list (full disclosure: I work for Infolytik!)

Infolytik

Product: MetaMiner Enterprise

Web: http://www.infolytik.com/products/metaminer

EV Technologies

Product: Sherlock

Web: http://evtechnologies.com/products/sherlock

APOS

Product: Insights

Web: http://www.apos.com/content/apos-insight

GB & Smith

Product: 360Eyes

Web: http://www.gbandsmith.com/en/360eyes

Analytics8

Product: System Profiler

Web: http://us.analytics8.com/products/system-profiler