Unit 2: Planning in stories

Question 1

In SAP Analytics Cloud, what are versions primarily used for?

A. Storing historical data
B. Organising different user access levels
C. Organising, comparing, and maintaining actual, plan, and forecast data
D. Tracking software updates

Answer 1

C

Question 2

In SAP Analytics Cloud, how are versions utilised for planning purposes?

A. Versions allow for storing only historical (actual) data.
B. They organise different user access levels for data manipulation.
C. Versions enable the creation of multiple plan iterations for future planning, each using a different version of data.
D. Versions are primarily used for tracking software updates.

Answer 2

C

Question 3

How many versions do you need for historical (actual) data?

A. 2
B. 1
C. 10
D. Unlimited versions

Answer 3

B
You only need one version for historical (actual) data.

Question 4

What happens when you change data in one version?

A. The changes affect all versions simultaneously.
B. Data modifications are restricted to read-only access.
C. The system prompts for confirmation before any changes are made.
D. Alterations in one version do not affect data in other versions.

Answer 4

D

Question 5

How does Version Management enhance planning in SAP Analytics Cloud?

A. By limiting the creation of new versions for each forecast period.
B. By enabling the management of different versions and types of plans.
C. By merging forecasts with other types of plans like budgets and strategic plans.
D. By restricting access to specific plan types for certain users.

Answer 5

B

Question 6

What is an example of how organizations can utilise Version Management in SAP Analytics Cloud?

A. Creating a single version for all types of plans.
B. Restricting access to plan types based on user roles.
C. Merging all plan types into one unified version.
D. Separating forecasts from other types of plans by creating a new version for each forecast period.

Answer 6

D

Other types of plans includes budgets and strategic plans.

Question 7

In SAP Analytics Cloud, how are versions integrated when creating planning models?

A. Versions serve as a primary identifier for different users in planning models.
B. The actual version is automatically assigned as a system default in planning models.
C. Versions are created within stories and then linked to planning models.
D. Versions are not applicable in planning models within SAP Analytics Cloud.

Answer 7

B

Question 8

What role does the “Version” dimension play in SAP Analytics Cloud planning models?

A. It acts as a filter to sort data by different versions of the plan.
B. Versions are created independently of planning models and stories.
C. The actual version is provided as a default, and additional versions are created during planning in stories.
D. Versions in planning models are solely managed by system administrators.

Answer 8

C

Additional versions are creating during planning stories.

Question 9

What is the primary characteristic of private versions in SAP Analytics Cloud?

A. Maintained and visible only to the creator.
B. Visible only to system administrators.
C. Visible to all users.
D. Visible to specific user groups.

Answer 9

A

Question 10

What can private versions be used for in SAP Analytics Cloud?

A. Sharing plan values with specific user groups.
B. Automatically updating plan values based on system changes.
C. Tracking historical changes in plan values.
D. Changing or simulating plan values without making the changes visible to anyone else.

Answer 10

D

Question 11

How can a private version be transformed into a new public version in?

A. By utilising the “Publish As” option.
B. By selecting the “Share” option within the story.
C. Through manual conversion by system administrators.
D. Automatically upon creation.

Answer 11

A

Question 12

When using the “Publish private data” option, what occurs in SAP Analytics Cloud?

A. Private version is deleted, and a new public version is created.
B. Data in the private version is copied to the original public version it was copied from initially.
C. Private version is converted into a read-only format.
D. Private version becomes inaccessible to anyone.

Answer 12

B

Question 13

How is data editing handled in private versions?

A. Data edits require approval from system administrators.
B. Private versions allow read-only access, prohibiting data editing.
C. Edits in private versions are not automatically saved.
D. Edits in private versions are automatically saved without user intervention.

Answer 13

D

Question 14

Can private versions be shared with other users?

A. Yes, they can be shared if necessary
B. No, private versions are strictly restricted to the creator
C. Yes, but only by system administrators
D. Yes, but only with specific user groups

Answer 14

A

Question 15

How does SAP Analytics Cloud handle viewing private data?

A. Users can view their own private data from the planning model without the need to save or publish changes.
B. Private data changes must be saved and published manually.
C. Private data can only be viewed by system administrators.
D. Private data changes are automatically saved and published to the planning model.

Answer 15

A

Question 17

Where are public versions maintained, and why are they published in SAP Analytics Cloud?

A. Public versions are maintained in planning models to restrict access, and they are published to enforce data integrity.

B. Public versions are maintained in data warehouses for archival purposes, and they are published to streamline data processing.

C. Public versions are maintained in stories, and they are published so that other planners can view the data.

D. Public versions are maintained in separate databases for security reasons, and they are published to ensure compliance with regulations.

Answer 17

C

Question 18

How is access to data controlled in public versions within SAP Analytics Cloud?

A. By system administrators only
B. Through user-defined access levels
C. Access is unrestricted
D. Controlled by data privileges

Answer 18

D

Question 19

What happens if changes to data in a story are not published before exiting in SAP Analytics Cloud?

A. Changes are automatically reverted
B. Users are prompted to publish changes
C. You’re prompted either to Revert all or Publish all changes.
D. Data changes are discarded
E. Data changes are retained in edit mode but not published

Answer 19

C

Question 20

What happens if you leave a story without reverting or publishing the data?

A. Changes are automatically reverted
B. Users are prompted to publish changes
C. Data changes are discarded
D. Data changes are retained in edit mode but not published

Answer 20

D

Question 21

Can there be multiple public Actual versions in a planning model in SAP Analytics Cloud?

A. Yes, there can be multiple public Actual versions
B. No, there can only be one public Actual version
C. Public versions are not applicable to Actual data
D. Public Actual versions must be created manually by administrators

Answer 21

B

Question 22

What controls are available when leaving a story without publishing data changes in SAP Analytics Cloud?

A. Options to revert changes or publish them
B. Changes are automatically reverted
C. Data changes are published automatically
D. Data changes are discarded automatically

Answer 22

A

Question 23

How can versions be managed in SAP Analytics Cloud?

A. Through the Version Control feature in the data settings.
B. Via the Version Management option in the story ribbon.
C. Versions are automatically managed by the system without user intervention.
D. Versions can only be managed by system administrators.

Answer 23

B

Question 24

How can a private version be shared in SAP Analytics Cloud?

A. Navigate to Version Management, select “more”, and click “Share” to choose access permissions (Read Only or Read and Write).
B. Access the story ribbon, select “Share Version,” and specify read-only or read-write permissions.
C. Go to Data Settings, find the private version, and enable sharing options.
D. Private versions cannot be shared in SAP Analytics Cloud.

Answer 24

A

Question 25

How can you access version options from a data table within a story in SAP Analytics Cloud? A. By clicking on the "Version Options" button located in the toolbar. B. By right-clicking on a data cell and selecting from a list of options. C. Through the "Manage Versions" tab in the data settings menu. D. Version options are only accessible via the Version Management dashboard.

Answer 25

**B**

Question 26

# Fill in the blank To create a temporary private version that only you can see until the changes are published, you would select the option ____ from the **Version options menu** in SAP Analytics Cloud.

Answer 26

**Start Edit Mode**

Question 27

What does Undo / Redo Data Change in the Version Options menu do?

Answer 27

It lets the user undo or redo the last data change made.

Question 28

What does "Revert" in the Version Options menu do?

Answer 28

Go back to the last saved data.

Question 29

What does "Publish" in the Version Options menu do? ## Footnote Know the difference between "Publish" and "Publish As"

Answer 29

Publish changes to an existing public version.

Question 30

What does "Publish As" in the Version Options menu do?

Answer 30

Publish private data to a new public version.

Question 31

# TRUE or FALSE The "History" option in the Version options menu of SAP Analytics Cloud allows users to access processing steps on unpublished data.

Answer 31

**TRUE**

Question 32

# TRUE or FALSE The "Delete Version" option in the Version options menu of SAP Analytics Cloud allows users to delete only public versions, not private versions.

Answer 32

**FALSE**

Question 33

# TRUE or FALSE The "Copy Version" option in the Version options menu enables users to copy a private or public version to a new private version.

Answer 33

**TRUE**

Question 34

What does a version category describe in a version? | Give an example.

Answer 34

The type of planning activity in the version. For example: A version related to actual data is assigned to the Actual category. A version related to forecast data is assigned to the Forecast category.

Question 35

What are the five delivered (built-in) version categories? | Hint: A B P F R

Answer 35

Actual Budget Planning Forecast Rolling Forecast

Question 36

What is the purpose of the "Actual" version category in SAP Analytics Cloud? A. To allocate actual resources for future spending. B. To set goals for the next fiscal year. C. Actual achieved values. D. To predict actuals and future outcomes. ## Footnote A B P F R

Answer 36

**C**

Question 37

# Fill in the blanks The "Budget" version category in SAP Analytics Cloud represents how much you're ____ to ____. ## Footnote A B P F R

Answer 37

How much you're **allowed** to **spend**.

Question 38

# TRUE or FALSE The "Planning" version category in SAP Analytics Cloud focuses solely on financial goals. ## Footnote A B P F R

Answer 38

**FALSE** ## Footnote Focuses on both financial or non-financial goals.

Question 39

What is the "Planning" version category in SAP Analytics Cloud? | A B P F R

Answer 39

What the goal is (financial or non-financial) that you're trying to achieve next year or the next three years.

Question 40

What is the "Forecast" version category in SAP Analytics Cloud? | A B P F R

Answer 40

What your expectation is for a specific timeframe in the future. This typically focuses on major revenue and expense items and is updated every month or quarter.

Question 41

What is the "Rolling Forecast" version category in SAP Analytics Cloud? | A B P F R

Answer 41

Similar to Forecast except it usually includes a few months of historic actual data followed by a continuous 12-18 months of forecast data.

Question 42

Match the version category in SAP Analytics Cloud with its corresponding definition: 1. Actual 2. Budget 3. Planning 4. Forecast 5. Rolling Forecast Definitions: A. Actual values achieved. B. Allocation of resources for future spending. C. Setting goals for the future. D. Expectation of future outcomes. E. Continuous prediction with historical data.

Answer 42

1 - A 2 - B 3 - C 4 - D 5 - E

Question 43

Aside from the 5 built-in version categories, can a user add additional categories?

Answer 43

Yes

Question 44

# TRUE or FALSE There’s no intrinsic difference among the budget, planning, forecast, and rolling forecast version categories. For example, the system functions the same for the planning category as it does for the forecast category.

Answer 44

**TRUE**

Question 45

# TRUE or FALSE Planning models can contain more than one actual version.

Answer 45

**FALSE** ## Footnote Planning models can only contain one actual version.

Question 46

# Short Answer Question Describe the difference between the "Forecast" and "Rolling Forecast" version categories in SAP Analytics Cloud.

Answer 46

The "Forecast" version category predicts future outcomes for a specific timeframe, while the "Rolling Forecast" version category includes historical actual data and extends into the future continuously.

Question 47

How do you publish the data in a public version in **Edit Mode**? | Tip: Where?

Answer 47

Choose Publish Data from the ribbon. Depending on your resolution, the publish data option will appear either in the ...More option or the Tools …More option.

Question 48

How do you publish the data in a public version in **View Mode**?

Answer 48

Choose the drop-down next to Publish Data in the ribbon and choose Advanced → Publish All.

Question 49

# TRUE or FALSE Once data is published, it can be undone.

Answer 49

**FALSE** ## Footnote Once data is published, it can't be undone.

Question 50

How can public data be published when using data actions in? A. It cannot be published with data actions. B. Public data can only be published using multi actions. C. Public data can only be published manually after the data action runs. D. Public data can be published while the data action runs.

Answer 50

**D**

Question 51

# TRUE or FALSE When using multi actions in SAP Analytics Cloud, public data can be published in the same process step as the data action runs.

Answer 51

**FALSE** ## Footnote When using multi actions, public data can be published in a separate process step.

Question 52

In the version dimension, what is the purpose of the "Category" property? A. It specifies the author of the version. B. It describes the type of planning activity. C. It determines the access level for the version. D. It indicates the date when the version was created.

Answer 52

**B**

Question 53

How is the public.actual version typically generated? A. It is automatically generated by the system when planning models are created. B. It is created manually by users when planning models are initialized. C. It is created by administrators when setting up access permissions. D. It is imported from external data sources during system setup.

Answer 53

**A** ## Footnote Other versions can be created from stories.

Question 54

In SAP Analytics Cloud, where can data be imported into a planning model? A. Only into private versions B. Only into the default version C. Only into public versions D. Only into new versions created during the import process

Answer 54

**C**

Question 55

Can Public Versions be created during the import process for new model types?

Answer 55

No

Question 56

In SAP Analytics Cloud, who can view private data from a planning model? A. Only system administrators B. Only users with specific access privileges C. Only the creator of the private version D. All users with access to the planning model

Answer 56

**C**

Question 57

# TRUE or FALSE When viewing data from the planning model, both published and unpublished public data can be viewed.

Answer 57

**TRUE**

Question 58

Where can administrators access the "Private Versions Statistics and Analysis" story? A. System → Performance → Private Versions Statistics and Analysis B. Model Settings → Private Versions Statistics and Analysis C. Data Management → Private Versions Statistics and Analysis D. Administration → Private Versions Statistics and Analysis

Answer 58

**A**

Question 59

What is the story called "Private Versions Statistics and Analysis" used for? A. Version Analysis B. Version Statistics C. To analyse private data D. To manage private data

Answer 59

**D**

Question 60

In what workspace is the model measures and dimensions displayed in table format? A. Data Analysis B. Storyboarding C. Visualization D. Model Structure

Answer 60

**D**

Question 61

# Unit 2 While planning in a story, how can you add a new member? A. Choose from a given list of member options B. Copy and paste an existing member and change its name C. Enter the new dimension directly into the data table D. You cannot add any new members

Answer 61

**C**

Question 62

# Unit 2: TRUE or FALSE Members can be created for Account, Version, or Date dimensions from a data table.

Answer 62

**FALSE**

Question 63

# Unit 2: TRUE or FALSE While you can create members in a story, you can't delete them.

Answer 63

**TRUE** ## Footnote Members can be deleted only from the model or public dimension (assuming they don't have any posted values).

Question 64

# Unit 2 How can you add a new dimension member from a story? ## Footnote Longer question

Answer 64

Right-click on a call and choose Add Member, a blank row is inserted below. You can enter in the new member into the new blank row. An input help will allow you to access a dialog to select the Parent Node and input the Description and ID. You can choose to define the new member as a child or sibling of existing members. If the dimension has properties, you can input existing or new property values as well.

Question 65

In SAP Analytics Cloud, how can planners add members to an input form for dimensions that don't have data in the fact table? A. By selecting the "Insert Unposted Member" option from the data table. B. By manually typing in the new member names in the data table. C. By importing a list of new members from an external file. D. By requesting system administrators to add the new members.

Answer 65

**A**

Question 66

# TRUE or FALSE When you create a new member, it won't have any data.

Answer 66

**TRUE**

Question 67

What does it mean when a member is referred to as "Unbooked"? A. The member has been deleted from the dimension. B. The member does not have any data. C. The member is currently inactive. D. The member has been marked as hidden.

Answer 67

**B**

Question 68

Unbooked and is displayed as a ____ in the table cell. A. # B. Just left blank C. * D. ^ E. -

Answer 68

**E**

Question 69

# TRUE or FALSE Unbooked data will be visible even though the Unbooked Data setting for the table is not turned on.

Answer 69

**FALSE** ## Footnote Unbooked data won't be visible unless the Unbooked Data setting for the table is turned on.

Question 70

Why is the Unbooked Data setting is turned off by default? A. To add new members more quickly. B. To prevent confusion. C. To make the table more neat and professional looking.

Answer 70

**A**

Question 71

# TRUE or FALSE If you create a new member on an inner dimension, then Unbooked Data will be turned on automatically for that member.

Answer 71

**TRUE**

Question 72

# TRUE or FALSE After you save the new member, you'll still be able to change the member details.

Answer 72

**FALSE** ## Footnote After you save the new member, you'll no longer be able to change the member details.

Question 73

At an enterprise level, where is master data typically maintained? A. In a separate data warehouse. B. Within individual stories. C. In a corporate repository or master data governance system. D. Within the model structure workspace.

Answer 73

**C** ## Footnote However, in some cases, adding new dimension members while planning in a story is feasible, for example, it is feasible when planning for a consumer products company to add new products as and when needed.

Question 74

How is new members indicated in a table (when it has no values or transgressions yet)? A. The member name is in bold B. The member name is in italics C. # D. << member name >> E. * next to the member name

Answer 74

**E**

Question 75

# Unit 3 Which of the following are key data entry features in SAP Analytics Cloud's planning functionality? A. Adjust plan by +/-, %, or absolute value B. Shortcut scaling characters to simplify input C. Built-in machine learning algorithms for forecasting D. Automatic highlights of impacted and related cells E. Real-time collaboration with other users F. Messages with number of records changed | There are 4 correct answers to this question.

Answer 75

**A, B, D, F**

Question 76

# Unit 3 How are data tables scaled in SAP Analytics Cloud stories? A. Data tables are automatically scaled to thousands or millions depending on the data. B. Data tables are scaled based on user-defined preferences. C. Data tables are scaled to billions by default. D. Data tables are not scaled automatically.

Answer 76

**A**

Question 77

# Unit 3 Where is the scaling factor displayed in a data table in SAP Analytics Cloud? A. On the upper right of the data table B. On the lower left of the data table C. On the upper left of the data table D. On the lower right of the data table

Answer 77

**C**

Question 78

# TRUE or FALSE When you enter numeric values, the system automatically displays the scaling factor in the cell.

Answer 78

**TRUE** ## Footnote The data table is scaled automatically by the system.

Question 79

What indicates a data change in SAP Analytics Cloud? A. An exclamation mark in the affected column B. A highlighted background in the affected cell C. A checkmark in the affected column D. An asterisk in the affected column

Answer 79

**D**

Question 80

# Unit 3 Where can the user set scaling for a table? A. In styles. B. In the data region styles. C. In the columns. D. In the rows.

Answer 80

**B**

Question 81

# X represents a number Define each relative value option: *X /X X% or -X% +X +-X

Answer 81

*X Multiply the value by X **/X** Divide the value by X **X% or -X%** Increase or reduce the value by X percentage **+X** Add X to the value **+-X** Subtract X to the value

Question 82

# TRUE or FALSE Data entries cannot be tested before you save and publish them.

Answer 82

**FALSE** ## Footnote Data entries can be tested before you save and publish them.

Question 83

What does the presence of an **asterisk and yellow markup** in a column indicate? A. The data entry has been successfully published. B. The data entry is invalid and needs correction. C. The data entry function is being used but not published. D. The data entry has been reverted to its original value.

Answer 83

**C**

Question 84

Name the following value types: A - 500 B - 100 * 2

Answer 84

A - Absolute value B - Relative value ## Footnote You can type an absolute value in a cell, or type a relative value such as *2 or +500 to perform simple mathematical calculations on existing data. For example, if the data value in a cell is 100, and you type *2 in the cell, the value will change to 200.

Question 85

How can you include the scale when typing a value?

Answer 85

If you want to enter the value 1,000,000, you can simply type **1M**, and SAP Analytics Cloud will interpret that entry as 1,000,000.

Question 86

Give the Single Letter, Complete Word and Short Form for every scale: Thousand Million Billion

Answer 86

**Thousand:** T Thousand K **Million:** M Million M **Billion:** B Billion Bn

Question 87

# TRUE or FALSE You can copy and paste values from a source such as Microsoft Excel or a flat file to develop your dataset.

Answer 87

**TRUE**

Question 88

Why does disaggregation save planners time?

Answer 88

They don't have to enter data for every base member.

Question 89

What does SAP Analytics Cloud automatically do when data is entered for a parent member? A. Aggregate the data to the parent level B. Disaggregate the data to the children of the parent C. Delete the data from the parent member D. Round the data to the nearest integer

Answer 89

**B**

Question 90

How does SAP Analytics Cloud disaggregate data to the children of a parent member? A. Equally or in proportion to existing values B. Randomly C. Based on alphabetical order D. Based on the hierarchy structure

Answer 90

**A**

Question 91

How can you enable control over disaggregation? A. By activating "Data Disaggregation - Data Locking and / or Data Disaggregation - Validation Rules" in the planning model and also in the data table. B. By enabling "Data Disaggregation - Auto Save" in the data table. C. By adjusting the font size of the data table. D. By exporting the data table to an external spreadsheet application.

Answer 91

**A**

Question 92

How can you control disaggregation in SAP Analytics Cloud? A. By manually adjusting each cell's value in the data table B. By deleting the parent member from the hierarchy C. By applying a predefined disaggregation algorithm D. By filtering the data table to display only base members

Answer 92

**D**

Question 93

Give a synonym for **base members**.

Answer 93

Leaf members.

Question 94

Do base members/leaf members in a dimension have children?

Answer 94

No

Question 95

Define the term **disaggregation**.

Answer 95

The system automatically disaggregated values entered for a parent to its children equally, or proportionally based on existing values.

Question 96

# Terms that relate to disaggregation: allocation and distribution. Define the term **allocation**.

Answer 96

This is based on explicit instructions in an allocation process.

Question 97

# Terms that relate to disaggregation: allocation and distribution. Define the term **distribute**.

Answer 97

This is an option in the planning panel used in stories.

Question 98

What happens when you enter a value in an unbooked cell with a hash character (-)? A. The value is distributed evenly across all base members of the dimension. B. The value is applied only to the unassigned member. C. If the unassigned member (#) is available as a leaf member of the source cell, this member receives the same value as the source cell, and other members of the dimension remain unbooked. D. The value is ignored and does not affect any members in the dimension.

Answer 98

**C** ## Footnote SAP seems to refer to a hash character as " - " Double check the difference between - and #

Question 99

What happens when you enter a value in an unbooked cell with a hash character (-) if the unasigned member is not available?

Answer 99

The value is spread to base members based on the dimension's aggregation type.

Question 100

What is cell locks and where are they defined?

Answer 100

Cell locks prevent data entry for specific table cells. Defined in the table.

Question 101

Under what circumstances might the unassigned member (#) not be available for disaggregation? A. When it is filtered out of the table B. When it doesn't exist for dimensions such as Time and Account C. When it doesn't aggregate up to the source cell D. All of the above

Answer 101

**D**

Question 102

How are cell locks handled in SAP Analytics Cloud? A. Cell locks are page-specific. B. Cell locks are saved with the model. C. Cell locks are user-specific. D. Cell locks apply only to the creator of the story. E. Cell locks are story specific. | There are 2 correct answers to this question.

Answer 102

**A, E**

Question 103

What happens to the value in a locked table cell when data is changed? A. The value is updated based on the new data B. The value remains unchanged C. The value is deleted D. The value is rounded to the nearest integer

Answer 103

**B**

Question 104

Where are cell locks applied in SAP Analytics Cloud? A. To individual users B. To specific versions of the data C. To specific pages within a story D. To the entire model

Answer 104

**C** ## Footnote Cells locks apply to everyone who accesses the same page in the same story.

Question 105

# TRUE or FALSE Cells locks can be saved with the story.

Answer 105

**TRUE**

Question 106

How can you set locks on individual cells in a table? A. By accessing the Lock Cell option from the main toolbar B. By selecting the cells and pressing Ctrl + L C. By right-clicking a cell and choosing Lock Cell D. By using the Value Lock Management panel

Answer 106

**A**

Question 107

How can you set locks on multiple cells? A. By accessing the Lock Cell option from the main toolbar B. By selecting the cells and pressing Ctrl + L C. By right-clicking a cell and choosing Lock Cell D. By using the Value Lock Management panel

Answer 107

**D**

Question 108

Where can you access the Value Lock Management panel? A. From the main toolbar in the "Locks" option B. From the main toolbar in the "More..." option C. From the context menu of a selected cell D. From the data source settings menu

Answer 108

**B**

Question 109

List 5 key elements for cell locking

Answer 109

1. Lock a cell 2. View all locks 3. Set new locks 4. Clear locks 5. Reset priority

Question 110

How do you lock a cell?

Answer 110

Right-click on a specific cell and lock it. This prevents data entry and disaggregation won't update the cell.

Question 111

Where can you view existing locks?

Answer 111

Value Lock Order ## Footnote The notes on SAP learning hub gives a visual.

Question 112

How can you change the priority of locks in SAP Analytics Cloud? A. By rearranging locks in the Value Lock Management panel B. By accessing the Lock Priority option in the table settings C. By selecting the locks and pressing Ctrl + P D. By adjusting the priority values directly in the table

Answer 112

**A** ## Footnote You can drag a lock to change the priority. After you move one lock, priority values appear for all locks in the list with their specific priority.

Question 113

What happens to the value in a locked table cell when data is changed? A. The value is updated based on the new data B. The value remains unchanged C. The value is deleted D. The value is rounded to the nearest integer

Answer 113

**B**

Question 114

Which entity have lower priority? A. Data entry processes B. Cell locks

Answer 114

**A** ## Footnote If you want to give data entry processes higher priority, you can change the order of the locks.

Question 115

What can you use to prevent input for a large range of cells? A. Locking each cell individually B. Using a predefined template for input C. The Set/unset read only for selected cells option

Answer 115

**C** ## Footnote To use this option, follow these steps: 1. Highlight the cells that you want to disable for input. 2. Go to … More in the Tools area of the ribbon (depending on your resolution, use the ...More option on the right). 3. Select Set/unset read only for selected cells.

Question 116

What happens when the Set/unset read only option is applied? A. The selected cells become editable for all users. B. The selected cells are grayed out and data entry isn't possible. C. The selected cells are deleted from the table.

Answer 116

**B**

Question 117

# TRUE or FALSE When you save the story, the Set/unset read only for selected cells setting is not retained.

Answer 117

**FALSE** ## Footnote When you save the story, the Set/unset read only for selected cells setting **is retained.**

Question 118

# TRUE or FALSE The Value Lock Management panel only applies to Cell Locks.

Answer 118

**TRUE**

Question 119

# TRUE or FALSE The Set/unset read only for selected cells setting doesn’t prevent disaggregation.

Answer 119

**TRUE**

Question 120

Which of the following are data entry modes for data tables? A. Single Data Entry Mode B. Data Selection Mode C. Fluid Data Entry Mode D. Mass Data Entry Mode E. Copy-Paste Data Entry Mode | There are 3 correct responses to this question.

Answer 120

**A, C, D**

Question 121

Which data entry mode is described below? Processes all new data changes at the same time if they are made in a fast sequence. A. Single Data Entry Mode B. Fluid Data Entry Mode C. Mass Data Entry Mode

Answer 121

**B**

Question 122

Which data entry mode is described below? Processes each new data change immediately. A. Single Data Entry Mode B. Fluid Data Entry Mode C. Mass Data Entry Mode

Answer 122

**A**

Question 123

Which data entry mode is described below? Processes all new data changes when you confirm that you've finished entering values. A. Single Data Entry Mode B. Fluid Data Entry Mode C. Mass Data Entry Mode

Answer 123

**C**

Question 124

Which data entry mode is the default when a new data table is created? A. Single Data Entry Mode B. Fluid Data Entry Mode C. Mass Data Entry Mode

Answer 124

**B** By default, data values are entered using Fluid Data Entry Mode. ## Footnote In Fluid Data Entry Mode, data values entered in a fast sequence will be processed together at the same time as a batch; you don’t need to wait for the system to update between entries.

Question 125

Describe **Time Interval for Fluid Data Entry** with an in-depth example.

Answer 125

To set or change the time interval for fluid data entry batches, go to System → Administration → System Configuration and update the value for Time interval of fluid data entry batches (in milliseconds). **Example:** Data values entered with time between every two successive data entries within this set time interval will be treated as belonging to the same fluid data entry batch. For example, you set the time interval to 500 milliseconds (0.5 seconds). If there's a 0.5 second of inactivity, a batch is processed, and the next data value you enter will be treated as the first one of a new fluid data entry batch.

Question 126

Define the term Mass Data Entry

Answer 126

Mass Data Entry allows you to enter multiple values in a table without waiting for the system to update between entries. ## Footnote Adding multiple values to a table can be time consuming when you've to wait for the system to update the data source after each entry.

Question 127

How can you use mass data entry? | There are 3 points

Answer 127

In order to use Mass Data Entry, follow these steps: 1. Switch to Mass Data Entry using the table's More Actions menu. 2. Enter data values. 3. Select Process Data to apply the changes and exit **or** select Exit Mass Data Entry to leave without applying changes.

Question 128

# TRUE or FALSE You can add Inverse Functions to dimension formulas

Answer 128

**TRUE**

Question 129

Define what an Inverse Function is and give an example.

Answer 129

Inverse Functions are added to dimension formulas to calculate a value that is the result of the formula. By default, planning models don't support data entry for formulas. But with Inverse Functions, you can enable data entry for the formula result and then specify one or more ways as to how the formula is reversed. **Example** **Formula:** [Revenue] – [Cost] **Inverse Formula:** [Revenue] – [Cost] | INVERSE ([Cost] := [Revenue] – [Profit]) ## Footnote NB! See the example provided in learning hub material provided by SAP.

Question 130

How can you display the dimension formula in the story?

Answer 130

Highlight the account with the formula → Go to ...More → Display the Formula bar. You can also input data for an account that is a percent type. For example, profit % ## Footnote See visual example. Account in this scenario refers to the cell containing the formula.

Question 131

You can define multiple Inverse Formula options in a given formula. When doing so, what determines the priority? A. The complexity of the formula B. The order in which they are typed C. The mathamatical Order of Operations standard

Answer 131

**B** The order in which they are typed.

Question 132

What does the following Inverse Formulas characters determine? **|** **:=**

Answer 132

**|** A vertical bar (pipe) marks the end of the base formula and the beginning of one or more inverse functions. **:=** You must add a colon before the equal sign when defining an inverse function.

Question 133

[Revenue] – [Cost] | INVERSE ([Cost] := [Revenue] – [Profit]) How can the above inverse function be altered if there is a cell lock on the Cost cell? ## Footnote If there is a cell lock applied to Cost, the cell value won't be able to change.

Answer 133

[Revenue] – [Cost] | INVERSE([Cost] := [Revenue] – [Profit]) OR INVERSE([Revenue] := [Profit] + [Cost])

Question 134

What panel can be used to move values in a table and perform distributions? A. Data Manipulation Panel B. Value Transformation Panel C. Distribution Control Panel D. Planning Panel

Answer 134

**D**

Question 135

When might you use the Planning Panel? A. For basic data entry tasks B. For complex data actions or allocations C. For creating structured data formulas D. For tasks too complex for basic data entry, but not requiring structured data actions or allocations

Answer 135

**D** ## Footnote For example, you have an unassigned overhead cost that you want to spread to a few different cost centers. Or you need to redistribute sales volumes among different regions without changing the total. These tasks are difficult with basic spreadsheet applications, but you can handle them quickly with the Planning Panel.

Question 136

List 4 features of the Planning Panel

Answer 136

1. Use a form-based approach to distribute values between the members. 2. Allow the planners to distribute values in the data table using on-the-fly criteria they select. 3. Preview the results before submitting. 4. This is a built-in story feature. ## Footnote You can also interact with the table while the Planning Panel is open. You can collapse or expand dimension members, set the drill level of a dimension, show or hide unbooked members, and show or hide rows and columns.

Question 137

What are the two basic operations available for the planning panel? A. Copy and Paste B. Insert and Delete C. Distributing a source value to one or more target cells D. Filtering and Sorting E. Redistributing the values of a group of cells. | There are 2 correct responses.

Answer 137

**C and E** ## Footnote Options, such as custom source values and different driver types, let you carry out more scenarios with the Planning Panel. You can also allocate multiple dimensions in one step, and pick target cells from different hierarchy levels.

Question 138

What are the four recommendation options to distribute from an entity parent node to its members? A. Redistribute Among Entity Members of Lower Level B. Distribute Among Selected Entity Members C. Redistribute Among Entity Members D. Distribute to Entity Members One Level Below E. Distribute to Entity Members of the Same Level

Answer 138

**A, C, D, E** ## Footnote Each recommendation comes with a preview. The number of recommendation options depends on whether the source value is a parent with only children or a parent with siblings.

Question 139

What is the Driver option used for? A. To choose how to set the cell values B. To select the preferred route for data distribution C. To determine the speed of calculations D. To specify the model's primary source of revenue

Answer 139

**A**

Question 140

What are the four driver options? A. Input Values B. Equally C. Input Weights D. Proportionally E. Custom Weights

Answer 140

**A, B, C, D**

Question 141

# Driver option 1/4 Describe Input Values

Answer 141

Add the exact target values, either in the table or in the panel.

Question 142

# Driver option 2/4 Describe Equally

Answer 142

Divide the source value equally among the cells.

Question 143

# Driver option 3/4 Describe Input Weights

Answer 143

Set proportional weights for each cell. For example, if you want to get weights from a different time period, you could copy and paste those values from the table.

Question 144

# Driver option 4/4 Describe Proportionally

Answer 144

Use the existing proportions between the cells. This option requires existing booked values.

Question 145

How can the Planning Panel be used to adjust the revised annual budget? A. By increasing the budget for the upcoming periods B. By assigning variances to the upcoming forecast periods C. By reducing the budget for the current period D. By reallocating funds to unrelated expenses

Answer 145

**B** ## Footnote This way, you’ll set new targets that reduce your costs enough to meet the budget for the year.

Question 146

What is the purpose of entering a negative value for the year-to-date variance in the Planning Panel? A. To increase expenses for the remaining months B. To maintain expenses at the same level for the remaining months C. To reduce expenses for the remaining months D. To reallocate expenses to different categories

Answer 146

**C** ## Footnote For example, the year-to-date variance is 17,543,670. In the Planning Panel, you enter -17,543,670 and choose Append. The forecast for July to December is reduced. The YTD expense variance is distributed to the remaining months so that no over-runs occur by the end of the year.