How do I install Data Axcess Utility Job Monitor Report in CCH Axcess™ Data Axcess Utility?

  • Article Type:
  • How To
  • Last Modified:
  • 11/05/2022

Objectives

To install the Data Axcess Utility Job Monitor Report in CCH Axcess™ Data Axcess Utility.

Environment

  • CCH Axcess
  • CCH Axcess Data Axcess Utility

Procedure

To install the Data Axcess Utility Job Monitor Report in CCH Axcess Data Axcess Utility, do the following:


Step 1: Initial download and installation - [Return to Top]

  1. Download and install Microsoft® Power BI® Desktop.
  2. Launch Microsoft® Power BI® Desktop.
  3. Copy the DAU Job Monitor Report.pbit file to your local hard drive.
    • This file can be found in the Job Monitor Report folder that is created during the installation of Data Axcess Utility 2021-4.2a.
    • Example: “C:\Data Axcess Utility\Job Monitor Report”.
  4. Double click the DAU Job Monitor Report.pbit file.


Step 2: Data setup - [Return to Top]

Microsoft® Power BI® will now attempt to connect to the dau-dev-vm-03 database. This is the database used by the DAU development team when creating the Microsoft® Power BI® template file.
To connect the report to your own database, do the following:
  1. Click Cancel.
  2. Click Cancel.
  3. Click Close.
  4. Click File > Options and settings > Data source settings.
  5. Click Change source.
  6. Replace DAU-DEV-VM-O3 with the SQL server name used by DAU, and then click OK.
  7. Click Close.
  8. Click Refresh.
  9. When prompted, enter the username and password for your SQL Server.


Step 3: Save the report - [Return to Top]

  1. Click File > Save As.
  2. Choose a location and File name for your Microsoft® Power BI® file.
  3. Click Save.

Additional Information

N/A

  Solution Tools
  Attachments
 Solution Id 000186445/How-do-I-install-Data-Axcess-Utility-Job-Monitor-Report-in-CCH-Axcess-Data-Axcess-Utility
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!