70 likes | 182 Vues
This presentation by Barbara Deakin focuses on the Vision Reporting Toolset designed for easy and fast report creation from the TCMW database. It provides users with a unified reporting structure capable of accessing multiple databases and platforms seamlessly. Key functionalities include the generation of queries using familiar terms, a standardized user interface for reporting and analysis, as well as features for conditional and scheduled report distribution. The session also covers essential discussion topics such as query templates, Excel workbook integration, and advanced reporting options for in-depth data analysis.
E N D
Ad-Hoc Reporting for TCMSession - 304 Presented by Barbara Deakin
Objective • Easily and quickly create reports from the TCMW database
What is Vision • Vision is an end-user reporting toolset and data model designer that.. • Creates a unified reporting structure that can reflect multiple databases and platforms • Live access across multiple application systems • Allows end-users to create queries using common terminology • Common user interface for reporting and data analysis • Conditional and scheduled report distribution
Discussion Topics • Reporting Functions • Components of the Query Definition Form • Opening an existing Definition • Filter options • Sorting • Save Excel workbook • Summary Report, Favorites • Query Templates
Discussion Topics • Excel Template Workbooks • Combining reporting functions • Recalculate Functions and Automatic Filter Lookup • Adhoc Analysis - Drilldown • Adhoc Analysis – Cube • Format Tables • Macro Builder • Query Template View Only • Auto Format • Report Designer