The Datawarehouse Reports section displays any available Datawarehouse-related reports in iSite.  


Availability

Users with the following permissions can access Datawarehouse Reports:



Individual reports may have additional permissions that are required for viewing.


Navigation

Reports > Standard Reports > Datawarehouse


Reports Directory

The Reports Directory displays each of the available reports:


  • Actuals Summary by Account Code
    • Displays a list of Account Codes for a specific Financial Month, summarized by Dollars and Hours.
  • Import Table Counts
    • Displays a list of each table which can have data imported along with record counts.
  • Lookup Table Exceptions
    • Displays a list of orphaned Lookup Table codes in Transaction tables that don't have corresponding values in Lookup tables.
  • Unmapped Account Codes
    • Displays a list of Account Codes that are not mapped to a Virtual Account.
  • Virtual Account Mappings
    • Displays a list of Virtual Accounts along with the Account Codes mapped to each Virtual Account.

Page ID:1655-6928-9489