You need to structure a model to support both planning and reporting of expenses by project, while classifying each project by its funding source. How do you structure the model to meet these requirements?
A.
Create new accounts in the chart of accounts for each project and funding source combination to track expenses.
B.
Use calculated accounts on a standard sheet to derive expenses by project and funding source.
C.
Create a new dimension for Project and an attribute for Funding Source, then apply the dimension and attribute to relevant expense accounts or sheets.
D.
Restructure the level hierarchy to include each project as a child level under the relevant department to track expenses by project.
Workday Adaptive Planning's dimensional planning architecture is specifically designed to address the requirement of tracking expenses across multiple analytical axes (projects and funding sources) without proliferating accounts or restructuring the level hierarchy. The correct approach is to create a Project dimension — which enables data entry, planning, and reporting by individual project across shared accounts — and a Funding Source attribute tied to the dimension to classify each project by its funding category. Dimensions are applied to relevant expense accounts or sheets, enabling planners to enter data at the intersection of account, level, time, and project dimension. Attributes on dimensions serve as metadata for grouping and filtering in reports. Creating separate accounts per project-funding combination violates the single account principle and creates an unmaintainable account structure. Restructuring levels for projects conflates organizational hierarchy with project tracking. Calculated accounts on standard sheets cannot capture the row-level detail needed for project planning. Reference: Workday Adaptive Planning — Dimensions, Dimension Attributes, Dimensional Planning Architecture.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit