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

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.

The model setting Optimize Story Building Performance prevents the automatic refresh of data during story design. This means that users can design stories without waiting for the data to load every time they make a change. Users can manually refresh the data when they want to see the updated results. The model setting does not affect the design experience, the parallel processing, or the story editing. Verified References: [SAP Analytics Cloud - Optimize Story Building Performance]

The Digital Boardroom is a feature that allows you to create immersive and interactive presentations based on stories. You can use the Digital Boardroom to present your data and insights on multiple screens connected to a single device. The Digital Boardroom supports up to three screens that can display different views of the same story or different stories. Therefore, the correct answer is 3, as it is the maximum number of screens you can connect to the Digital Boardroom. Verified References:

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 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

You can define thresholds in the model or in the story. Thresholds are rules that apply conditional formatting to measures based on certain criteria, such as values, ranges, or percentages. You can define thresholds in the model to apply them to all stories that use the model, or you can define thresholds in the story to apply them to a specific widget or page. You cannot define thresholds in the input control or in the page; these are different types of elements that can be used in a story. Verified References: [SAP Analytics Cloud - Thresholds]

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

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 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.

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

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

These are two of the options that you can use for data wrangling when you import a file for a story in SAP Analytics Cloud, according to the SAP Help Portal1. Data wrangling is the process of cleaning, structuring, and enriching raw data into a desired format for better decision making in less time2.

The custom expression editor is a tool that allows you to create or edit formulas and expressions for your data columns3. You can access the custom expression editor by clicking on the formula icon in the builder panel or by double-clicking on a column header in the data view3. The custom expression editor provides a list of functions and operators that you can use to manipulate your data, such as arithmetic, logical, string, date, and aggregation functions3. You can also use the custom expression editor to create calculated columns or measure-based dimensions from your existing columns3.

The transform bar is a tool that allows you to apply various transformations to your data columns, such as renaming, reordering, grouping, splitting, merging, or deleting columns4. You can access the transform bar by clicking on the transform icon in the builder panel or by right-clicking on a column header in the data view4. The transform bar provides a list of actions that you can use to modify your data structure, such as move left, move right, group by, split by delimiter, merge columns, or delete column4. You can also use the transform bar to change the data type or format of your columns, such as text, number, date, currency, or percentage4.

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 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