Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

Home
Data Administration
Reporting
Reporting
Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
Post-Installation Checks for Reporting

Workflow IPI
Get Started
Tutorials
Orientation
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
- Data Administration Introduction
- Electronic Signatures and Audit Trails
- Data Sources
- Archives
- Custom Property Types
- Transferring Workflow
- Reporting
  - Reporting
    Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
    - Reporting Database Replication
      Workflow includes an option to install a reporting database. This database can be used with any valid reporting tool, and allows you to build ad-hoc reports on up-to-date data that you synchronize from your production database.
    - Default Reporting Schedule Editor
      The Default Reporting Schedule editor is used to configure a connection with your reporting database, and to configure the synchronization schedule between the production and reporting databases. Synchronizing the two databases allows you to run up-to-date reports on your data.
    - Reporting Datamart Tutorial
    - Post-Installation Checks for Reporting
    - Microsoft Reporting Service Samples Files
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

Post-Installation Checks for Reporting

After installing the Proficy Client Reporting Datamart Samples, perform the following checks to determine if the installation was successful.

Open the Microsoft Server SQL Management Studio - Database Engine and look for the following:

A database with a set of dimension and fact tables in the Tables folder of the reporting database.
The initial Extract, Transform, Load (ETL) job, SyncPlatform, has run manually in SQL Server Agent with no errors. Search in the Jobs folder of SQL Server Agent in the Object Explorer.