Data Quality - Financials report

Applies to: Costing Standard 11.8.x running on either TBM Studio v12 or TBM Studio v11.

Introduction

The Financials report focuses on the unallocated costs.

Navigation

Data Quality > Financials

Roles

This report is designed for TBM administrators.

Objectives

Use this report to analyze the allocations for the financials layer of the cost model shown below. The report focuses on the Cost Source data set and the specific records that are not flowing up the model.

Specific objectives include the following:

  • Quickly see unallocated costs from the financial layer.
  • Assess unallocated cost trends over time by IT Financial model objects.
  • Identify unallocated costs by IT Financial model objects.
  • Review allocation strategies for the IT Financial objects in the model (e.g. Cost Source, Labor, Fixed Assets, etc.).

Questions answered

The information presented on this report can be used to answer the following questions:

  • Which specific records are not being allocated to one of the destination objects (Labor, Fixed Assets, etc.)?
  • Can I see any patterns that might identify the error?
  • Are all the important fields which drive my allocations complete and valid?

Next actions

  • Export specific records to review and fix.
  • Adjust or correct allocation rules in Studio.
  • Correct data in the source data or through data transforms in Data Studio.