SAP C_SACS_2321 Exam Questions

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 Portal2: Difference From | SAP Help Portal3: Dimension To Measure | SAP Help Portal4: Calculated Dimensions | SAP Help Portal

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 Reference: [SAP Analytics Cloud - Table Formatting]

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 Reference: [SAP Analytics Cloud - Mobile App]

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 isAggregation, as it is the calculation type that the SAP BW live model supports. Verified Reference:

: Create Calculations in Models

: SAP BW Live Data Connection