Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

C_SACS_2321 > Unit 2: Planning in stories > Flashcards

Unit 2: Planning in stories Flashcards

Leveraging SAP Analytics Cloud Functionality for Enterprise Planning

1
Q

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

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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.

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A

D

Other types of plans includes budgets and strategic plans.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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.

A

C

Additional versions are creating during planning stories.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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.

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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.

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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.

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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.

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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.

A

Start Edit Mode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What does “Revert” in the Version Options menu do?

A

Go back to the last saved data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What does “Publish” in the Version Options menu do?

Know the difference between “Publish” and “Publish As”

A

Publish changes to an existing public version.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What does “Publish As” in the Version Options menu do?

A

Publish private data to a new public version.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

TRUE or FALSE

The “History” option in the Version options menu of SAP Analytics Cloud allows users to access processing steps on unpublished data.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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.

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What does a version category describe in a version?

Give an example.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What are the five delivered (built-in) version categories?

Hint: A B P F R

A

Actual
Budget
Planning
Forecast
Rolling Forecast

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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.

A B P F R

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Fill in the blanks

The “Budget” version category in SAP Analytics Cloud represents how much you’re ____ to ____.

A B P F R

A

How much you’re allowed to spend.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

TRUE or FALSE

The “Planning” version category in SAP Analytics Cloud focuses solely on financial goals.

A B P F R

A

FALSE

Focuses on both financial or non-financial goals.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What is the “Planning” version category in SAP Analytics Cloud?

A B P F R

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

What is the “Forecast” version category in SAP Analytics Cloud?

A B P F R

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

What is the “Rolling Forecast” version category in SAP Analytics Cloud?

A B P F R

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

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

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

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.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

TRUE or FALSE

Planning models can contain more than one actual version.

A

FALSE

Planning models can only contain one actual version.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

Short Answer Question

Describe the difference between the “Forecast” and “Rolling Forecast” version categories in SAP Analytics Cloud.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

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

Tip: Where?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

TRUE or FALSE

Once data is published, it can be undone.

A

FALSE

Once data is published, it can’t be undone.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

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.

A

D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

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.

A

FALSE

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

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.

A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

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.

A

A

Other versions can be created from stories.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

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

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

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

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

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

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

TRUE or FALSE

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

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

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

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

A

D

60
Q

In what workspace is the model measures and dimensions displayed in table format?

A. Data Analysis
B. Storyboarding
C. Visualization
D. Model Structure

A

D

61
Q

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

A

C

62
Q

Unit 2: TRUE or FALSE

Members can be created for Account, Version, or Date dimensions from a data table.

A

FALSE

63
Q

Unit 2: TRUE or FALSE

While you can create members in a story, you can’t delete them.

A

TRUE

Members can be deleted only from the model or public dimension (assuming they don’t have any posted values).

64
Q

Unit 2

How can you add a new dimension member from a story?

Longer question

A

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.

65
Q

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.

A

A

66
Q

TRUE or FALSE

When you create a new member, it won’t have any data.

A

TRUE

67
Q

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.

A

B

68
Q

Unbooked and is displayed as a ____ in the table cell.

A. #
B. Just left blank
C. *
D. ^
E. -

A

E

69
Q

TRUE or FALSE

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

A

FALSE

Unbooked data won’t be visible unless the Unbooked Data setting for the table is turned on.

70
Q

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.

A

A

71
Q

TRUE or FALSE

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

A

TRUE

72
Q

TRUE or FALSE

After you save the new member, you’ll still be able to change the member details.

A

FALSE

After you save the new member, you’ll no longer be able to change the member details.

73
Q

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.

A

C

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.

74
Q

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. &laquo_space;member name&raquo_space;
E. * next to the member name

A

E

75
Q

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.

A

A, B, D, F

76
Q

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.

A

A

77
Q

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

A

C

78
Q

TRUE or FALSE

When you enter numeric values, the system automatically displays the scaling factor in the cell.

A

TRUE

The data table is scaled automatically by the system.

79
Q

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

A

D

80
Q

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.

A

B

81
Q

X represents a number

Define each relative value option:

*X
/X
X% or -X%
+X
+-X

A

*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

82
Q

TRUE or FALSE

Data entries cannot be tested before you save and publish them.

A

FALSE

Data entries can be tested before you save and publish them.

83
Q

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.

A

C

84
Q

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

A

A - Absolute value
B - Relative value

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.

85
Q

How can you include the scale when typing a value?

A

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.

86
Q

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

A

Thousand:
T
Thousand
K

Million:
M
Million
M

Billion:
B
Billion
Bn

87
Q

TRUE or FALSE

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

A

TRUE

88
Q

Why does disaggregation save planners time?

A

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

89
Q

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

A

B

90
Q

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

A

A

91
Q

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.

A

A

92
Q

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

A

D

93
Q

Give a synonym for base members.

A

Leaf members.

94
Q

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

A

No

95
Q

Define the term disaggregation.

A

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

96
Q

Terms that relate to disaggregation: allocation and distribution.

Define the term allocation.

A

This is based on explicit instructions in an allocation process.

97
Q

Terms that relate to disaggregation: allocation and distribution.

Define the term distribute.

A

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

98
Q

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.

A

C

SAP seems to refer to a hash character as “ - “
Double check the difference between - and #

99
Q

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

A

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

100
Q

What is cell locks and where are they defined?

A

Cell locks prevent data entry for specific table cells.

Defined in the table.

101
Q

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

A

D

102
Q

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.

A

A, E

103
Q

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

A

B

104
Q

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

A

C

Cells locks apply to everyone who accesses the same page in the same story.

105
Q

TRUE or FALSE

Cells locks can be saved with the story.

A

TRUE

106
Q

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

A

A

107
Q

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

A

D

108
Q

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

A

B

109
Q

List 5 key elements for cell locking

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

How do you lock a cell?

A

Right-click on a specific cell and lock it.

This prevents data entry and disaggregation won’t update the cell.

111
Q

Where can you view existing locks?

A

Value Lock Order

The notes on SAP learning hub gives a visual.

112
Q

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

A

A

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.

113
Q

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

A

B

114
Q

Which entity have lower priority?

A. Data entry processes
B. Cell locks

A

A

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

115
Q

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

A

C

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.
116
Q

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.

A

B

117
Q

TRUE or FALSE

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

A

FALSE

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

118
Q

TRUE or FALSE

The Value Lock Management panel only applies to Cell Locks.

A

TRUE

119
Q

TRUE or FALSE

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

A

TRUE

120
Q

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.

A

A, C, D

121
Q

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

A

B

122
Q

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

A

A

123
Q

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

A

C

124
Q

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

A

B
By default, data values are entered using Fluid Data Entry Mode.

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.

125
Q

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

A

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.

126
Q

Define the term Mass Data Entry

A

Mass Data Entry allows you to enter multiple values in a table without waiting for the system to update between entries.

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.

127
Q

How can you use mass data entry?

There are 3 points

A

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.
128
Q

TRUE or FALSE

You can add Inverse Functions to dimension formulas

A

TRUE

129
Q

Define what an Inverse Function is and give an example.

A

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])

NB! See the example provided in learning hub material provided by SAP.

130
Q

How can you display the dimension formula in the story?

A

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 %

See visual example. Account in this scenario refers to the cell containing the formula.

131
Q

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

A

B
The order in which they are typed.

132
Q

What does the following Inverse Formulas characters determine?

|
:=

A

|
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.

133
Q

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

How can the above inverse function be altered if there is a cell lock on the Cost cell?

If there is a cell lock applied to Cost, the cell value won’t be able to change.

A

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

134
Q

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

A

D

135
Q

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

A

D

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.

136
Q

List 4 features of the Planning Panel

A
  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.

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.

137
Q

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.

A

C and E

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.

138
Q

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

A

A, C, D, E

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.

139
Q

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

A

A

140
Q

What are the four driver options?

A. Input Values
B. Equally
C. Input Weights
D. Proportionally
E. Custom Weights

A

A, B, C, D

141
Q

Driver option 1/4

Describe Input Values

A

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

142
Q

Driver option 2/4

Describe Equally

A

Divide the source value equally among the cells.

143
Q

Driver option 3/4

Describe Input Weights

A

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.

144
Q

Driver option 4/4

Describe Proportionally

A

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

145
Q

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

A

B

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

146
Q

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

A

C

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.

C_SACS_2321 (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions