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.
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).
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)
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.
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.
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.
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?
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.
'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.
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)