As powerful as the analytics capability is within NetVisn, there are still some things that customers have identified as needed information that it does not yet provide. For these situations custom queries into the NetVisn database are an option to provide this information. We have created metadata custom queries for a number of our NetVisn customers, and since many of these may be useful to all customers, we have decided to create a Cognos Custom Query Library of the top 25 and make them available via our website. These are shown below.
If you want to download a Cognos metadata Custom Query, simply click on ‘download now’, enter your email address and customer password and download the query. Going forward it is likely that some of the Custom Queries you see here will become part of NetVisn Analytics depending upon their popularity.
Note: To use these Custom Queries you must be using NetVisn version 6 or higher.
Have a unique need for Cognos metadata that only NetVisn can answer?
Let us know what it is: Support@envisn.com
Query Name |
Use Case |
Cognos Model Item Usage by Package | Reduce the complexity in a Framework Manager model by removing unused model items |
Cognos Data Source Connections and Package Dependency | Inspect all data source connection strings and see the packages where the data sources are being used |
Cognos Model Item Documentation by Package | View all model item definitions to verify business rules and database column dependencies |
Query Name |
Use Case |
Cognos Report Database Usage by Location | Verify database columns used by report items in all reports at a specific Cognos Connection location |
Cognos Report Database Usage by Package | Verify database columns used by report items in all reports that use a specific package |
Cognos Cube Data Usage | Verify the Cognos cube usage by reports (dimension, level & measure) |
Query Name |
Use Case |
All Cognos Schedule Detail | Analysis of all schedules |
Cognos Job Step Parameters and Emails by Package | Verify that the defined report parameters in job steps are correct for the specific email recipients |
Cognos Drill-Through Definitions | Check that report drill-through definitions reference existing and correct reports |
All Cognos Shortcut Targets | Check that shortcut definitions reference existing and correct objects |
All Cognos Report View Base Reports | Check that report views reference existing and correct reports |
Cognos Object Data Source Usage by Location | Verify the data sources and connections being used for reports |
Cognos Object Data Source Usage by Package | Verify the data sources and connections being used for reports |
Cognos Reports With Embedded SQL | Find report that contain embedded SQL |
Cognos Report View Details | Verify all report views |
Cognos Report Descriptions | Check report descriptions |
Query Name |
Use Case |
Cognos Studio Saves | Determine Cognos studio usage by account |
Cognos - Attachments Sent with SMTP Addresses Summary | Find Non-Cognos Users who receive Cognos output via Email Attachment |
Cognos - Attachments Sent with SMTP Addresses Detail | Find Non-Cognos Users who receive Cognos output via Email Attachment |
Query Name |
Use Case |
Cognos Objects Sending Attachments by Location | Find out which reports are required (or not) to deliver report output by Email |
Cognos Objects Sending Attachments by Package | Find out which reports are required (or not) to deliver report output by Email |
Query Name |
Use Case |
Cognos Data Source Connections | Verify the correct database connection are being used |
Cognos Data Source Tables | See which database tables are being used in Cognos |
Cognos Data Source Tables and Columns | See which database tables and columns are being used in Cognos |
Query Name |
Use Case |
All Cognos Job Step Details | Quickly check the step dependencies of all jobs |
Request a Demo
Support
978-779-0400
info@envisn.com
3000 Polar Lane, Suite 901, Cedar Park, TX 78613 USA
Serving North America, Europe, and the UK with plans to expand to other areas in the near future. Privacy, Copyright & Liability