A financial analyst is building a story in SAP Analytics Cloud to compare quarterly revenue against targets. They need a visualization that clearly shows the magnitude and direction (positive or negative) of the variance between actual and target values for each quarter.
Answer and explanation
Correct answer: C
A Variance Chart is specifically designed to show the difference between two measures, such as actual versus target, making it the ideal choice for this scenario. It clearly visualizes both the size and the direction (positive or negative) of the deviation. A Waterfall Chart shows the cumulative effect of sequentially introduced values. A Stacked Bar Chart is for showing parts of a whole. A Scatter Plot is for showing the relationship between two numerical variables.
Question 2
A planning administrator is configuring a planning model for a multinational corporation. The model must support budget submissions from regional entities in their local currencies, which are then consolidated into the corporate currency (USD).
Answer and explanation
Correct answer: C
The Currency Conversion feature, enabled in the model's preferences, is essential for translating data from different local currencies into a single reporting currency. This requires setting up a currency dimension, a currency rates table, and defining the conversion logic. Data locking prevents changes, Value Driver Trees are for simulations, and Validation Rules check data integrity but do not perform currency translations.
Question 3
Multiple answers
A data analyst needs to create a new story in SAP Analytics Cloud by combining data from two different sources: an imported CSV file containing sales targets and a live connection to an SAP S/4HANA system for actual sales data. Which two of the following are prerequisites for combining data from an imported file and a live data source in an SAP Analytics Cloud story? (Select TWO)
Answer and explanation
Correct answers: B, D
Data Blending is the mechanism used within a story to combine data from different models (e.g., one import, one live). This is done by defining links between common dimensions.
For the blend to be successful, there must be at least one common dimension (the linking dimension), such as 'Product ID' or 'Region', with identical member IDs across both datasets.
Question 4
An analyst has received a flat file (CSV) containing sales data. The 'OrderDate' column is formatted as a text string (e.g., "2025-03-15"). To perform time-based analysis in a story, this column must be converted to a proper date format.
Answer and explanation
Correct answer: B
Within the Data Preparation (Wrangling) screen, the most direct and correct method is to change the column's data type from 'String' to 'Date'. SAP Analytics Cloud will then attempt to parse the text strings and convert them into a proper date format, which is essential for creating time hierarchies and performing time-series analysis.
Question 5
A global retail company, 'TrendSetter Inc.', wants to create a comprehensive executive dashboard in SAP Analytics Cloud. The dashboard will be viewed by C-level executives on large screens in the boardroom and on their mobile devices while traveling.
The primary requirements are to display Key Performance Indicators (KPIs) like Total Sales, Profit Margin, and Customer Growth. Users must be able to drill down from a world map showing sales by country into regional and then store-level details. The dashboard should also include a time-series chart showing sales trends over the last 24 months.
A key constraint is that the dashboard must load quickly and maintain interactivity, even with a large underlying dataset. Furthermore, the layout must automatically adapt between the large boardroom screen and a standard smartphone screen without requiring a separate story version.
The data model is based on an import connection to SAP BW and is refreshed daily. The model contains a location hierarchy (Country, Region, Store), a time hierarchy (Year, Quarter, Month), and a product dimension.
Answer and explanation
Correct answer: B
A Responsive page is essential for the layout to adapt automatically between large screens and mobile devices. A Geo Map with enabled hierarchy levels (Country > Region > Store) directly supports the drill-down requirement. Linked analysis is the best practice for making the dashboard interactive, where selecting a country on the map automatically filters the time-series chart and other widgets. This approach is the most efficient and user-friendly way to meet all stated requirements.
Question 6
True or False: In an SAP Analytics Cloud planning model, data locking can be applied at the cell level to prevent specific data points from being changed, even if other cells in the same row or column are editable.
Answer and explanation
Correct answer: A
Data locking in SAP Analytics Cloud planning is granular. It can be set on specific data cells, entire rows, or based on dimension member combinations. This allows planners to finalize certain values while leaving others open for input or adjustment, providing precise control over the planning process.
Question 7
A consultant is designing an analytic model that contains sensitive salary data. The requirement is to prevent most business users from seeing the 'Salary' measure, while allowing only users with the 'HR_Manager' role to view it. All users will use the same set of stories built on this model. What is the most effective and secure way to implement this requirement at the model level?
Answer and explanation
Correct answer: C
Data Access Control on measures is the correct, model-level security feature for this scenario. It allows an administrator to define which roles can read or write to specific measures, ensuring the security is enforced consistently across all stories that use the model. This is more secure and scalable than managing access through multiple story versions or story-level filters, which can be bypassed.
Question 8
A designer is creating a dashboard page with multiple charts. When a user selects a data point in one chart (e.g., a specific product category in a bar chart), all other charts on the page should automatically filter to show data only for that selected category.
Answer and explanation
Correct answer: C
Linked Analysis is specifically designed for creating interactions between widgets on a story page. By setting up linked analysis, selections made in one widget can act as filters for other selected widgets, creating a dynamic and interactive dashboard experience. Page filters are static, input controls require manual selection, and bookmarks save states but don't create this dynamic interaction.
Question 9
'Global Logistics Corp' is implementing a top-down budgeting process using SAP Analytics Cloud Planning. The CFO sets a total corporate budget for 'Operating Expenses'. This total amount needs to be distributed to different departments (Sales, Marketing, IT, HR) based on their employee headcount.
The planning model has an 'Amount' measure, a 'Department' dimension, and an 'Account' dimension which includes 'Operating Expenses' and 'Headcount'. The 'Headcount' data is already loaded into the model for the previous fiscal year and will be used as the driver for the allocation. The CFO will enter the single total budget amount at the top level of the 'Department' hierarchy.
The requirement is to automatically push down the total 'Operating Expenses' budget to the individual departments. The distribution must be proportional to each department's headcount. For instance, if the IT department has 20% of the total headcount, it should receive 20% of the total operating expense budget.
The planning team needs to configure this logic within the SAC planning model so that when the CFO saves the top-level budget number, the allocation happens automatically without manual intervention.
Answer and explanation
Correct answer: A
A Data Action with an ALLOCATION step is the standard and most robust method for this scenario. It allows the definition of a structured, repeatable process where a source amount ('Operating Expenses') is distributed to target members ('Departments') based on the values of a driver measure ('Headcount'). This can be triggered by a button in a story, ensuring consistency and accuracy. Spreading is a manual, ad-hoc user action. A cross-model copy is for moving data, not allocating. A VDT is for simulation, not for persisting allocated budget values.
Question 10
Multiple answers
A data architect is setting up connections in SAP Analytics Cloud. The business has two primary use cases: 1) A real-time sales dashboard that must reflect transactions in the source SAP S/4HANA system within seconds. 2) A monthly financial consolidation report that combines data from multiple flat files and requires significant data cleansing and transformation before being used in stories. Which connection types should the architect choose for these two use cases, respectively? (Select TWO)
Answer and explanation
Correct answers: A, D
A Live Connection is the correct choice for the real-time dashboard because it queries the source system (SAP S/4HANA) directly without storing data in SAC, ensuring the data is always current.
An Import Connection is the appropriate choice for the financial report because the data needs to be brought into SAC's in-memory engine to perform the required cleansing and transformations (wrangling).
