C_SACS_2321 Sample Questions Answers

When you create a story using a file as the data source, you automatically create an embedded dataset. A dataset is a collection of data that is imported into SAP Analytics Cloud and can be used in a story. An embedded dataset is unique to that story and cannot be shared outside the story or refreshed. You can transform or wrangle the data in the dataset to meet your story needs in the Data Preparation area

The correct answers are A. Intersecting data only, D. All primary data, and E. All data. These are the three link types that you can use to blend data in a story, according to the SAP Learning course on Blending Data in Models1. The link type determines how the dimension data from the primary and secondary models are displayed in the blended chart or table

The Optimized Design Experience is a new design option for creating stories in SAP Analytics Cloud. It offers several usability improvements and performance enhancements compared to the Classic Design Experience. However, it also has some limitations and differences, such as the unavailability of some elements that are present in the Classic Design Experience1.

The following filter options are supported in the Optimized Design Experience:

• Input Control: This option allows you to add interactive filters to a story page that allow the story viewers to filter data, compare figures, and explore relationships directly from the page. You can use the Input Controls tool in the Tools section to select dimensions or measures that you want to use as input controls2.
• Cascading: This option allows you to create a hierarchy of input controls that depend on each other. You can use this option to filter data based on multiple levels of a dimension, such as Country, Region, and City. You can also use this option to filter data based on different dimensions that are related, such as Product Category and Product Name3.
• Section: This option is not a filter option, but a way of organizing a story into different parts based on a dimension. A section creates a separate page for each member of the dimension, and displays the same widgets on each page with the data filtered by the section dimension. Sections are available in both the Optimized and Classic Design Experiences4.

The other options are not supported in the Optimized Design Experience, because:

• Advanced: This option allows you to create complex filters using logical operators, such as AND, OR, and NOT. You can use this option to filter data based on multiple conditions or expressions, such as Revenue > 1000 AND Profit Margin < 10%. Advanced filters are available only in the Classic Design Experience.
• Controls: This option is not a valid filter option in SAP Analytics Cloud. It may refer to input controls, which are supported, or chart controls, which are not supported. Chart controls are buttons that allow you to change the chart type, switch between absolute and relative values, or drill up and down in a hierarchy. Chart controls are available only in the Classic Design Experience.

References:

1: Choosing Between Optimized and Classic Design Modes - SAP Learning 2: Using Input Controls - SAP Learning 3: Creating Cascading Input Controls - SAP Learning 4: CreatingSections - SAP Learning : [Advanced Filters - SAP Learning] : [Chart Controls - SAP Learning]

When you are adding a calculation to a table, you can choose from two options: Single or Multiple. The option determines how many new columns are added to the table based on the calculation. The options are:

• Single: Adds one new column to the table with the calculation result for the selected dimension member. For example, if you select Soft Drinks and choose Single, you will get one new column with the calculation result for Soft Drinks only.
• Multiple: Adds multiple new columns to the table with the calculation result for each dimension member. For example, if you select Soft Drinks and choose Multiple, you will get three new columns with the calculation result for Soft Drinks, Juice, and Alcohol.

Therefore, the correct answer is Selected dimension member, as it is the option that the new column is added to when you choose Single. Verified References:

• : Create Calculations in Tables

A section is a way of organizing a story into different parts based on a dimension. A section creates a separate page for each member of the dimension, and displays the same widgets on each page with the data filtered by the section dimension1. For example, if you create a section based on the Country dimension, you will have a page for each country in your data, and the charts and tables on each page will show only the data for that country.

The other options are not correct because:

• Value Driver Tree: This is a widget that allows you to create a graphical representation of how different drivers affect a key performance indicator (KPI). You can use this widget to perform simulations and what-if scenarios on your data2. However, this widget does not create a chart for each member of a dimension.
• In-Cell Charts: These are mini charts that are displayed within table cells to show the relative values of measures. You can use this feature to enhance the readability and analysis of your data3. However, this feature does not create a chart for each member of a dimension.
• Trellis: This is a feature that allows you to split a chart into multiple smaller charts based on one or more dimensions. You can use this feature to compare and contrast different segments of your data4. However, this feature does not create a separate page for each member of a dimension.

References:

1: Creating Sections - SAP Learning 2: Using Value Driver Trees - SAP Learning 3: Using In-Cell Charts - SAP Learning 4: Using Trellis Charts - SAP Learning

The data source connection that can be used in SAP Analytics Cloud to wrangle data is imported. Imported data sources are data files that are uploaded to SAP Analytics Cloud and stored in its internal database. Users can wrangle imported data sources using the Data Preparation feature, which allows them to transform, enrich, cleanse, and merge data. Live and public data sources cannot be used to wrangle data in SAP Analytics Cloud; live data sources remain in their original systems and public data sources are read-only datasets provided by SAP. Verified References: [SAP Analytics Cloud - Data Preparation]

According to the SAP Help Portal1, stories can be viewed only in portrait mode for phones and landscape mode for tablets; the stories do not rotate their orientation. This is a unique quality of viewing stories on a mobile device, as opposed to viewing them on a computer browser, where the stories can be rotated and resized according to the screen dimensions. Therefore, it is important to design stories for mobile devices using the Responsive page and the Device Preview Bar in SAP Analytics Cloud Story Design.

The design options that are available when you create a new story are optimized and classic. Optimized design option allows users to create stories using an intuitive and simplified interface, with fewer options and more automation. Classic design option allows users to create stories using a full-featured and flexible interface, with more options and more control. CSS and style are not design options when you create a new story; they are concepts related to web development and formatting. Verified References: [SAP Analytics Cloud - Story Design Options]

You can define a calculation for a table in three ways:

• Table: You can add a simple calculation by selecting two measures in a table, right-clicking, choosing Add calculation, and choosing the calculation you want. You can also add a repeating or single column or row to a table by right-clicking on a measure or dimension and choosing Add Calculation1.
• Calculation editor: You can open the calculation editor from the drop-down menu of Measures or Dimensions in the Designer Panel and create complex calculations for a chart or table. For each type of calculation, a new calculated member is created. You can also use dimension attributes as part of a calculation2.
• Story: You can create a calculated measure in the Builder pane of a story. When setting up your calculation, you apply the typical formula functions, conditions, and operators to the data contained in your model. Calculated measures allow you to perform mathematical and Boolean operations on your data1.

References:

1: Calculating Data in Stories - SAP Learning 2: SAP Analytics Cloud In-story Calculation Series – An Introduction

A data source is an object that contains data that you can use to create stories or other objects in SAP Analytics Cloud. There are four types of data sources in SAP Analytics Cloud:

• Model: A model is a structured representation of your data that defines how the data is organized and calculated. You can create models by importing data from various sources or connecting to live data systems.
• Dataset: A dataset is a type of data source that allows you to import data from files

The link type determines how the data from the primary and secondary models are blended in a story. There are three link types: Primary, All, and Intersection1.

• Primary: Only the data from the primary model that matches the data from the secondary model is displayed. This is equivalent to an inner join in SQL.
• All: All the data from both models is displayed, regardless of whether they match or not. This is equivalent to a full outer join in SQL.
• Intersection: Only the data that exists in both models is displayed. This is equivalent to an intersection in set theory.

In this case, the link type that returns what data is Intersection, because it only shows the data that is common to both models, such as Customer A and Customer B. Customer C and Customer D are excluded because they do not exist in both models.

When a model includes a prompt, the prompt is presented at runtime before data can be displayed in the story. The prompt allows users to select the values they want to filter the data by. The prompt is not related to the predefined widgets, the rendering of widgets, or the navigation to widgets. Verified References: [SAP Analytics Cloud - Prompting]

Story filters are a feature that allows you to filter the data in a story based on one or more dimensions or measures. You can use story filters to do the following:

• They can be applied to all widgets based on the same model. You can choose which widgets are affected by the story filter and which are not.
• They can be used to create dynamic titles or text based on the filter values. You can insert filter tokens into titles or text elements to show the current filter values.
• They can be used to create input controls that allow users to change the filter values interactively. You can add input controls such as drop-down lists, sliders, checkboxes, etc., to let users select their own filter values.

Story filters cannot do the following:

• They cannot be implemented without a model in a template. You need to have a model as a data source for your story before you can apply story filters.
• They cannot be used to change dimensions in a widget. You cannot use story filters to swap dimensions in a widget. You have to use the chart builder or the table builder to change dimensions in a widget.

Therefore, the correct answer is They can be applied to all widgets based on the same model, as it is what can be done with story filters. Verified References:

• : Filter Data in Stories

Linked Analysis is a feature that allows you to link multiple widgets in a story based on the same model. You can use Linked Analysis to do the following:

• Filter data in multiple widgets by selecting a data point in one widget. For example, if you select Soft Drinks in a chart, all the other linked widgets will show data for Soft Drinks only.
• Drill down or up in multiple widgets by changing the level of detail in one widget. For example, if you drill down from Product Category to Product Name in a table, all the other linked widgets will show data for Product Name as well.
• Highlight data in multiple widgets by hovering over a data point in one widget. For example, if you hover over Germany in a geo map, all the other linked widgets will highlight the data for Germany.

To use Linked Analysis, you need to have the following:

• Multiple widgets based on the same model. You can link any type of widget, such as charts, tables, geo maps, etc., as long as they are based on the same model.
• A common dimension or measure between the widgets. You can link widgets based on any dimension or measure that they share in common.

You do not need to have the following for Linked Analysis:

• Multiple stories. You can use Linked Analysis within the same story. You cannot link widgets across different stories.
• Multiple data models. You can use Linked Analysis with one model only. You cannot link widgets based on different models.
• Multiple pages. You can use Linked Analysis within the same page. You cannot link widgets across different pages.

Therefore, the correct answer is Multiple widgets, as it is the necessary element for Linked Analysis. Verified References:

• : Link Widgets with Linked Analysis

You can add a section to a canvas page in a story. A section is a container that holds one or more widgets and can be used to group related content or apply filters. A digital boardroom, a table, and a chart are not valid targets for adding a section; they are either different types of presentations or widgets that can be added to a section. Verified References: [SAP Analytics Cloud - Sections]