Concept: OfficeConnect and Reporting on the Financial Modeled Data Source in AP&C
You can use the OfficeConnect and financial model data source in Adaptive Planning and Consolidation (AP&C) to query Workday Financial Management data directly, enabling easy, performant, reporting.
OfficeConnect is a Microsoft Excel add-in that enables you to create reports in Excel using financial data in Workday from the financial model data source. With OfficeConnect, you can create financial reports using the Excel interface you’re familiar with, using data backed by Workday, such as journal lines.
OfficeConnect updates the data when you run or refresh your report in real time. These reports are based on model elements like ledger accounts, time period, and worktags.
You might want to use OfficeConnect to perform ad hoc analysis on journal line data.
When creating and editing a report, you can:
- Use formatting capabilities of Excel.
- Use cell formulas and calculations of Excel.
- Expand and collapse hierarchies in the data model.
- Filter Workday data.
Example: You can use OfficeConnect for Financial Reporting to:
- Create an income statement.
- Create a balance sheet.
- Perform ad hoc dimension analysis.
- Perform salary and benefit analysis.
- Calculate product and customer margin.
Workday supports OfficeConnect only on Windows operating systems.