1.
Your KPI tiles show different numbers compared to BW Query in Analysis for Office. How do you troubleshoot a mismatch between SAC and BW Live Connection?
2.
The client wants a single story to dynamically switch between Actual, Forecast, and Budget without loading multiple models. How would you design this in SAC?
3.
A planning story needs to block users from entering data unless they select a specific version and time period. How do you enforce such conditional inputs?
4.
A Data Action involving advanced formulas performs very slowly. How do you diagnose performance issues using Trace Logs?
5.
Users want “Top 10 Customers by Sales” but the top list should change automatically based on filters applied in the story. How would you configure this?
6.
Your story uses a Data Blending setup between S/4HANA Actuals and Excel Forecast. After adding more rows in Excel, the story breaks. What steps do you take?
7.
A client wants to use predictive forecasting inside a planning story but the forecast line is unrealistic. How do you improve predictive settings?
8.
You must hide certain key figures such as Margin% from Junior analysts. How do you achieve measure-level security?
9.
A story displays outdated data even after refresh. What SAC caching settings and backend refresh triggers will you check?
10.
During story export to PDF, the layout looks different from the live story. How do you adjust story layout for perfect PDF export?
11.
A client wants to perform complex IF/ELSE logic based on multiple dimensions in Planning. Would you use:
- Data Actions
- Advanced Formulas
- Multi-Actions
Explain the correct choice.
12.
You need to integrate a custom ML model (Python/Scikit-Learn) to run predictions inside SAC. How do you implement it via SAC Predictive Scenario or external API?
13.
Your Analytic Application requires dynamic dropdown filters dependent on previous selections (cascading filters). How do you script this?
14.
A BW Query that works with Lumira and AFO is not visible in SAC via Live Connection. What BW query technical settings would you validate?
15.
Users want to schedule story refreshes and email delivery every Monday morning. How do you set up story publications with scheduling?
16.
Your story uses multiple filters, linked analysis, and restricted measures. Users complain the charts behave inconsistently. How do you systematically debug filter conflicts?
17.
During model creation with imported Excel data, SAC incorrectly detects data types for some columns (dates/numbers). How do you fix type-detection issues?
18.
You need to create a Planning model where sales quantities should not be negative. How do you enforce validation rules?
19.
The business wants a fully customized dashboard theme with brand colors. How do you use Custom Styling and Global Themes?
20.
Your geographic charts do not show countries/regions correctly. How do you fix incorrect geo-mapping in SAC?
21.
Users complain that Data Locks are preventing planning even though they have permissions. How do you debug locking conflicts?
22.
An Analytic Application grows in complexity and becomes slow. How do you optimize scripting and widget performance?
23.
A story needs to show comments by region and version. How do you configure comment storage and ensure it is version-dependent?
24.
You have a Datasphere model shared with SAC, but new fields added in Datasphere are not visible in SAC. How do you sync metadata?
25.
A planning user wants to revert all manual entries and return to original data. How do you design a Reset / Revert mechanism using Data Actions?