Free Workday Workday-Adaptive-Planning Exam Dumps Questions & Answers

You are building a Sales cube sheet that plans by Product dimension. It references another cube sheet for assumption values by Product. You write a formula: ACCT.Sales.Units * ACCT.Lookups.Rate[Level=TopLevel(-)]. When you test the formula, your results are significantly higher than expected. What is the corrected formula?

• A.ACCT.Sales.Units * ACCT.Lookups.Rate[Level=TopLevel(-), Product=this]
• B.ACCT.Sales.Units * ACCT.Lookups.Rate
• C.ACCT.Sales.Units[Level=TopLevel(-)] * ACCT.Lookups.Rate[Level=TopLevel(-)]
• D.ACCT.Sales.Units[Product=this] * ACCT.Lookups.Rate[Level=TopLevel(-)]

What action creates an (Only) level?

• A.Creating a formula on a level.
• B.Importing data to a parent level.
• C.Creating multiple versions.
• D.Adding children under a level to create a rollup.

What is a required step when creating a standard sheet?

• A.Customize each level's access to individual accounts
• B.Add custom dimensions
• C.Choose to make all accounts read-only for all levels
• D.Add accounts to a group

An OPEX model uses headcount data linked from a personnel sheet. When testing with sample data, all expense results appear in the location dimension value of 'Uncategorized.' What corrections need to be made to populate the location values?

• A.The OPEX formulas need to have Data Privacy set to 'Public at all levels.'
• B.The personnel sheet needs to be planned with the location dimension.
• C.The personnel sheet needs modeled accounts for each location.
• D.The OPEX formulas need term modifiers for location.

What does a grey cell background in a standard sheet indicate?

• A.The cell is read-only and might contain a value or formula.
• B.The cell contains a rollup account or time dimension.
• C.The cell contains an error.
• D.The cell is editable.