Concept: The Financial Reporting Data Model
The financial reporting data model is a curated subset of components selected from the Workday financial data model (FDM). The reporting data model determines which information from the FDM, such as which company hierarchies, ledger account hierarchies, and dimensions, is available for analyzing and reporting on in OfficeConnect.
When you set up the financial reporting data model, Workday creates the financial modeled data source that you can access from OfficeConnect.
When you sign in to Workday from OfficeConnect using the financial data source, OfficeConnect displays most of the information in the reporting data model in the Elements tab. You can drag and drop individual elements, such as a company or ledger account, from the Elements tab into the worksheet.
OfficeConnect summarizes the data in your Workday ledger accounts as determined by the intersection of the elements you place in the worksheet.
The financial reporting data model includes these elements:
Model Elements | Description |
|---|---|
Company | The primary top-level company hierarchy you can report on.
One or more alternate company hierarchies you can report on. |
Ledger Accounts | The primary account top-level hierarchy you can report on. One or more alternate ledger account hierarchies you can report on. |
Time | The three-tier time hierarchy defined in the reporting data model. Typically, the hierarchy goes from year to quarter to month/period:
Example: FY2021 > Quarter > Month |
Currency | Defines:
|
Versions | Determines what data displays in OfficeConnect reports. You can use other elements to further filter the data in that version. You can use versions as scenarios for comparison. We include these versions by default in the reporting model:
You can also configure the Accounting Center Journals version and other custom versions to include Prism ledger-like data. Before configuring these versions, you must set up the Prism data sources and create field mappings from the data source to the reporting model. See:
|
Effective Date | The default effective date that determines the dimension hierarchies and values in your model elements (prepopulated dynamic and static dates, or custom dates defined by an administrator). |
Dimensions | The list of optional dimensions, such as worktags and organizations, that you can use to group and filter the data.
For hierarchical dimensions, a primary top-level hierarchy and optionally one or more alternate hierarchies. Required dimensions don't count toward your maximum number of dimensions that can have alternate hierarchies. |
Show Details | The contributing journal line, plan line, and transaction details that users can view for a data point. |
The financial reporting data model:
- Includes aggregated data at the ledger account level.
- Summarizes the amount field 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. You can't change the amount field at the row, column, or cell level.
- Specifies a default translation rule set to use for currency translation. You can select a different translation rule set by applying a filter to the worksheet or workbook. You can't change the translation rule set at the row, column, or cell level.
- Includes these amount types:
- Ending Balance (default)
- Beginning Balance
- Beginning Balance Translation Adjustment
- Adjusted Beginning Balance
- Activity
- Displays intercompany eliminations in OfficeConnect at the lowest common parent level.
Considerations for Plan Lines
When working with plan lines, keep these considerations in mind:
- Only Workday Financial Plan Lines are supported.
- You can’t disable the currency translation adjustment (CTA) account, which might affect your partial balance sheet plans.
- Revisit the dimensions selected for the model to ensure that the selected plan structure dimensions are also in the model, or add them.Example: If a plan uses Cost Center as its dimension, the model doesn't require that specific dimension to be present. For reporting purposes, you need to add the same dimensions to the model so that they’re available in reports.
- When applying a plan version in a report, specify the company (or companies) and time periods for the report.Example: Even if a plan name says 2012 Company A Plan, the time period for 2012 and Company A aren't automatically applied and should be applied to the row, column, cell, or worksheet filter.
- When using dimensions for plan lines that are intended only for journal lines:
- Journal Status: Plan lines have a blank status and display under Journal Status (Uncategorized/Blanks) because there is no journal status for plan lines.
- Journal Source: Plan lines have a blank source and display under Journal Source (Uncategorized/Blanks) because there is no journal source for plan lines.
- Match Status: Plan lines have a blank status and display under Match Status (Uncategorized/Blanks) because there is no match status for plan lines.These fields can’t be ignored for plan lines because the same summarized Plan Value would be applied for every instance of Journal Status.
- You can now include a new dimension called Plan Entry Document Status in the financial reporting data model to filter on the financial plan line status explicitly (Available, Draft, In Progress). Otherwise, all available Plan Entry Document Statuses are included.
- If your plan is at a higher summary level than period, OfficeConnect uses the last period for any activity on that plan and the last period's end date to match up with its translation exchange rate.Example: If your plan is at the quarterly level for Q3 (Jul-Sep), the plan amount registers activity in September and uses the September 30 end date for the currency translation exchange rate. A similar impact would apply to a plan amount meant to cover an entire year.
- All plan amounts entered in Workday Budgets are considered as period activity (plan amount for a specific time period). If you enter plan ending balances as plan amounts, use the Amount Type of "Activity" when reporting on ending balances for these plans.