Concept: The Financial Reporting Data Model in AP&C
The financial reporting data model in Adaptive Planning and Consolidation (AP&C) 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 | The scenarios used for comparison: Journal Line or Plan Lines. |
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 default status of Posted because there’s no journal status for plan lines.
- Journal Source: Plan lines have a blank status and appear under Journal Source (Uncategorized/Blanks) because there are no journal sources for plan lines.
- Match Status: Plan lines have a match status of Not Matched and can't be changed.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.