Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Example: Set Up a Financial Executive Scorecard in AP&C

Example: Set Up a Financial Executive Scorecard in AP&C

This example illustrates how you can build a financial executive scorecard in Adaptive Planning and Consolidation (AP&C) to create snapshots of your organizations financial metrics for a fiscal period.
Teresa Serrano is Chief Financial Officer at Global Modern Services and wants to gain insight into important financial performance indicators for her company for July 2017.
Teresa talks with the Scorecard Administrator Norman Chan about developing a custom financial executive scorecard that displays these financial metrics for the consolidated company in Adaptive Planning and Consolidation:
  • Net income.
  • Revenue and spend per employee.
  • Financial ratios.
  • Financial operation metrics.
Ledger account summaries and company hierarchies are specific to your Workday tenant and might be different from the values suggested here.
  • Control access to ledger accounts and ledger account segments to all journals, including accounting and operational journals.
  • Security:
    • These domains in the System functional area:
      • Metric Management
      • Manage Metric Values
    • Management Dashboard: Financial Executive Scorecard
       domain in the Financial Management functional area.
    • Reports: Financial Accounting
       domain in the Financial Accounting functional area.
  • Enable custom scorecards.
    • On the
      Edit Tenant Setup - Reporting and Analytics
       task, select the
      Enable Scorecarding
       check box to enable custom scorecards.
  • Configure the financial executive scorecard and map aliases.
    1. Access the
      View Analytic Scorecard Profile
       report.
    2. From the
      Scorecard
       prompt, select
      Delivered
      ->
      Financial Executive Scorecard
      .
    3. Click
      OK
      .
    4. From the
      Financial Executive Scorecard
       profile, click the
      Metric Set Details
       profile group.
    5. Click
      Configure
      .
    6. Enter these field values:
      Field
      Value
      Inactive
      Unchecked
      Skip Review
      Unchecked
      Metric Calculation Scope
      Node including subordinates
      Top Level Node
      1CON Consolidation - Corporate
      Fiscal Schedule
      Standard Corporate Schedule
      Published Period
      2017 - Jun
      Metric Processing Period
      Workday automatically populates the next period of 2017 - Jul.
    7. Click
      OK
       and then click
      Done
      .
    8. Click
      Map Aliases
      .
    9. Map these aliases to your mapped tenant values:
      Business Object
      Standard Aliases
      Mapped Tenant Value
      Ledger Type
      _Actuals
      Actuals
      Ledger Account Summary
      _FIN_Scorecard_Cost_of_Sales
      Cost of Sales
      Ledger Account Summary
      _FIN_Scorecard_Current_Assets
      Current Assets
      Ledger Account Summary
      _FIN_Scorecard_Current_Liabilities
      Current Liabilities
      Ledger Account Summary
      _FIN_Scorecard_Total_Equity
      Total Equity
      Ledger Account Summary
      _FIN_Scorecard_Total_Expense
      Total Expense
      Ledger Account Summary
      _FIN_Scorecard_Total_Liabilities
      Total Liabilities
      Ledger Account Summary
      _FIN_Scorecard_Total_Revenue
      Total Revenue
      Account Translation Rule Set
      _FinAggAccountTranslationRuleSet
      Consolidations
      Custom Organization
      _Top_Level_Company_Hierarchy
      1CON Consolidation - Corporate
    10. Click
      OK
      and then click
      Done
      .
  • Initialize metric values.
    1. From the
      Financial Executive Scorecard
       profile, click the
      Process
       profile group.
    2. Click
      Initialize
      .
    3. Workday automatically populates these values:
      Field
      Value
      Metric Set
      Financial Executive Scorecard
      Period
      2017 - Jul
      Run Frequency
      Run Now
      Processing Type
      Process metric set for current period
    4. Check
      Confirm
      .
    5. Click
      OK
       and then click
      Done
      .
    6. Click the
      Process
       profile group to update the status.
      Workday initializes the metric values for the
      Financial Executive Scorecard
       and displays a notification when complete.
  • Calculate and review metric values.
    1. Click
      Calculate
      .
    2. Workday automatically populates these values:
      Field
      Value
      Metric Set
      Financial Executive Scorecard
      Period
      2017 - Jul
      Run Frequency
      Run Now
    3. Check
      Confirm
      .
    4. Click
      OK
       and then click
      Done
      .
      Workday calculates the metric values for the
      Financial Executive Scorecard
       and displays a notification when complete.
    5. Click
      Start Review
      .
    6. Workday automatically populates these values:
      Field
      Value
      Metric Set
      Financial Executive Scorecard
      Period
      2017 - Jul
      Run Frequency
      Run Now
    7. Check
      Confirm
      .
    8. Click
      OK
       and then click
      Done
      .
    9. Click the
      Process
       profile group to update the process
      Status
      .
      Workday reviews the metric values for the
      Financial Executive Scorecard
       and displays a notification when complete.
  • Publish metric values.
    1. Click
      Publish
      .
    2. Workday automatically populates these values:
      Field
      Value
      Metric Set
      Financial Executive Scorecard
      Period
      2017 - Jul
      Run Frequency
      Run Now
    3. Check
      Confirm
      .
    4. Click
      OK
       and then click
      Done
      .
    5. Click the
      Process
       profile group to update the process
      Status
      .
      Workday publishes the metric values for the
      Financial Executive Scorecard
       and displays a notification when complete.
  • Display the Financial Executive Scorecard in Worklets.
    1. From the
      Financial Executive Scorecard
       profile, click the
      Reports and Dashboards
       profile group.
    2. Click
      Maintain Dashboards
      .
    3. Locate the
      Financial Executive Scorecard
       you created.
    4. Click
      Edit
      .
    5. On the
      Dashboard Prompts
       tab, enter these values:
      Prompt Field
      Label for Prompt
      Default Type
      Default Value
      Metric Set
      Metric Set
      Specify Default Value
      Financial Executive Scorecard
      Metric Organization
      Metric Entity
      Specify Default Value
      1CON Consolidation - Corporate
      Metric Period
      Metric Period
      Specify Default Value
      2017 - Jul
    6. Click
      OK
      .
    7. On the
      Required Worklets
       tab, add these Financial Executive Scorecard worklets to the grid:
      Field
      Value
      Worklet
      • Financial Executive Scorecard - Net Income
      • Financial Executive Scorecard - Revenue per Employee
      • Financial Executive Scorecard - Operations
      • Financial Executive Scorecard - Financial Ratios
      • Financial Executive Scorecard - Spend per Employee
      Worklet Size
      1x (for all worklets)
    8. Click
      OK
       and then click
      Done
      .
    9. Click
      Done
      .
  • Configure the home page to display the Financial Executive Scorecard.
    1. From your Home page, click the
      Configure Applications (gear)
       icon to display the
      Configure Worklets
       page.
    2. Under
      Optional Worklets
      , add a row and select the
      Financial Executive Scorecard
      worklet.
    3. Click
      OK
       and then click
      Done
      .
      Workday displays the Financial Executive Scorecard on your home page.
    4. Click to open the Financial Executive Scorecard.
Workday displays these Financial Executive Scorecard worklets in the KPI card layout:
  • Net Income.
  • Financial ratios.
  • Revenue and spend per employee.
  • Financial operation metrics.