Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Configure the Reporting Model for Accounting Center Journals

Example: Configure the Reporting Model for Accounting Center Journals

This example illustrates how you can configure the Workday-provided Accounting Center Journals version in the reporting model to enable reporting on it in OfficeConnect.
You want to enable your end users to report on Accounting Center detailed data in OfficeConnect using the Workday-provided Accounting Center Journals version. They can report on this data using either actual dimensions or drill to it using the Show Details option.
After understanding the core use cases for your business, you:
  • Select the correct Prism data source that aligns with the existing company structure and account hierarchies in the reporting model.
    Example:
    • The ledger accounts belong to the same account set and account hierarchies defined in the reporting model.
    • The companies and the detailed accounting data sets roll up to the company hierarchies defined in the reporting model.
  • Create a field mapping of the data source to the reporting model. You must map all the required ledger-like fields from the data source.
  • Configure the reporting model to include the data source field mapping.
  • Use OfficeConnect to test that you can report on the Accounting Center detailed data.
You can map a data source to the reporting model only once. Later, if you make changes to the data source or if you delete it, it can impact your field mapping and cause errors in OfficeConnect.
  • The Prism data source:
    • Exists for the data you want to report on.
    • Is enabled for analysis.
    • Has the required fields.
  • The ledger accounts and company hierarchies in the Prism data source and in the reporting model match. See Set Up the Financial Reporting Data Model.
  • You have access to these tasks:
    • Set Up Reporting Model
    • Field Mapping for Reporting Model
    • Create Custom Version
  1. In Workday, access the
    Create Field Mapping for Reporting Model
     task.
  2. Select the reporting model type and search for the data source that you identified for the business. Click OK.
  3. In the
    Required
    tab, map all the ledger-like fields. Complete the task:
    Option Description
    Mapping Type
    • Select
      Source Field
       to select a source field directly from your data source.
    • Select
      Specified Value
       to specify a value that is constant.
    Source
    Based on your mapping type, either select a source field or manually enter a value.
    Version
    To map to the Version target field:
    1. In the
      Mapping Type
       field, select
      Specified Value
      .
    2. In the
      Source
      field, select
      Accounting Center Journals
       .
  4. After mapping all required fields, click
    OK
    .
  5. (Optional) In the
    Optional
    tab, map any additional fields that you want to configure as dimensions or for Show Details in the reporting model.
    Example: Cost centers, revenue categories, spend categories, regions.
  6. (Optional) If there aren’t any optional fields available to map your source fields that you want to report on, you can create custom fields:
    1. In the
      Custom
      tab, click the plus icon to add a row.
    2. In
      Source
      , select the source field you want to create a custom field for.
    3. In
      Target
      , select
      Create Custom Field
       and give it a name.
    4. Click
      OK
      .
  7. Review your field mappings to make sure you mapped everything correctly:
    1. In the
      Required
       tab, use the
      Target
      field to filter on a field name to see what it's mapped to.
    2. If you missed mapping any fields, access the
      Edit Field Mapping for Reporting Model
       task. Select your existing field mapping and click
      OK
      . The field mapping inherits its name from the data source name.
  8. Access the
    Set Up Reporting Model
     task.
  9. Select an existing reporting model for edit or create a reporting model.
    Example: ACC Data for Financials Reporting data model.
  10. Click
    OK.
  11. Scroll to the
    Versions
    section. Add a new row for the
    Accounting Center Journals
     version. Select the applicable field mapping for it.
    Example: OCFR_DTL_TBL_DetailedAccounting_For_Reporting.
  12. Scroll to the
    Dimensions
    section and configure additional Accounting Center attributes as dimensions.
  13. Scroll to the
    Show Details
     section. Click
    Add
    to add the new Accounting Center Journals version and configure Show Details fields specifically for this version. You can also configure the order and sorting for these fields.
  14. Click
    OK
    .
  15. Sign in to OfficeConnect using Workday SSO.
  16. Create or a test report in OfficeConnect using these elements:
    1. Add these GL accounts accounts to the rows: Assets and Liabilities and Equities.
    2. Add these versions to the columns: Actuals and Accounting Center Journals.
  17. Refresh the report and can compare the data in the report for the 2 versions.
  18. Select an intersection and click
    Show Details
     to drill into Accounting Center detail attributes.