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

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 anddifferences, 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:

• Widget: This option allows you to apply filters to a specific widget, such as a chart, table, or map, that are based on the same model. You can use the Filter area in the Builder pane to pre-filter the data that the widget displays2.
• Story: This option allows you to apply filters to all widgets in a story that are based on the same model. You can use the Story Filters tool in the Tools section to select dimensions or measures that you want to filter by2.
• 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 controls3.

The following filter options are not supported in the Optimized 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 Experience4.
• 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 Experiences.

References:

1: Choosing Between Optimized and Classic Design Modes - SAP Learning 2: Filtering Data in Optimized Design Mode - SAP Learning 3: Using Input Controls - SAP Learning 4: Chart Controls - SAP Learning : [Creating Sections - SAP Learning]

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

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]

Unbooked is the term that refers to dimension members with no numeric data values associated with them. For example, if a dimension has members A, B, C, and D, and only A and B have numeric values in a measure column, then C and D are unbooked members. Booked, transformed, and exception aggregation are not terms that describe dimension members. Verified References: [SAP Analytics Cloud - Unbooked Data]

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.

When converting a story to Optimized Design Experience, you need to be aware that some elements that are available in the Classic Design Experience are not yet supported in the Optimized Design Experience. These elements include:

• Grid pages
• Linked analysis
• Geo maps
• Images
• Shapes
• Texts
• Buttons
• Input controls
• Value driver trees
• Explorer

If your story contains any of these elements, you will receive a warning message before converting the story, informing you that these elements will be permanently deleted from the story. You can choose to proceed with the conversion or cancel it. If you proceed, the unsupported elements will be removed from the story, and you will not be able to restore them1.

This is a calculation type that you can use to categorize dimension members, according to the SAP Analytics Cloud Help1. A measure-based dimension is a dimension that is created from a measure by applying a range or a binning function1. For example, you can create a measure-based dimension called Age Group from a measure called Age by using the binning function to group the age values into different categories, such as 0-10, 11-20, 21-30, and so on1. This way, you can analyze your data by the age groups instead of the individual age values1.

The other options are not correct. Option A. Difference from is a calculation type that you can use to compare the difference between two measures or two members of a dimension2. For example, you can use this calculation type to show the difference between the sales revenue of this year and last year2. Option B. Dimension to measure is a calculation type that you can use to convert a dimension to a measure by counting the number of distinct values in the dimension3. For example, you can use this calculation type to count the number of unique customers in your data3. Option D. Calculated dimension is a calculation type that you can use to create a new dimension from an existing dimension by applying a formula or an expression4. For example, you can use this calculation type to create a new dimension called Region from an existing dimension called Country by using a formula to assign each country to a region4.

1: Measure-Based Dimensions | SAP Help Portal 2: Difference From | SAP Help Portal 3: Dimension To Measure | SAP Help Portal 4: Calculated Dimensions | SAP Help Portal

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

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

A calculated measure is a type of measure that is derived from an expression or formula based on existing measures or dimensions. You can use calculated measures to perform various calculations on your data, such as ratios, percentages, differences, etc. However, some calculated measures may result in errors or invalid values when the denominator is null or zero. For example, if you try to calculate the profit margin as (Profit / Revenue) * 100, and the revenue is zero, you will get an error. In such cases, SAP Analytics Cloud displays a symbol instead of a value for the calculated measure. The symbol that is displayed when the denominator is null or zero is # (hash sign). Therefore, the correct answer is #, as it is the symbol that is displayed when the denominator is null or zero in a calculated measure. Verified References:

• : Create Calculated Measures

You can use table templates and styling rules to change the formatting of a table in the Styling panel. Table templates allow you to apply predefined formats to tables, such as alternating row colors, grid lines, and font sizes. Styling rules allow you to apply conditional formatting to tables, such as changing the background color, font color, or icon based on certain criteria. In-cell charts and thresholds are not available in the Styling panel; they are options that can be enabled or disabled in the Builder panel. Verified References: [SAP Analytics Cloud - Table Formatting]

When you create a new story and select a responsive page, you are offered the choice of Optimized or Classic Design Experience. This choice determines the design mode that you will use to create your story. The Optimized Design Experience is the newer and more advanced design option that offers several usability improvements and performance enhancements compared to the Classic Design Experience. However, the Optimized Design Experience also has some limitations and differences, such as the unavailability of some elements that are present in the Classic Design Experience1. Therefore, you should choose the design mode that best suits your needs and preferences. You can also switch between the design modes later, but you may lose some features or formatting in the process2.

References:

1: Choosing Between Optimized and Classic Design Modes - SAP Learning 2: Switching Between Optimized and Classic Design Modes - SAP Learning

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

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

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.