You can create reports to display catalog data for all catalog object types. You can either display the report on the screen or save it to a file.
When you create a report, a blank or empty field is exported as a tab character. If you create a report with the default of a tab as the field separator, then two tab characters in the report file indicate a blank field.
To create a report that displays catalog data:
For details on supported Excel versions as part of Microsoft Office, see the system requirements and certification documentation. For information, see System Requirements and Certification.
Running reports can not only help you maintain data within the system, but also can help identify issues before they become problematic.
You can generate reports for various purposes, as described in the following examples:
To see which dashboards are using an analysis, you can run a Dashboard report including analyses, and search that report for the analysis
To find analyses that are affected by a changed column in a repository table, you can run an Analysis report that includes all columns and formulas, and then search the report for the items that must then be replaced in Catalog Manager.
You can create a report that displays all the dashboard prompts and related fields (such as column, formula, and subject area) within the dashboards. You can also create a report of analyses and extract the filters that are used within those analyses. The following is an example of extracting filters in which the formula is derived using a saved filter that is prompted:
Example: "Markets"."Region" [Filter, prompted]
You can create a report that displays the ACLs for objects. By reviewing the ACLs in the report, you can verify that access to objects is granted to the proper roles with the proper permissions, such as Read/Write. The following line shows an example of ACLs in the report:
"^biconsumer=RX:steve=F", where the caret (^) indicates an application role and "nothing" indicates a user.