Data Management Reports

The standard Data Management report groups are described below. For information on the subcategories of each report, see Data Management Detail Reports.


Image shows Base Trial Balance Report

Table 6-1 Report Groups and Descriptions

Report Group Description
Audit Reports An audit report displays all transactions for all locations that comprise the balance of a target account. The data returned in these reports depends on the location security assigned to the user.

The subcategories of the Audit Reports:

  • Account Chase

  • Account Chase with Wildcards

  • Map Monitor for Location

  • Map Monitor for User

  • Intersection Drill Down

Note:

The Map Monitor reports do not capture historical data earlier than release 11.1.2.4.100.

Map Monitor reports are enabled only if the Enable Map Audit is set to "Yes" in System Settings.

Base Trial Balance Reports The base Trial Balance reports represent account balance source data in a General Ledger system. You use a base Trial Balance report to validate and compare balances as data is loaded from the source system to the target applications.

The subcategories of base Trial Balance reports:

  • Trial Balance Location, With Targets (Cat, Per)

  • Trial Balance Current Location, With Rules (Cat, Per)

  • Trial Balance Current Location, All Dimensions-Target Entity-Acct (Cat, Per)

  • Trial Balance Converted Current Location, By Target Entity-Acct (Cat, Per)

  • Trial Balance Current Location, with Target Entity-Acct (Cat, Per)

  • Trial Balance Current Location, All Dimension-Targets (Cat, Per)

  • Trial Balance Current Location, by Target Acct (Cat, Per)

Check Reports Check reports provide information on the issues encountered when data load rules are run. Check reports return target system values that include aggregation or calculations from the target system.

The subcategories of Check reports:

  • Check Report—Displays the results of the validation rules for the current location (pass or fail status).

  • Check Report Period Range (Cat, Start per, End per)—Displays the results of the validation rules for a category and selected periods.

  • Check Report by Validation Entity Sequence—Displays the results of the validation rules for the current location (pass or fail status); sorted by the sequence defined in the validation entity group.

  • Check Report with Warnings—Displays the results of the validation rules for the current location. Warnings are recorded in validation rules and shown if warning criteria are met. This report does not show rules that passed the validation.

Check Reports are not available in the Financial Consolidation and Close.

Listing Reports

Listing reports summarize metadata and settings (such as the import format, or check rule) by the current location.

Listing reports summarize data and settings (such as the import format, or check rule) by the current location.

The subcategories of Listing reports:

  • Import Format by Location

  • Location Listing

Location Analysis Reports Location Analysis reports provide dimension mapping and system log information by the current location.

The subcategories of Location Analysis reports:

  • Dimension Map for POV (Dimension, Cat, Per)

  • Dimension Map (Dimension)

Process Monitor Reports A Process Monitor report displays, for the current report, a list of locations and their positions within the data conversion process. You can use the process monitor report to monitor the status of the closing processes. The report is time-stamped. Therefore, it can be used to determine to which locations and at which time data was loaded.

The subcategories of Process Monitor reports:

  • Process Monitor (Cat, Per)

  • Process Monitor All Categories (Cat, Per)

  • Process Status Period Range (Cat, Start Period, End Period)

Variance Reports A Variance report displays source/trial balance accounts for one target account, showing over two periods or categories.

The subcategories of Variance reports:

  • Account Chase Variance (Target Account, Cat1, Per1, Cat2, Per2)

  • Trial Balance Variance (Cat1, Per1, Cat2, Per2)