NO.17 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?

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

NO.19 What is required to use version management in a story?

NO.20 You are creating a data action to copy data from one year to the next.In the parameter for the source year, which default setting must you change?

NO.21 What can you use to perform cell-based calculations in a story?

NO.22 In which types of data source can you concatenate data? Note: There are 3 correct answers to this question.

NO.23 You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.

NO.24 You are creating a script for an advanced data action. Which character designates a virtual variable member?

NO.25 Your story takes a long time to open. What could cause this? Note: There are 3 correct answers to this question.

NO.26 What source system can you connect to with a live connection?

NO.27 To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question.

NO.28 Which automatically created dimension type can you delete from an analytic data model?

NO.29 You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.

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

NO.31 Where can you change a data lock status? Note: There are 2 correct answers to this question.