In SAP Analytics Cloud, when creating a styling rule for a table that uses a hierarchy, the scope of the rule's application is defined by level options. To apply a style exclusively to the members of a specific hierarchical level, such as 'Country', the 'Self' option must be used. This option ensures that the formatting is applied only to the selected level itself, without affecting any parent, child, or sibling members in the hierarchy. This directly fulfills the requirement of styling only the countries.

A. Self and Siblings: This is incorrect because it applies styling to a selected member and other members at the same hierarchical level, which is less direct than styling the entire level via the 'Self' option.

B. Self and Children: This is incorrect as it would apply the style to the 'Country' level and the next level down, 'Region', which violates the requirement to style only countries.

C. Self and Descendants: This is incorrect because it would apply the style to the 'Country' level and all levels below it ('Region' and 'City'), which is not the desired outcome.

SAP Help Portal

SAP Analytics Cloud Documentation

"Applying Thresholds to a Table". The options for applying styling rules are identical to those for thresholds. The documentation specifies the scope of application for each option. The 'Self' option is defined as applying the rule only to the selected members (or level).

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/4181509142f542489b9257a1a3e41e64.html (This page describes the scope options for thresholds

which include "Self"

"Self and Children"

and "Self and Descendants"

confirming the functionality for hierarchical styling.)

SAP Help Portal

SAP Analytics Cloud Documentation

"Styling a Table". This section details the various formatting and styling options available for tables

including the creation of rules that can be applied to specific dimensions

measures

or hierarchy levels.

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/88133a8527c84c6d943b12246d4b143f.html

In the SAP Analytics Cloud modeler, Dimension Groups are used to organize the list of dimensions into logical categories or folders. This feature is particularly useful in complex models with numerous dimensions, as it enhances readability and simplifies model management. By creating groups, modelers can logically structure dimensions (e.g., by business area like "Sales," "Finance," or "HR"), making the model easier to navigate and understand. This capability is part of the modeling experience for both live and acquired data models.

A. Level-based hierarchy: Incorrect. This organizes members within a single dimension into distinct levels (e.g., Country, State, City), not the dimensions themselves into categories.

C. Value driver tree: Incorrect. This is a specific visualization widget used within stories for what-if analysis and simulations, not a feature for organizing dimensions in a model.

D. Parent-child hierarchy: Incorrect. This defines relationships between individual members within a dimension to create a hierarchy, but it does not organize the dimensions themselves.

1. SAP Help Portal - Create a New Model with the New Model Experience: "You can organize your dimensions into groups. In the Dimensions panel

select (Add Group) to create a new group. Then you can drag and drop dimensions into the group." This documentation explicitly describes the use of "Groups" to organize dimensions.

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/d95875a16d53407e806613635119145c.html (Section: "Work with Dimensions")

2. SAP Help Portal - About the New Model in SAP Analytics Cloud: This document confirms that the new modeling experience

which includes dimension groups

is available for live data models. "The new model is available for both acquired data and live data from SAP HANA and SAP S/4HANA."

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/01b799024b694238a570911b8755a127.html

In SAP Analytics Cloud advanced formulas, the SIGNFLIP option is used within a DATA() statement to reverse the sign of the source values before they are written to the target member. This is essential for financial calculations involving accounts with different accounting conventions, such as totaling income (typically stored as credit/negative values) and expense (debit/positive values) accounts. By using SIGNFLIP on income accounts, their signs are reversed, allowing them to be correctly aggregated with expense accounts to calculate metrics like Gross Profit or Net Income.

A. Unbooked: This option specifies whether to write values to target data cells that have no existing data. It does not perform any mathematical operation like sign reversal.

B. Append: This is a general data loading concept, not a specific configuration option within an advanced formula calculation step. The OVERWRITE parameter controls this behavior in a data action.

D. Aggregate To: This describes the goal of the action but is not an actual keyword or configuration option in the advanced formula syntax for handling account signs.

SAP Help Portal - SAP Analytics Cloud

Add a DATA Statement to an Advanced Formula: "You can use the SIGNFLIP keyword to reverse the sign of the source values. This is useful for financial calculations

for example

when you want to add expenses to revenues." (SAP Help Portal

SAP Analytics Cloud > Modeling > Calculating Data with Advanced Formulas for Planning).

SAP Help Portal - SAP Analytics Cloud

Advanced Formulas Keywords: This page details the syntax and usage of keywords in advanced formulas. The SIGNFLIP keyword is explicitly defined for reversing the sign of source data. The other options listed are either not keywords (Aggregate To

Append) or serve a different purpose (UNBOOKED). (SAP Help Portal

SAP Analytics Cloud > Modeling > Calculating Data with Advanced Formulas for Planning).

Input controls in an SAP Analytics Cloud story serve as interactive filters, allowing story viewers to customize their data analysis. They can be configured to filter data across a page or the entire story based on dimension members (e.g., filtering for a specific year or region). Additionally, they can be used to dynamically change the measures or dimensions displayed in charts and tables, enabling users to switch their analytical perspective (e.g., from viewing 'Sales' to 'Quantity Sold' or from 'Region' to 'Product'). This provides a flexible and user-driven exploration experience.

C. Selecting an alternate data source: This is incorrect. Data source selection is a design-time configuration for a widget within the story builder, not a function managed by a user-facing input control.

D. Implementing row-level and column-level security in a table: This is incorrect. Data security is enforced at the model level through Data Access Controls, which automatically filter data based on user permissions, not through interactive story controls.

1. SAP Help Portal - Input Controls: "Input controls are story or page filters that you can add to a story to allow viewers to filter data in charts... You can also create an input control on measures

allowing viewers to select which measures appear in the chart." This source directly supports options A and B.

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/13864d734469401d953261b91522f653.html

2. SAP Help Portal - Applying a Story or Page Filter: This page details how input controls function as filters for pages or the entire story

reinforcing the correctness of option B.

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/d2f76178323a45a489087a1793b2bd62.html

3. SAP Help Portal - Data Security in the Modeler: "To secure your model

you can set up data security... This involves activating data security on your model and setting up read and write permissions for roles." This confirms that security (Option D) is a model-level function.

URL: https://help.sap.com/docs/SAPANALYTICSCLOUD/00f68c2e08b941f081002fd3691d86a7/b4b79672b5e446c184b3b4a714e082b1.html

Enabling "Advanced Mode" in an SAP Analytics Cloud story unlocks the capabilities previously found in the standalone Analytic Application Designer. This primarily includes the ability to use scripting to create highly interactive and customized application-like experiences. Adding JavaScript to a widget's events (A) is the core of this scripting functionality. Furthermore, Advanced Mode makes specific widgets available that are essential for application design, such as the Popup (B), which is used to create dialogs and is controlled via scripts.

C. Add a layer to a geo map: This is a standard configuration performed in the Builder panel for the geo map widget and does not require the scripting or advanced widget capabilities of Advanced Mode.

D. Add a custom widget: While using custom widgets does require Advanced Mode, Popups (B) are a standard, built-in widget universally available with Advanced Mode, making it a more fundamental answer than custom widgets, which depend on prior development and deployment.

1. Official SAP Documentation on Advanced Mode: The SAP Help Portal explicitly states that enabling Advanced Mode allows the use of "scripting

eventing

and advanced widgets like the timer and the popup." This directly supports answers A and B.

Source: SAP Help Portal

"Enabling Advanced Mode". (Please search on help.sap.com for the latest version of the "SAP Analytics Cloud" documentation

as direct links can become outdated. The section is within the Story Design or Analytic Application Design area).

2. Official SAP Documentation on Geo Maps: The process for adding layers to a geo map is detailed as a standard feature within the widget's Builder Panel

with no prerequisite for Advanced Mode.

Source: SAP Help Portal

"Adding Layers to a Geo Map". (Search on help.sap.com for the "SAP Analytics Cloud" documentation).

3. Official SAP Documentation on Custom Widgets: The documentation confirms that custom widgets are used in the advanced design environment ("analytic applications")

but they are distinct from the core

built-in advanced widgets like Popups.

Source: SAP Help Portal

"Using Custom Widgets". (Search on help.sap.com for the "SAP Analytics Cloud" documentation).