Record Count Overview KPIs

The KPIs on the Record Count Overview dashboard use measures from domain-specific fact tables.

Sales

Description: These KPIs show the record count of each fact table within the Sales domain.

Measure:
  • No. of Lines (Sales Orders)
  • No. of Lines (Sales Analysis)
  • No. of Delivery Lines (Delivery Lines)
  • No. of Lines (Delivery Performance)
  • No of Records_Sales Budget (Sales Budget)
  • No. of Lines (White Space)

Finance

Description: These KPIs show the record count of each fact table within the Finance domain.

Measure:
  • No. of FKR Records (Finance Key Ratio)
  • No. of Transactions (General Ledger)
  • No. of Invoices (AP Operational Metrics)
  • No. of Invc Journal Entries (AP Ledger)
  • No. of AR Balance Records (AR Balance)
  • No. of Invc Journal Entries (AR Ledger)
  • No. of AR Invoices Records (AR Invoices)
  • No. of Records (Stock Valuation)

Procurement

Description: These KPIs show the record count of each fact table within the Procurement domain.

Measure:
  • No. of Orders (Purchase Orders)
  • No. of Lines (Procurement Analysis)

Production

Description: These KPIs show the record count of each fact table within the Production domain.

Measure:
  • No. of Orders (MO Headers)
  • No. of Operations (MO Operations)
  • No of Records (MO Operation Transaction)
  • No. of Records (Order Costing Headers)
  • No. of Material Components (Material Components)
  • No. of Operation Components (Operation Components)
  • No. of Product Costs (Product Costs)
  • No. of Semi-Finished Materials (Semi-Finished Materials)
  • No. of Records (Work Center Capacity)

Warehouse

Description: These KPIs show the record count of each fact table within the Warehouse domain.

Measure:
  • No. of Records (Stock Balance)
  • No. of Records (Stock Statistics)
  • No. of Stock Transactions (Stock Transactions)

Rental

Description: These KPIs show the record count of each fact table within the Rental domain. It is only available in the Distribution and Equipment industries.

Measure: No. of Records (Rental Utilization)

Equipment

Description: These KPIs show the record count of each fact table within the Equipment domain. It is only available in the Equipment industry.

Measure:
  • No. of Records (Technician Capacity)
  • No. of Work Orders (WO Headers)
  • No. of Operations (WO Operation)
  • No. of Records (WO Operation Transactions)
  • No. of Records (Warranty Claims)
  • No. of Claims (Warranty Processing)

Opportunity Management

Description: These KPIs show the record count of each fact table within the Opportunity Management domain.

Measure:
  • No. of Records (Account)
  • No. of Activities (Activity)
  • No. of Campaign (Campaign)
  • No. of Opportunities (Opportunity)
Note: The Account KPI shows the total number of accounts including accounts belonging to multiple business areas. The value displayed differs from the total value displayed in the No. of Created Accounts KPI in the Sales Teams Performance dashboard. This is because the No. of Created Accounts KPI uses the Count aggregation.