SAP C_SACS_2316 Study Guide Archives Updated on Jul 25, 2024 [Q35-Q57]

The Custom Expression Editor is a tool that allows you to create complex calculations using a syntax called Wrangling Expression Language (WEL). WEL is a domain-specific language that is designed for data manipulation and analysis. WEL supports various operators, functions, and constants that you can use to create custom expressions. You can access the Custom Expression Editor from various places in SAP Analytics Cloud, such as models, stories, datasets, etc. Therefore, the correct answer is Wrangling Expression Language, as it is the language that the Custom Expression Editor uses. Verified Reference:Create Custom Expressions with the Custom Expression Editor

The correct answers are C. Have a clear message and D. Use corporate branding standards. These are some of the guidelines that SAP recommends you follow when you create a story. According to the course material1, “Your current reporting and dashboard standards will suffice for SAP Analytics Cloud stories. And if you do not have reporting or dashboard standards, this is the perfect time to create them.” The course material also suggests that you should “have a clear message and purpose for your story” and “use corporate branding standards to ensure consistency and professionalism”1.
The other options are not mentioned as guidelines in the course material. Option A) Use grouping is a feature that allows you to group data points in a chart or table, but it is not a general design principle. Option B. Avoid pie charts is a common advice for data visualization, but it is not specific to SAP Analytics Cloud stories.
1: Introducing SAP Analytics Cloud Story Design | SAP Training 2

An input control is a type of filter that allows you to dynamically change the values of dimensions or measures in your story or application. You can use an input control to filter dimension or measure values and select dimension or measure values for your widgets, such as charts, tables, or geo maps1. For example, you can create an input control that lets you choose which product category or year to display in your chart2.
You cannot use an input control to define a prompt or explore data relationships. A prompt is a filter that is applied to a model before the data is loaded into a story or an application. Prompts allow you to select the data that you want to see in your story or application. You can create prompts in the modeler, not in the story or application3. To explore data relationships, you can use the Smart Discovery feature, which allows you to automatically generate insights and visualizations based on your dat a. You can access Smart Discovery from the context menu of a chart or table widget4.

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.
Reference:
1: Calculating Data in Stories – SAP Learning 2: SAP Analytics Cloud In-story Calculation Series – An Introduction

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.
Reference:
1: Choosing Between Optimized and Classic Design Modes – SAP Learning 2: Using Input Controls – SAP Learning 3: Creating Cascading Input Controls – SAP Learning 4: Creating Sections – SAP Learning : [Advanced Filters – SAP Learning] : [Chart Controls – SAP Learning]

According to the SAP Help Portal1, SVG (Scalable Vector Graphics) is the recommended image file type for optimal story performance in SAP Analytics Cloud Story 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 dat a. 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 story option that can help you create a story as a launchpad to other stories is hyperlink. A hyperlink is a link that allows users to navigate from one location to another by clicking on it. You can use hyperlinks to link widgets, text, or images in a story to other stories in SAP Analytics Cloud, creating a launchpad effect. Input control, linked analysis, and RSS feed are not story options that can help you create a story as a launchpad to other stories; they are options that can help you filter data, link widgets, or display news feeds in a story. Verified Reference: [SAP Analytics Cloud – Hyperlinks]

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 Reference: [SAP Analytics Cloud – Optimize Story Building Performance]

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 Reference: [SAP Analytics Cloud – Unbooked Data]

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

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 to measure and aggregation are not calculation types; they are functions that can be used in calculations. Verified Reference: [SAP Analytics Cloud – Input Controls]

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 Reference: [SAP Analytics Cloud – Sections]

The valid targets for hyperlinks are external websites, SAP Analytics Cloud stories, and SAP Analytics Cloud story pages. External websites are web pages that are outside of SAP Analytics Cloud, such as https://www.sap.com. SAP Analytics Cloud stories are presentation-style documents that use charts, visualizations, text, images, and pictograms to describe dat a. SAP Analytics Cloud story pages are individual pages within a story that contain one or more widgets. SAP BusinessObjects Web Intelligence documents and SAP Analysis for Microsoft Office workbooks are not valid targets for hyperlinks; they are different types of documents that are not supported by SAP Analytics Cloud. Verified Reference: [SAP Analytics Cloud – Hyperlinks]

The SAP BW live model is a type of live data connection that allows you to access data from SAP Business Warehouse (BW) systems without importing it into SAP Analytics Cloud. The SAP BW live model supports the following calculation types:
Aggregation: You can use aggregation functions, such as SUM, COUNT, MIN, MAX, etc., to calculate the values of a measure based on a dimension or a filter.
Currency conversion: You can use currency conversion to convert the values of a measure from one currency to another based on predefined exchange rates.
Unit conversion: You can use unit conversion to convert the values of a measure from one unit of measurement to another based on predefined conversion factors.
The SAP BW live model does not support the following calculation types:
Dimension to measure: You cannot convert a dimension to a measure in a SAP BW live model.
Date difference: You cannot calculate the difference between two dates in a SAP BW live model.
Story calculation: You cannot create story calculations in a SAP BW live model.
Therefore, the correct answer is Aggregation, as it is the calculation type that the SAP BW live model supports. Verified Reference:
1: Create Calculations in Models
2: SAP BW Live Data Connection