v26.04: Control Reporting by Status

The Control Reporting by Status feature enables financial users to validate the integrity, accuracy, and compliance of their data submissions prior to final reporting. Instead of exposing users to a raw and potentially overwhelming list of validation errors, this feature transforms control results into a structured, actionable diagnostic dashboard.

By organizing thousands of validation checks into logical hierarchies and exposing detailed calculation logic—including formulas, input variables, and comparison thresholds—users can efficiently identify root causes, reduce troubleshooting time, and ensure high‑quality financial reporting.

Key Benefits

• Centralized Validation

  Aggregate all system validation checks—Integrity, Intercompany, Budget, and Consistency—into a single, unified reporting view.

• Root Cause Analysis

  Move beyond basic error messaging by exposing the precise mathematical formula, input variable values, and comparison rules that triggered each control status.

• Navigation Efficiency

  Leverage hierarchical grouping (via Control Sets) and multi‑dimensional filtering (for example, Entity, Account, and Flow) to help users efficiently navigate large volumes of data and focus on critical blocking issues.

• Logic Transparency

  Clearly separate:

  • Calculation logic (Formula)

  • Comparison rule (Comparer and Threshold)

    This distinction enables users to determine whether failures are caused by missing data, calculation mismatches, or tolerance breaches.

Impact Areas

This functionality replaces the existing hover‑based behavior when navigating Level 2 headers in the following components:

• Board
• Snippet
• Sheet

Control Report Details

Status Tabs

The control report is organized into four status‑based tabs, allowing users to quickly adjust their focus:

• All
• Valid
• Error
• Warning

Hierarchical Control Navigation

The hierarchical structure allows users to distinguish between high‑level control results and detailed data‑level failures with minimal effort.

Level 0 – Section Header (Control Group)

• Displays a fixed, full‑width grey header representing the Control Group (for example, L10 – Integrity Checks).
• Shown when controls belong to a defined Control Set.

Level 1 – Control Header

• Aggregates records by Control Name (for example, Balance Equilibrium).
• Displays a summary of status counts (such as 1 Error, 2 Warnings).
• Rows are fully expandable and collapsible.

Level 2 – Data Rows

• Expanding a Control Header reveals the underlying data rows.
• Column headers (Status, Version, Time, Entity, Account, etc.) appear only when expanded.
• The Explore action behaves the same as clicking an individual control metric in the existing popup, but the context is scoped precisely to the selected row.
• All dimensions required by the Control Metric are displayed.
  • Dimensions not applicable to the Level 1 control metric appear as blank.

Export Behavior

Export to CSV includes all visible data across Level 0, Level 1, and Level 2.

Fallback Grouping

Controls not associated with a Control Set are grouped under a generic section (for example, Other Controls), or displayed without a section header while maintaining grouping by Control Name.

Detailed Calculation Logic and Comparison Rules

To support efficient troubleshooting, users can inspect the exact logic driving each control result.

Drill‑Down Interaction

Clicking a Level 2 data row expands a detail panel directly beneath the row.

Formula

A dedicated section displaying the mathematical formula used to evaluate the control.

This formula is derived from the Metric formula with the following rules applied:

• Any text enclosed in [] is removed.
• If an input metric has an alias, the alias name is used instead of SheetName.MetricName.

Comparison Rule

A dedicated section describing how the calculated result is evaluated:

• Comparer Type

  Examples include Equal To, Less Than, Greater Than, Between, and Not Between.

• Threshold
  • Displayed as a single value (for example, 100 or 5%), or
  • Displayed as a range for Between / Not Between comparers (for example, From 0 to 100).

Variables

• Lists all input variables used in the formula.
• Columns mirror the Input Columns defined on the Metric page.
• The number of columns is dynamic, based on the number of inputs.
• Label logic:
  • Use the Alias name if defined.
  • Otherwise, use SheetName.MetricName.

Validation Message

Displays the configured Control Message, providing business context for the validation result.

Filtering and Search

Multi‑Dimensional Filtering

Users can narrow down the control report to focus on issues relevant to their area of responsibility.

• Filters are available for all dimensions present in the report.
• By default, the system displays filters for Scenario and Time.
• Additional dimensions can be added using the Add Filter (+) action.
• Filter dropdowns include a search bar for quick value selection.
• Filter values are limited to members currently visible in the report (consistent with column header filtering behavior).

Global Search

Filters results by matching text across:

• Control Set
• Control Metric Name
• Control Message

Empty State

When filters return no records, the report displays:

• A "No records found" message
• A “Clear all filters” action for quick recovery