Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Set Up the Financial Reporting Data Model in AP&C

Set Up the Financial Reporting Data Model in AP&C

Security:
Set Up: Financial Reporting and Analytics Data Model
 domain in the System functional area.
Set up the financial reporting data model in Adaptive Planning and Consolidation (AP&C) before you sign in to Workday in OfficeConnect. By defining the reporting data model, you're curating the Workday Financials data model (FDM), so that you only expose the components of the FDM needed for reporting. When you set up the financial data model, Workday creates the financial modeled data source.
  1. Access the
    Set Up Financial Reporting and Analytics Data Model
     task.
  2. As you complete this task, consider:
    Option Description
    Company
    Select the primary top-level hierarchy for the company to report on.
    The company you select determines the
    Account Set
     value and the
    Fiscal Schedule
     value.
    In the
    Alternate Company Hierarchies
     field, optionally select one or more additional company hierarchies to use.
    Ledger Accounts
    Select the top-level hierarchy that includes the accounts to report on and analyze.
    The company you select determines the
    Account Set
     value.
    In the
    Alternate Account Top-Level Hierarchies
     field, optionally select one or more additional ledger account hierarchies to use.
    The
    Default Amount Field
     is summarized by ledger debit minus credit. When creating a report in OfficeConnect, you can select a different amount field, such as Natural Amount, by applying a filter to the worksheet or workbook.
    Time
    Select a Fiscal Summary Schedule that represents a time period in the selected Fiscal Schedule that's between year and the posting interval period, such as quarter.
    Workday creates a three-tier time hierarchy in the reporting data model that goes from year (based on Fiscal Schedule) to the selected Fiscal Summary Schedule to the posting interval period.
    Example: FY2021 > Quarter > Month
    The company hierarchy that you select determines the Fiscal Schedule value.
    Currency
    Select the default currency to use when reporting on the Corporate currency or any company hierarchy level.
    When reporting on a single company, Workday uses the ledger currency for that company by default.
    Select the
    Default Translation Rule Set
     that defines the translation method to apply based on ledger account type when Workday performs currency translation. In OfficeConnect, you can select a different translation rule set by applying a filter to the worksheet or workbook.
    Versions
    Journal lines and plan lines are selected by default. To report on plan lines, you must select the financial plan structures.
    You can select from a limited number of plans.
    Effective Date
    Select the default effective date that determines the dimension hierarchies and values in your model elements. The date can be:
    • Dynamic. Select a date relative to the current date (or the current date itself).
      Example: Prior Period End Date. If the period is monthly and the current date is April 5, 2022, then the effective date is March 31, 2022. If the period is monthly and the current date is May 5, 2022, then the effective date is April 30, 2022.
    • Static. Commonly used static dates that the system populates. These dates are auto-generated based on the model's selected fiscal schedule and summary schedule. The list updates automatically over time.
      Example: The date of the end of each interval posting period for the past 12 months.
    • Custom: Define custom dates that represent something specific to the company. These dates are available for selection indefinitely.
      Example: An org change that occurred on
      mm/dd/yyyy
      .
    A change in the date applies to all users of the model.
    OfficeConnect displays the effective date as a label under Labels > Model > Model Effective Date so that users know which effective date is used.
    Dimensions
    Select the optional dimensions, such as worktags and organizations, to drill down into the data. If you add a hierarchical dimension, select a hierarchy to use. If you don't specify a hierarchy, Workday includes the values as a flat list.
    The dimensions you select determine how report creators can filter and group the data.
    In
    Alternate Top-Level Hierarchies
    , optionally select one or more additional hierarchies to use. You have to select a primary hierarchy before you can add alternate hierarchies.
    Show Details
    Manage the journal and plan line details users can view for a report cell when they click
    Show Details
     for deeper analysis. You can:
    • Delete any optional fields.
    • Search for and add fields.
    • Reorder the fields to change the display and sort order.
    If you don't change anything,
    Show Details
     displays the default set of fields from OfficeConnect reports.
    The number of fields you configure to display in the OfficeConnect worksheet impacts performance. A large number of rows and columns creates larger and slower reports.
Workday creates the financial modeled data source using the components you defined in the financial reporting data model. You can use this modeled data source when you sign in to Workday from OfficeConnect.