Online Access Free C-SAC-2501 Exam Questions

You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?

• A.Group the Firstname and Lastname in the data model.
• B.Create a calculated dimension in the data model.
• C.Create the combined data in the source system.
• D.Create a calculated dimension in the story.

What must you use to transform data in a dataset using if/then/else logic?

• A.Custom expression editor
• B.Calculations editor
• C.Transform bar
• D.Formula bar

How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question.

• A.Select fluid data entry mode in the story.
• B.Enable unbooked data in the story.
• C.Enable Optimize Recommended Planning Area in the model.
• D.Set Size Limits for Planning Performance in the model.

You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. How can you do this?

• A.Dis-able allocations
• B.Use two properties
• C.Use two hierarchies
• D.Dis-able distribution

When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question.

• A.Enable Keeping member names visible
• B.Freeze Up to column
• C.Freeze Up to row
• D.Enable Auto-Size And Page Table Vertically