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

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.

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

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

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

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

SAP Datasphere is a data source that does not require a model to be created in SAP Analytics Cloud. You can use a SAP Datasphere connection to access or import data directly into your story, with no need for a SAP Analytics Cloud model to be created1

SAP Business Warehouse, SAP S/4HANA, and SAP BusinessObjects Web Intelligence document are data sources that require a model to be created in SAP Analytics Cloud. You cannot access or import data from these sources directly into your story, but you need to create a model in SAP Analytics Cloud using the connections to these sources234

Using the SAP Analytics Cloud mobile app, the page type that is required for viewing stories is responsive. Responsive pages are designed to adapt to different screen sizes and orientations, making them suitable for mobile devices. Canvas and grid pages are not supported by the mobile app; they are designed for desktop browsers and fixed layouts. Verified References: [SAP Analytics Cloud - Mobile App]

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

• : Create Custom Expressions with the Custom Expression Editor

The sort options that are available in stories are ascending and descending order, and multiple dimensions together. Ascending and descending order allow you to sort data by one or more dimensions or measures in ascending or descending order. Multiple dimensions together allow you to sort data by more than one dimension in a hierarchical order. Dimensions and measures together, and multiple measures together are not valid sort options in stories. Verified References: [SAP Analytics Cloud - Sorting]

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

The Optimized Design Experience is a new user interface for SAP Analytics Cloud that simplifies and enhances the story design process. The Optimized Design Experience introduces some new elements and tools, such as Data Analyzer, Point of Interest, Time Series chart, etc. However, it also removes some elements and tools that are available in the Classic Design Experience, such as Grid page, Explorer, Digital Boardroom, etc. Therefore, the correct answer is Grid page, as it is the element that is not available in the Optimized Design Experience. 

The SAP Analytics Cloud mobile app allows users to view and interact with stories, collaborate with colleagues using comments and notifications, and share links to stories via email or other apps. Users cannot create stories, datasets, or models using the mobile app. Verified References: [SAP Analytics Cloud - Mobile App]

In the Optimized Design Experience, Data Analyzer is a new tool that replaces Explorer. Data Analyzer allows you to quickly create ad hoc analysis based on models or datasets. You can use Data Analyzer to explore data, create charts and tables, apply filters and calculations, and save your analysis as stories. Data Analyzer is similar to Explorer, but with some enhancements and new features, such as:

• Support for both models and datasets
• Support for planning models
• Support for story calculations
• Support for linked analysis
• Support for responsive pages

Therefore, the correct answer is Data Analyzer, as it is the tool that replaces Explorer in the Optimized Design Experience

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

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