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?
Correct Answer: C
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.
Question 17
You are building a model for Travel Expenses. Finance needs to see detailed travel plans, and expenses will be included with corporate reporting. Planners are expected to complete their travel plans for each forecast. What model design should you use?
Correct Answer: A
A modeled sheet is the appropriate design for detailed travel expense planning because it is architected to capture granular, row-level data where each row represents a discrete planning record - in this case, an individual trip. Modeled sheets support custom columns (accounts) such as destination, travel dates, estimated cost, level assignment, and dimension values, enabling planners to build detailed itinerary-level budgets. The data aggregates upward to summary levels for inclusion in corporate reporting. This meets both requirements: detailed planning visibility for Finance and individual planner completion per forecast cycle. A standard sheet captures aggregate monthly amounts by level but lacks the row-level granularity needed for trip-by-trip detail. A standard sheet with a historical formula is a top-down estimation approach, not a detailed planning model. A cube sheet with assumption-based calculation is a statistical model, not a detailed record-level capture. The modeled sheet's row-based architecture is specifically designed for this class of detailed operational planning. Reference: Workday Adaptive Planning - Modeled Sheets, Sheet Design Patterns, Travel Planning Use Case.
Question 18
You are creating a report in OfficeConnect with dates as the column headers. You want the dates to automatically reflect changes from the Adaptive Planning model. What tool do you use?
Correct Answer: D
In Workday Adaptive Planning OfficeConnect, the Labels feature is used to create dynamic column headers that automatically reflect date and time period information from the Adaptive Planning model. Labels dynamically pull the period names, version names, or other descriptive text from the model, ensuring that when the model's time periods are updated, renamed, or the calendar is rolled forward, the column headers in the OfficeConnect report update automatically without manual intervention. This eliminates the maintenance burden of manually updating report headers when planning periods change. Parameters are used to enable interactive selection of versions, levels, or scenarios when running a report. Absolute time elements hardcode specific time references and do not dynamically update. Display options control formatting and presentation settings but do not govern dynamic header text. Labels is the specific OfficeConnect functionality designed for dynamic, model-synchronized column headers, ensuring reports remain current as the Adaptive Planning instance evolves. Reference: Workday Adaptive Planning - OfficeConnect, Labels, Dynamic Report Headers, Time Period Synchronization.
Question 19
You are building a Headcount cube sheet for a manufacturing company. Plant managers input headcounts across dozens of levels and multiple job profile dimension values for each month. Job profile salaries are standardized and global for an entire year. What design for assumptions would have minimal inputs and segregated security?
Correct Answer: C
The optimal design for this scenario is a separate cube sheet configured with the Job Profile dimension, where salaries are entered once at the Top Level (eliminating level-by-level duplication) at the Year time stratum (since salaries are standardized annually). This architecture achieves minimal inputs by requiring HR managers to enter each job profile salary only once per year at the top level, which is then referenced universally across all levels. Segregated security is achieved by controlling access to this separate salary assumption sheet independently from the plant managers' headcount input sheet - plant managers only access the headcount cube sheet while HR managers exclusively access the salary cube sheet. Combining salary and headcount input on the same sheet (Option A) eliminates security segregation. A Personnel sheet with calculated averages (Option B) adds complexity without addressing input minimization. Assumption accounts per job profile (Option D) would require separate accounts for potentially dozens of job profiles, creating an unmaintainable account structure. Reference: Workday Adaptive Planning - Cube Sheet Design, Top Level Entry, Year Stratum, Security Architecture.
Question 20
Scenario: A financial planner is conducting a comprehensive audit of the income statement structure and formulas. The goal is to ensure accuracy, consistency, and optimal performance for the upcoming budget cycle. The General Ledger account 5010 (Labor) in the Budget version currently uses a formula that calculates labor costs as 6% of the Income account value within the same time period. The current formula is limited to the Manufacturing and Sales levels and does not apply to other versions. Which configuration would enable the Labor cost calculation to apply consistently across all levels and all versions?
Correct Answer: A
In Workday Adaptive Planning, a Default formula is the configuration that enables a formula defined on an account to apply universally across all levels and all versions simultaneously. When a Default formula is set on an account such as Labor (5010), the formula - in this case, 6% of the Income account value - becomes the baseline calculation for every level in the hierarchy and every version in the instance, unless a level-specific or version-specific override is explicitly defined. This is the precise mechanism for ensuring consistent, model-wide formula application without duplicating formula entries across individual levels or versions. A Shared formula also propagates formulas across levels but operates within specific version contexts and requires explicit sharing configuration. A Metric account is used for KPI display and is read-only by nature, not suitable for labor cost planning. A Modeled calculated account applies to row-based modeled sheet structures, not standard GL account formula propagation. The Default formula is the correct and official Adaptive Planning feature for establishing universal cross-level, cross-version formula consistency on GL accounts. Reference: Workday Adaptive Planning - Default Formulas, Account Formula Types, Formula Scope Configuration.