Unit 3: Configuring Data Actions Flashcards
What is a data action?
A. A tool for generating automated reports
B. A flexible planning tool for making structured changes to planning data
C. A feature for analyzing complex data sets
D. A tool for designing and running data models
B
What is the difference between a modeler and a planner?
A. Modelers design the data actions and planners run them in stories or schedule them in the calendar.
B. Modelers analyze data and generate reports, while planners make decisions based on those reports.
C. Modelers manage user access and permissions, while planners enter data into the system.
D. Modelers create visualizations and dashboards, while planners review and approve them.
A
What are some common use cases for data actions?
A. Generating automated reports
B. Carrying out planning tasks automatically, copying data within and across models, performing allocations, currency translation, and calculations
C. Analyzing complex data sets
D. Creating visualizations and dashboards
B
What does a data action consist of?
A. Multiple reports generated from various data sources.
B. An automated process for scheduling data backups.
C. A set of predefined filters applied to a dataset.
D. A data action is created based on a planning model and consists of one or more steps carried out on a public or private version.
D
TRUE OR FALSE
Data actions are used to process mass amounts of data.
TRUE
What are some features of data actions?
A. Sequence data action steps
B. Embed data actions (just like an include)
C. Organize data actions into folders for better management
D. Schedule or ad-hoc execution
E. Include prompts for flexibility
F. Integrate prompts and story filters
There are 5 correct responses
A, B, D, E, F
TRUE OR FALSE
Recent data actions will not show in the Recent Files section of your home screen.
FALSE
Recent data actions will also show in the Recent Files section of your home screen.
What are 2 ways a data action can be created?
A. Navigation Bar
B. Data Modeling Interface
C. Files
There are 2 correct responses
A, C
How are steps in a data action processed?
A. Randomly
B. Simultaneously
C. Sequentially
D. Interdependently
C
Steps in a data action are executed sequentially.
The result of one step is available for the subsequent steps.
For each step, the execution scope is defined via filters.
What are the types of Data Action steps available?
A. Copy action
B. Cross-model copy action
C. Advanced formulas action
D. Data import action
E. Allocation action
F. Embedded data action
G. Conversion data action
There are 6 correct answers
A, B, C, E, F, G
1/6
Describe the following Data Action step:
Copy action
Copies data within a model based on a set of rules, filters, and aggregation settings.
For example, you can use it to copy data from 2018 to 2019 or Actual data to Budget data.
With the Copy action, you copy a value from only one dimension member, but you can copy to multiple dimension members.
2/6
Describe the following Data Action step:
Cross-model copy action
Allows you to copy data from a different source planning model based on a set of filters and automatic or manual mapping between dimension members.
3/6
Describe the following Data Action step:
Advanced formulas action
Allows you to create calculations to apply to the data.
For example, you can use scripting to calculate opening and closing balances of headcount based on hires and terminations, looping through the data by time.
4/6
Describe the following Data Action step:
Allocation action
Creates a new allocation or use an existing allocation step.
5/6
Describe the following Data Action step:
Embedded data action
Runs another data action as part of the one you’re working on.
Combining these steps with dynamic parameters lets you reuse data actions with different source or target members.
6/6
Describe the following Data Action step:
Conversion data action
Used for models with measures.
Conversion steps let you copy between measures while applying currency conversion.
Data Action parameters
What is the purpose of setting parameters in data actions?
A. To display additional information about the data action
B. To create variables for use in data visualizations
C. To provide prompts for flexibility and dynamic execution
D. To define the execution sequence of the data action
C
Data Action parameters
What are these prompts, as a result of setting parameters?
A. Parameter variables
B. User instructions
C. Execution logs
D. Prompts are like variables, in that they make the data actions flexible and dynamic.
D
What 4 things are parameter Values determined by?
A. Member selection in the story
B. Default values in the data action parameter definition
C. A story filter
D. An input control
E. User input during data action execution
A, B, C, D
What are the 2 parameter types in SAP Analytics Cloud?
A. Member
B. Text
C. Number
D. Date
A, C
What is the Member parameter type?
Creates a parameter that represents a dimension member.
For example, this type of parameter lets you change the year that you’re copying data to or from.
What is the Number parameter type?
Creates a parameter that has a numeric value.
For example, this type of parameter is added to advanced formulas, and can let you prompt users for values such as growth rate or gross margin percentage.
Parameter properties
What is a property of a Parameter in SAP Analytics Cloud?
A. Default value
B. Data type
C. Description
D. Model assignment
D
What can the Model assignment be set to in SAP Analytics Cloud Parameter Properties?
A. Default Model
B. Specific Model
C. Current Model
D. Random Model
There are 2 correct responses
A and B
If the Model assignment is set to the Default Model, where is the model inherited from?
A. The current user’s model
B. The data action header
C. The first model in the list
B
The Model assignment is set to a Specific Model.
In a copy step, where is the model inherited from?
A. The same model as in the data action header
B. The source model
C. The target model
D. Either the source or target model
A
The Model assignment is set to a Specific Model.
In a cross-model copy step, where is the model inherited from?
A. The same model as in the data action header
B. The source model
C. The Target model
D. Either the source or target model
D
TRUE OR FALSE
When a parameter is used to select the source member, the Cardinality must be set to a Single member.
TRUE
What are 4 ways data actions can be executed?
A. From a data model.
B. From a story.
C. From an extended story.
D. From the SAP Analytics Cloud calendar.
E. From SAP Analytics Cloud, Add-in for Microsoft Office.
B, C, D, E
In this section, we’ll focus on using the SAP Analytics Cloud calendar to schedule the data action as a task.
Why would a user schedule a Data Action from the Calendar?
A. To organize their schedule better.
B. To ensure the Data Action runs during the day.
C. If a data action takes a few minutes to run, you can schedule it to run at night.
C
What is a multi action?
A. A single action performed across multiple models.
B. A multi action could include several data actions as well as import steps.
B
What is the difference between modelers and planners?
A. Modelers focus on data analysis while planners focus on data entry.
B. Modelers design the user interface while planners use it.
C. Modelers design the data actions and planners run them in stories or schedule them in the calendar.
C
Fill in the blank
A data action is created based on a ____ model and consists of one or more steps that are carried out on a public or private version.
A. Data
B. Planning
C. Structural
B
What are the possible statuses of a data action in the Calendar?
A. Pending, In Progress, Complete
B. Open, Successful, Failed
C. Active, Completed, Aborted
B
Match each status with the correct timeframe:
1 - Open
2- Failed
3- Successfull
A. Before the data action runs
B. After it runs with no issues
C. If something goes wrong
1 - A
2 - C
3 - B
TRUE OR FALSE
When scheduling a data action, prompts must have assigned parameter values.
TRUE
Can you publish the target version automatically if you’re running the data action on a BPC write-back model?
No, You’ll need to publish the version manually.
If you choose “Publish target version automatically” as a Follow-Up Action in the data action panel, then after the data action finishes:
A. All unpublished changes to the target version will be published, even if they weren’t part of the data action.
B. All unpublished changes to the target version will be published, only if they were part of the data action.
A
TRUE OR FALSE
Data actions can be used in other data actions that belong to the same model.
TRUE
For example, you create a data action that calculates subscription revenue based on booking data, with a dynamic parameter for the product type. Using embedded data action steps, you can reuse that data action multiple times in another data action and you can specify a different product type each time.
TRUE OR FALSE
Embedded data actions increases the cost of development and maintenance.
FALSE
Lowers the cost of development and maintenance.
List 3 features of embedded data actions.
- Parameters of outer data actions can be linked against required parameters of inner data actions.
- Parameters of inner data actions aren’t prompted on execution; each must be assigned a value in the designer.
- You can’t use a data action within itself.
When can you use the Data Action Monitor to check the status of the scheduled data action?
A. When data actions are scheduled from the SAP Analytics Cloud calendar.
B. When data actions are executed manually from the Data Action Monitor.
C. When data actions are executed from a story.
There are 2 correct answers.
A and C
What does the Data Action Monitor show?
A. When the data action was triggered
B. Who triggered the data action
C. Details of the data action steps executed
D. Which values were used as parameters
E. Number of records and duration
F. Data action execution status
G. Where the data action was triggered
H. The data action job history will remain based on a retention period of 30 days (default)
There are 6 correct responses
A, B, D, E, G, H
What does a copy action allow you to do?
A. Copy data from one set of members to another, specifying options for filters and aggregation.
B. Copy data only within the same set of members.
C. Exclude options for filters and aggregation.
D. Copy data without specifying any conditions.
A
TRUE OR FALSE
The copy rule doesn’t allow the use of version.
Instead, use a parameter for the source version. The source version parameter is then added to the context which will result in a prompt.
TRUE
TRUE OR FALSE
Every data action will always prompt for the target version regardless of whether the target version prompt is in the filter or not.
TRUE
TRUE OR FALSE
Every data action has a system-provided Filter for Version. The default version filter is the target version prompt.
TRUE
