C_SACS_2321 SAP Certified Application Associate - SAP Analytics Cloud Story Design Questions and Answers

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

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

When you save a story as a template, you can use it as a starting point for creating new stories with the same layout and formatting. However, all the data from the original story is removed and replaced by placeholders for charts, tables, maps, input controls, and value driver trees. This way, you can easily add new data sources and models to the template without affecting the existing ones1. Custom formatting, such as story background, chart color palettes, fonts, and borders, is retained in the template2. Custom widgets, such as images, shapes, texts, and buttons, are also preserved in the template3. Standard widgets, such as charts, tables, maps, input controls, and value driver trees, are converted into empty placeholders that can be filled with new data3.

References:

1: Create and Use Story Templates 2: Story Templates in SAP Analytics Cloud 3: Building Stories from a Template

The calculation types that support input controls are restricted measure, calculated measure, and difference from. A restricted measure is a measure that is filtered by one or more dimensions. A calculated measure is a measure that is derived from an expression using other measures and dimensions. A difference from is a measure that shows the difference between two values based on another dimension. Dimension tomeasure and aggregation are not calculation types; they are functions that can be used in calculations. Verified References: [SAP Analytics Cloud - Input Controls]

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]

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]

This is one of the story guidelines recommended by SAP Analytics Cloud. According to the course material1, “When designing your stories, keep them as simple as possible. In general, it is easier for users to consume story content if it is present in smaller bits rather than have a few large stories with many pages to navigate.” The other options are not mentioned as guidelines in the course material.

1: Introducing SAP Analytics Cloud Story Design | SAP Training 2

When break grouping is enabled, the sort is applied to the inner dimension of the chart or table, according to the SAP Analytics Cloud Help1. Break grouping is a feature that allows you to sort data points in a chart or table by breaking the grouping of the dimensions in the category axis2. For example, if you have a chart with two dimensions in the category axis, such as Country and Product, and you enable break grouping, you can sort the data points by Product instead of Country2. This can help you compare the performance of different products across countries. You can also choose to sort by measure values or custom order2.

The other options are not correct. Option A. The outer dimension is the dimension that is not affected by the break grouping feature. Option C. The vertical dimension and option D. The horizontal dimension are not relevant terms for break grouping, as it depends on how you arrange the dimensions in the category axis.

1: Apply Smart Grouping to Charts in Analytic Applications | SAP Help Portal 2: Sort Data Points in Charts and Tables | SAP Help Portal

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]

A section is a way to group and organize widgets in a story based on a dimension. To create a section, you need to have the following:

• A dimension that you want to use as the basis for grouping the widgets. You can choose any dimension from any model in the story.
• One or more widgets that you want to display in each section. You can add any type of widget, such as charts, tables, geo maps, etc.

You can create sections in both the Classic Design Experience and the Optimized Design Experience, but the process is slightly different. Therefore, the correct answer is dimension and widget, as they are required to configure a section in a story

A public dataset is a type of dataset that is shared among different stories. You can use public datasets to create stories or blend data with models. A public dataset has the following properties:

• It can be shared among different stories. You can use public datasets in multiple stories without having to import them again.
• It cannot be converted to a model. You cannot convert a public dataset to a model. If you want to create a model from a public dataset, you have to import it as a private dataset first.
• Its data is not structured in a star schema. A public dataset does not have any predefined dimensions or measures. It only has columns and rows of data.
• Its data source cannot be changed. You cannot change the data source of a public dataset after you import it. If you want to update the data in a public dataset, you have to import a new file.

According to the SAP Help Portal1, SVG (Scalable Vector Graphics) is the recommended image file type for optimal story performance in SAP Analytics CloudStory Design. SVG is a vector-based format that can scale to any size without losing quality or clarity. SVG images also have a smaller file size than other image formats, such as JPEG, PNG, or BMP, which are raster-based formats that store pixel data. Raster images can lose quality or become blurry when scaled up or down, and they also have a larger file size than vector images. Therefore, using SVG images can improve the loading speed and responsiveness of your stories, as well as the visual appearance of your images2.

Chart scaling is a feature that ensures that you have a meaningful display of values across multiple charts in a story. By default, charts are not scaled, which can lead to incorrect data analysis, particularly if users are not paying attention to the actual values displayed in the chart1.

Chart scaling is applied to the following:

• Specific page: Chart scaling is applied to all of the charts on a page, but the scaling may be different for the same measure on different pages, because the scaling factor is calculated separately for each page1.
• Specific measure: Chart scaling is applied to a specific measure in a chart, and it affects all the charts that contain that measure on the same page. You can exclude charts from the scaling by selecting the chart and choosing Exclude from Scaling in the context menu1.

Chart scaling is not applied to the following:

• All measures: Chart scaling is not applied to all the measures in a story, only to the ones that are selected for scaling. You can select which measures to scale by choosing Scale Measures in the context menu of any chart on a page1.
• All pages: Chart scaling is not applied to all the pages in a story, only to the ones that have scaling enabled. You can enable or disable scaling for a page by choosing Enable Scaling or Disable Scaling in the context menu of any chart on a page1.

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]

 Explanation: According to the SAP Help Portal1, you can configure different add-ons for a chart to enhance its appearance and functionality. Some of the add-ons that are available are:

• Variance: This add-on allows you to compare two measures and show the difference and percentage difference between them. You can also choose to display the variance as a bar, line, or area chart on top of the original chart2.
• Scaling: This add-on allows you to adjust the scale of the chart axes to better fit the data range. You can choose to use a linear, logarithmic, or percentage scale for the axes3.
• Linked Analysis: This add-on allows you to link multiple charts or tables that share the same data source. When you select a data point in one chart or table, the other linked charts or tables will filter accordingly4.
• In-Cell Charts: This add-on allows you to display mini charts within the cells of a table. You can choose from different types of in-cell charts, such as bullet, bar, or sparkline charts5.

Therefore, Variance and In-Cell Charts are add-ons that can be configured for a chart, while Scaling and Linked Analysis are not.