Leveraging SAP Analytics Cloud Functionality for Enterprise Planning Flashcards

1
Q

Which of the following statements about planning stories are true?

a. Planning stories are created by users and are based on analytic models.

b. Comments and discussions can be used to collaborate with teammates.

c. Extra planning tools are available for you to use when you add a table to your story.

d. It is possible to add scripting to standard story widgets to add customized behavior.

A

Comments and discussions can be used to collaborate with teammates.

Extra planning tools are available for you to use when you add a table to your story.

It is possible to add scripting to standard story widgets to add customized behavior.

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

Where can you define cell locking?

a. In the model

b. In the story table widget

c. In the value management panel

A

In the story table widget

In the value management panel

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

Which of the following statements about data entry modes are true?

a. Single Data Entry Mode processes each new data change immediately and is the default for new tables added to SAP Analytics Cloud stories.

b. Fluid Data Entry Mode processes all new data changes at the same time if they are made in a fast sequence.

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

A

Fluid Data Entry Mode processes all new data changes at the same time if they are made in a fast sequence.

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

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

When using inverse dimension formulas, when is it not possible to change the value for cost?

a. If a cell lock is applied to cost.

b. If values are entered for cost and profit simultaneously

c. It is always possible to change the value for cost.

A

If a cell lock is applied to cost.

If values are entered for cost and profit simultaneously

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

To use seamless planning in SAP Analytics Cloud with a model created and deployed in SAP Datasphere, which of the following steps must you complete?

a. Create an Optimized Design Experience story in SAP Analytics Cloud.

b. Select the model from the SAP Datasphere storage location.

c. Create a new model in SAP Analytics Cloud use SAP Datasphere as the storage location.

A

Create an Optimized Design Experience story in SAP Analytics Cloud.

Select the model from the SAP Datasphere storage location.

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

Which of the following statements about versions is correct?

a. In a planning model, both published and unpublished public data can be viewed.

b. In a planning model, private data is on viewable by whomever created the private version.

c. In a planning model, only the user who created the private data can delete it from model preferences.

d. In the Version dimension, Category is a property that is used to describe the type of planning activity.

A

In a planning model, both published and unpublished public data can be viewed.

In a planning model, private data is on viewable by whomever created the private version.

In the Version dimension, Category is a property that is used to describe the type of planning activity.

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

Which dimension allows the creation of new members from a story?

a. Version

b. Account

c. Generic

d. Measure

A

Generic

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

The Planning Panel is a built-in feature used to distribute values among dimension members in a story.

True or False

A

True - The Planning Panel is a built-in feature in a story used to distribute values among members.

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

What are the two types of Versions for planning models?

a. Version and Rate Version

b. Locked and Unlocked

c. Public and Private

d. Local and Shared

A

Public and Private

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

What are the types of action steps available in a Data Action?

a. Delete Step

b. Copy step

c. Cross-Model Copy step

d. Save step

e. Advanced Formulas step

A

Copy step

Cross-Model Copy step

Advanced Formulas Step

Six types of data actions are available: Copy, cross-model copy, embedded, allocations, currency, and advanced formulas.

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

You are limited to 5 steps in a data action planning sequence.

True or False

A

False - You can have as many steps as you need.

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

How can you make a copy step more flexible for the end-users?

a. Add a variable to the source system (SAP BW, BW/4HANA, or S/4HANA)

b. Use SAP Analytics Cloud’s Input Task collaboration option to solicit their input

c. Use a parameter to allow them to choose dimension members

A

Use a parameter to allow them to choose dimension members

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

What are the options for defining advanced data actions?

a. In a model

b. In the Visual Editor

c. In a story

d. In the Script Editor

A

In the Visual Editor

In the Script Editor

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

Your users are complaining that their data actions are running slower than normal. You should follow up by running everyone’s data actions to see for yourself.

True or False

A

False - You should access the built-in performance tracking content and run the Data Action Statistics and Analysisstory.

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

When you filter data with an input control, you can automatically run the data action for the same member.

True or False

A

True - You can link a data action parameter to input controls and story filters.

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

What are the advantages of multi actions?

a. Faster performance

b. Scheduling

c. Lowe cost of development

d. Fewer buttons to push

A

Scheduling

Lower cost of development

Fewer buttons to push

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

When using a cross-model copy step, what must you include?

a. A parameter to determine the source model

b. A filter on the Version dimension to choose which version to copy from

c. A parameter to determine the target model

A

A filter on the Version dimension to choose which version to copy from

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

The results of an advanced formula step are not stored in the SAP Analytics Cloud database.

True or False

A

False - Advanced formula results are stored in the SAP Analytics Cloud database.

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

Allocations are performed in order to identify cost by responsible unit.

True or False

A

False - Allocations are performed in order to identify the total cost by responsible unit.

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

An allocation can be run from the story ribbon or via a data action.

True or False

A

True - An allocation can be run from the story ribbon and / or a data action. Data actions can run all steps of an allocation process or individual steps.

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

The booking account is used to send a summarized value to target cost centers.

True or False

A

True - The booking account is used to send a summarized value to target cost centers.

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

A currency data action stores its result in the database but a conversion measure does not.

True or False

A

False - Currency data actions are run to record results into the database. Conversion measures are calculated on the fly.

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

You are analyzing currency values in a story. You can access any conversion measure from the model and you can also create more conversion measures in the story.

True or False

A

True - Model-based conversion measures are available in stories and you can create your own in stories if needed.

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

A Value Driver Tree can be created based on any model type.

True or False

A

True - A Value Driver Tree can be created on planning as well as analytic models.

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

With a rolling forecast, the time interval is static.

True or False

A

False - Time determination can be dynamic.

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

What are the models in advanced options when running a predictive forecast?

a. Moving Average

b. Linear Regression

c. Gamma Model

d. Automatic Forecast

A

Linear Regression

Automatic Forecast

Linear regression and automatic forecast are included in the advanced options.

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

A Predictive Forecast requires which objects in a story?

a. Analytic application

b. HANA PAL

c. Data table

d. Planning model

A

Data Table

Planning model

28
Q

Data audit reports include the time stamp, user, previous value, new value, and delta value for data changes.

True or False

A

True - Data audit records the time stamp, user, previous value, new value, and delta value whenever there is a data change.

29
Q

In a planning process, a Reviewer is required.

True or False

A

False - Reviewers are optional. They are only needed when approvals are required.

30
Q

Where is a Process created?

a. Calendar

b. Model

c. Story

A

Calendar

31
Q

What is the purpose of a validation rule?

a. To prevent improper data entry and planning operations

b. To allow access to a story

c. To prohibit use of a model

A

To prevent improper data entry and planning operations

32
Q

What is one criteria for defining data locks?

a. The story must be in the Public folder

b. The model must be shared

c. The Version must be Private

d. Data locking must be enabled in the model

A

Data locking must be enabled in the model

33
Q

The communications tools used in collaboration include:

a. Comments

b. Calendar

c. Story

d. Version

A

Comments

Calendar

34
Q

What is a benefit of Optimized Design Experience?

a. It has better formatting

b. It has improved Tooltip Interactions

c. It refreshes all charts refresh when opening stories

d. It has a new builder panel for tables

A

It has improved Tooltip Interactions

35
Q

Which story element does not exist in the Optimized Design Experience?

a. Grid page

b. Responsive page

c. Canvas page

A

Grid page

36
Q

What is a data source for a story in SAP Analytics Cloud?

a. File

b. SAP BW InfoCube

c. SAP Analytics Cloud Model

d. Outside data source

A

File

SAP Analytics Cloud Model

Outside data source

37
Q

SAP Analytics Cloud stories are browser-based.

True or False

A

True

38
Q

You can use data from a non-SAP system in your story.

True or False

A

True

39
Q

You use a flat file as a data source for your story. What is a possible option?

a. Use the Data Preparation area to manipulate the data

b. Schedule the file to upload new data to your story

c. Define security based on a property

A

Use the Data Preparation area to manipulate the data

40
Q

SAP encourages you to use Classic Design Experience when creating stories.

True or False

A

False

41
Q

You need to transform data for your story. What is a transformation option for manipulating data?

a. ABAP editor

b. Transform Bar

c. JavaScript editor

d. Custom Expression Editor

A

Transform Bar

Custom Expression Editor

42
Q

What is a feature of a story template?

a. Templates contain widgets with data sources

b. Templates contain widgets that are empty placeholders

c. Templates reduce the cost of development

d. Templates are built from scratch

A

Templates contain widgets that are empty placeholders

Templates are built from scratch

43
Q

You want to create a story in SAP Analytics Cloud and present the data of storage locations in the Geo Map widget. Which models you can use for the map?

a. Import models manually uploaded

b. Planning models

c. Live models on SAP HANA data

A

Import models manually uploaded

Live models on SAP HANA data

Import models using a manual upload and live models using SAP HANA as a data source are the two geo models.

44
Q

To include time in a chart variance, you must have a Date dimension in the chart.

True or False

A

True - To include time in your variance, you must have the Date dimension in your chart.

45
Q

What is a benefit of chart scaling?

a. It is applied by default

b. It ensures that you have a consistent display of values across multiple charts

c. It applies only to column charts

A

It ensures that you have a consistent display of values across multiple charts

46
Q

You can apply a style only to the table header.

True or False

A

False - You can apply a style to any table region

47
Q

How do you alter the colors on charts based on thresholds?

a. Styling rules

b. Scale Format

c. Templates

d. Conditional formatting

A

Conditional formatting

48
Q

When using a model in a story, all table features are available, regardless of the model type.

True or False

A

False - When using a model in a story, the available table features such as calculations, data entry, and automatic time determination depend on the type of model.

49
Q

To improve story performance, you should use JPG images.

True or False

A

False - SVG images are the optimal choice, then PNG, and finally, JPG.

50
Q

What can story themes be used for?

a. Format new responsive pages

b. Set the number of decimals for charts

c. Format existing responsive pages

d. Set the number of decimals for tables

A

Format new responsive pages

Format existing responsive pages

Story themes can be used to format existing and new responsive pages. The number of decimals for charts and tables are in their styles.

51
Q

A story used as a launchpad provides access only to other pages in the launchpad story.

True or False

A

False - A story used as a launchpad can provide access to other pages in the launchpad story or to different stories, or both.

52
Q

Thresholds can be defined at both the model and story levels.

True or False

A

True - Thresholds can be defined at both the model and story levels.

53
Q

A story can contain only one data source.

True or False

A

False - You can create a story with visualizations using data from multiple models and datasets.

54
Q

In what order can data be sorted?

a. Ascending

b. Descending

c. Specialized

d. Custom

A

Ascending

Descending

Custom

55
Q

You have created a story with two charts. The second chart should be filtered automatically by the filter used for the first chart. What do you use to enable this scenario?

a. Component Link

b. Grouped Analysis

c. Linked Analysis

d. Story Link

A

Linked Analysis

55
Q

In your story you use one chart and one table, which are based on the same data source with a prompt. Your colleague says that the response on the prompt will automatically filter the data of the chart and the table. Is the statement of your colleague true or false?

True or False

A

True - When a data source for a story includes variables/prompts, all tables and charts based on that data source are filtered to the variable response.

56
Q

You are asked to create a story with a table where the users can choose which dimension is displayed in the rows of the table. How could you meet this request?

a. Use a story filter

b. Use an advanced filter

c. Use a dimension input control

A

Use a dimension input control - You can use input controls to allow users to change what specific dimensions and/or measure are displayed in a table or chart.

56
Q

Blending enables you to join a primary data source with secondary data sources that contain common linked dimensions.

True or False

A

True - Blending enables you to join a primary data source with secondary data sources that contain common linked dimensions.

56
Q

When using an input control for time, the time ranges must be fixed.

True or False

A

False - When using an input control for time, the time ranges can be either fixed or dynamic.

57
Q

You can use IF statements in SAP Analytics Cloud story calculations.

True or False

A

True

58
Q

What are supported calculation types?

a. Calculated Measures

b. Restricted Measures

c. Disaggregation

d. Aggregation

A

Calculated Measures

Restricted Measures

Aggregation

59
Q

You can create calculations only on measures.

True or False

A

False - You can create calculated measures and dimensions.

60
Q

You have created a story and want to show it on a mobile device. Which mobile device is supported by SAP Analytics Cloud?

a. iOS

b. Android

c. BlackBerry

A

iOS

Android

60
Q

The SAP Digital Boardroom is a fully automated tool that instantly creates relevant visualizations during a meeting. No preparation is needed before the meeting.

True or False

A

False - The content that needs to be displayed must be created and prepared in advance. You create the agenda items that you want, then you add and combine pages from stories into your topics.

61
Q

You can view a digital boardroom on multiple screens.

True or False

A

True - You can view a digital boardroom on up to 3 screens.

62
Q

Only canvas pages can be viewed on a mobile device using the SAP Analytics Cloud mobile app.

True or False

A

False - Responsive pages can be viewed in the app, but not canvas pages.