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

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

The presentation types for the Digital Boardroom are dashboard and agenda. Dashboard allows users to create a custom layout of widgets and pages on a large screen, such as a wall-mounted monitor or a projector. Agenda allows users to create a structured sequence of pages and topics that can be navigated using a touch screen, such as a tablet or a laptop. Custom and canvas are not presentation types for the Digital Boardroom; they are options that can be used to design dashboard layouts or story pages. Verified References: [SAP Analytics Cloud - Digital Boardroom]

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 References: [SAP Analytics Cloud - Hyperlinks]

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.

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.

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

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.

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]

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.

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]

The data source connection that can be used in SAP Analytics Cloud to wrangle data is imported. Imported data sources are data files that are uploaded to SAP Analytics Cloud and stored in its internal database. Users can wrangle imported data sources using the Data Preparation feature, which allows them to transform, enrich, cleanse, and merge data. Live and public data sources cannot be used to wrangle data in SAP Analytics Cloud; live data sources remain in their original systems and public data sources are read-only datasets provided by SAP. Verified References: [SAP Analytics Cloud - Data Preparation]

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

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