Does anyone know if any Cognos Audit table can be used to field reports that are using a specific field?

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------

#CognosAnalyticswithWatson

Hi Jenifer,

I am not related to this company, but I believe you can have a look to MetaManager, https://www.bspsoftware.com/products/metamanager/

There is a 15 day trial.

Best regard,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

HI Patrick,

Thanks, I appreciate the info!  I'll check it out.

------------------------------
Jenifer Broughton
------------------------------

Original Message:
Sent: Tue September 06, 2022 10:53 AM
From: Patrick Neveu
Subject: Any audit report or 3rd party software to find reports where select field is used

Hi Jenifer,

I am not related to this company, but I believe you can have a look to MetaManager, https://www.bspsoftware.com/products/metamanager/

There is a 15 day trial.

Best regard,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Hi Jen

If you use Framework Mangager for reporting, you can search for report dependencies in Framework Manager. Select the specific field in Project Viewer and go to Tools menu, then click on Find Report Dependencies.

Kind regards,
Nils

------------------------------
N D
------------------------------

I've added a report dependency tool to the premium version of CogBox. This will return all reports, dashboards, stories, explorations, and other data modules that reference each data item in your model. Once Event Studio agents support DM, I'll add support for them as well.



------------------------------
Paul Mendelson
------------------------------

Hi @Paul Mendelson,

Thanks for the reply.

Is CogBox a PMsquare software add on?

Thanks,
Jen​

------------------------------
Jenifer Broughton
------------------------------

Original Message:
Sent: Wed September 07, 2022 05:12 AM
From: Paul Mendelson
Subject: Any audit report or 3rd party software to find reports where select field is used

I've added a report dependency tool to the premium version of CogBox. This will return all reports, dashboards, stories, explorations, and other data modules that reference each data item in your model. Once Event Studio agents support DM, I'll add support for them as well.



------------------------------
Paul Mendelson
------------------------------

Hey Jen,

Yeah. It's a set of tools, widgets, and custom controls to improve Cognos in various ways. There is a free version, but the Column Manager in that doesn't have the report dependencies tool.

https://pmsquare.com/cogbox


------------------------------
Paul Mendelson
------------------------------

Original Message:
Sent: Wed September 07, 2022 08:08 AM
From: Jenifer Broughton
Subject: Any audit report or 3rd party software to find reports where select field is used

Hi @Paul Mendelson,

Thanks for the reply.

Is CogBox a PMsquare software add on?

Thanks,
Jen​

------------------------------
Jenifer Broughton
------------------------------


Original Message:
Sent: Wed September 07, 2022 05:12 AM
From: Paul Mendelson
Subject: Any audit report or 3rd party software to find reports where select field is used

I've added a report dependency tool to the premium version of CogBox. This will return all reports, dashboards, stories, explorations, and other data modules that reference each data item in your model. Once Event Studio agents support DM, I'll add support for them as well.



------------------------------
Paul Mendelson

Hi Jen,

several solutions have been pointed out. If you're looking for a more general solution I can recommend Manta Data Flow. We use it as our full data lineage tool from source to target incl. all transformations in our DWH, the FM models, Dynamic Cubes models and reports.

https://getmanta.com/

------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------

While we use MetaManager to administer our server, don't forget too that IBM supports AND endorses the Motio products now.  It's possible the free version of MotioPi can do that kind of search you're looking for.


Wayne

------------------------------
Wayne Westlake
------------------------------

Original Message:
Sent: Wed September 07, 2022 05:31 AM
From: Robert Dostal
Subject: Any audit report or 3rd party software to find reports where select field is used

Hi Jen,

several solutions have been pointed out. If you're looking for a more general solution I can recommend Manta Data Flow. We use it as our full data lineage tool from source to target incl. all transformations in our DWH, the FM models, Dynamic Cubes models and reports.

https://getmanta.com/

------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------

i have three MS SQL stored procedures that read the content store. (1) create cognos inventory of objects (2) search for text in reports (3) replace text in reports.

The sprocs are pretty generic. They need to be run by someone who has the MS SQL permissions to create objects in the content store database. I think the sprocs create one permanent table for the inventory and some temporary intermediate tables. working on a sproc now to take an inventory of all reports and queries. We use the object inventory and report inventory as a before and after release package deployments to look for any changes - some intentional and some not intentional. 

attached is a single sproc that created the three sprocs.

once the sproc are created read the green comment box at the top of each for a short explanation and examples on how to run them.

------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
------------------------------