1️⃣ Scenario: Consolidation not picking up latest data
Q: Your Consolidation Monitor shows outdated values even after data load. What steps do you take?
A:
- Check if Currency Translation and IC Matching are executed.
- Validate Data Manager package status.
- Ensure business rules (CT, IC Elimination) were run for the correct category/time.
- Verify optimistic vs. pessimistic locking isn’t stopping updates.
- Refresh Consolidation Monitor after clearing cache.
2️⃣ Scenario: BPC report shows blank data for some entities
Q: A report displays data for some entities but not for others. How do you debug?
A:
- Check if the entity is assigned to the hierarchy.
- Verify security access for user (Read/Write access).
- Ensure data exists in cube (Fact table) using RSA1 > Manage.
- Confirm valid time & category selection in the report.
3️⃣ Scenario: Script logic not executing properly
Q: Users say script logic is not updating data. What do you check?
A:
- Validate syntax using UJKT.
- Check logic file sequence.
- Ensure script logic is assigned to the environment.
- Verify DIMENSION OVERRIDE entries.
- Make sure WRITE = ON.
4️⃣ Scenario: Performance issues in BPC Data Manager packages
Q: Load package taking too long. How do you improve?
A:
- Reduce use of *SELECT statements.
- Optimize transformations/conversions.
- Load data in smaller packages.
- Perform cube compression.
- Use parallel processing where possible.
5️⃣ Scenario: Business rule not executing
Q: Elimination rule is not running. What steps do you check?
A:
- Validate Method assignment in Method-Based Multiplier.
- Check Rule sequence.
- Ensure IC partner is maintained.
- Confirm correct scope selected during Consolidation.
6️⃣ Scenario: Data load mapping issue
Q: Actual data loads but some accounts map incorrectly.
A:
- Check mapping priority (explicit > like > default).
- Validate transformation file.
- Review conversion file for account mapping.
- Test using Preview in Data Manager.
7️⃣ Scenario: Master data not visible in reports
Q: New accounts added but not visible in BPC reports.
A:
- Check if account is added to dimension hierarchy.
- Run Process Dimension.
- Refresh report cache.
- Ensure EPM formatting isn’t hiding it.
8️⃣ Scenario: Work Status locked
Q: Users cannot input data because work status is locked.
A:
- Change work status at Entity + Category + Time level.
- Validate security profile for work status.
- Check ownership manager to confirm ownership.
9️⃣ Scenario: Currency Translation wrong
Q: Translation results are incorrect.
A:
- Check Rate type assigned in Account dimension.
- Validate rate table values.
- Ensure correct Group Currency used during consolidation.
🔟 Scenario: Failed Data Manager package
Q: Package shows red icon. How do you troubleshoot?
A:
- Check UJFS logs.
- Validate transformations, conversions, and file format.
- Re-run with Debug log enabled.
11️⃣ Scenario: Users complain EPM report is slow
A:
- Minimize Excel formulas.
- Reduce use of suppression and dynamic formatting.
- Use local member calculations only when required.
- Limit multiple hierarchies in rows/columns.
12️⃣ Scenario: BPC Transport failure
Q: Transport request failed in Quality.
A:
- Check dependent objects not included.
- Ensure environment is unlocked.
- Validate version mismatch.
- Re-create the transport and re-import.
13️⃣ Scenario: IC matching mismatch
Q: How do you solve IC mismatch?
A:
- Run IC Matching Report.
- Validate partner IDs.
- Ensure all documents posted correctly in ECC.
- Run reconciliation rule.
14️⃣ Scenario: Custom logic needs to update only specific accounts
A:
Use WHEN ACCOUNT block in logic script.
15️⃣ Scenario: Data is getting doubled
A:
- Check for duplicate records in source file.
- Validate TRANSFORMATION mapping.
- Ensure logic scripts aren’t running twice.
16️⃣ Scenario: Ownership % not updating
A:
- Check Ownership Manager configuration.
- Ensure valid date range.
- Verify Group is assigned properly.
17️⃣ Scenario: Users unable to save data in input schedule
A:
- Check WRITE access.
- Confirm work status = OPEN.
- Ensure valid member combinations exist.
18️⃣ Scenario: Multi-level hierarchy not reflecting
A:
- Run Process Dimension after hierarchy change.
- Refresh reports.
- Clear EPM cache.
19️⃣ Scenario: BPC job failed in process chain
A:
- Check UJ0 tables* for errors.
- Validate process chain step sequence.
- Fix load file path or incorrect mapping.
20️⃣ Scenario: Restatement needed after changing opening balances
A:
- Re-run carry-forward.
- Execute Consolidation again for opening period.
21️⃣ Scenario: Business wants YTD report but data is periodic
A:
Use EPM Functions → PERIODIC/YTD conversion
or
Set Account type to AST/LIA for logic-based YTD.
22️⃣ Scenario: Audit trail missing
A:
- Enable Audit in environment parameters.
- Re-run data load.
- Review UJ_ANALYSIS tables.
23️⃣ Scenario: Incorrect aggregation in reports
A:
- Verify Account type (INC/EXP vs AST/LIA).
- Validate signed data logic.
- Fix parent-child hierarchy.
24️⃣ Scenario: Planning version copying incorrect
A:
Use Copy Data Manager package and check:
- Time range
- Category
- Entity
- Data slices locked?
25️⃣ Scenario: BPF not moving to next step
A:
- Check Work Status.
- Validate Owner & Reviewer setup.
- Confirm BPF context is correct.
26️⃣ Scenario: RFC connection failure
A:
- Check SM59 RFC connection.
- Correct user credentials.
- Validate ABAP program authorization.
27️⃣ Scenario: Missing Transformation File Fields
A:
- Add missing mapping lines.
- Re-import file with proper delimiter.
- Test using Preview.
28️⃣ Scenario: Data security leakage
A:
- Re-check Task Profiles & Data Access Profiles.
- Remove unintended member access.
- Reset environment security.
29️⃣ Scenario: Script logic conflict with BAdI
A:
- Check which one has higher priority.
- Disable script logic to test BAdI.
- Update BAdI implementation logic.
30️⃣ Scenario: User requests drill-through
A:
- Configure Document Types.
- Create table mapping in BW.
- Enable drill-through in Report settings.