C_BW4H Exam Questions: Free SAP System Tasks [2026]

Step-by-Step Execution:

1. In SAP Analysis for Microsoft Excel, choose File, then select Analysis.
2. Choose Save Workbook on a Platform.
3. Select Save a Workbook to the SAP Business Warehouse Platform.
4. Select the target SAP BW/4HANA system and navigate to the specific role.
5. Save the workbook to the role, which automatically adds transaction code RAAOE to the role menu.

Example Values:

• Target Platform: SAP Business Warehouse Platform

Expected Result: The workbook is saved to the role, and transaction code RAAOE is automatically added to the role menu to allow users to launch the workbook via SAP GUI.

Quick Mistakes:

• Attempting to save the workbook without the key user having the S_USER_AGR and S_USER_TCD standard authorizations.
• Attempting to save to a role that the key user is not explicitly a member of, as this is required for the S_USER_AGR check.

Exam Insight:

• Tests the integration between SAP Analysis for Microsoft Excel and SAP BW/4HANA roles, specifically emphasizing the required standard authorizations needed by the key user.
• Evaluates the understanding that while the key user needs S_USER_AGR and S_USER_TCD to save the workbook, the end reporting user does not need these specific standard authorizations to simply launch it.

Step-by-Step Execution:

1. Open the Employee InfoObject definition in the SAP BW Modeling Tools.
2. Navigate to the Attributes tab and ensure the Organizational Unit is added as an attribute.
3. In the Display and Navigation Attributes pane, right-click to open the context menu.
4. Select the option to switch on Transitive Attributes.
5. Select the Company Code (which is an attribute of Organizational Unit) to expose it as a transitive attribute of Employee.
6. Activate the InfoObject to make the changes available.

Example Values:

• Basic Characteristic: Employee
• First-level Attribute: Organizational Unit
• Transitive Attribute: Company Code

Expected Result: The Company Code is successfully exposed as a transitive attribute of the Employee characteristic and can be used for display or navigation in queries without needing physical storage at the Employee level.

Quick Mistakes:

• Attempting to model a transitive attribute over multiple steps (e.g., an attribute of an attribute of an attribute), which is limited to exactly one step in standard SAP BW/4HANA modeling.
• Assuming the transitive attribute will be available without first activating the base characteristic and ensuring the intermediate attribute has its own active master data.

Exam Insight:

• Tests your knowledge of snowflaked dimension techniques used to reduce data volume and maintenance effort.
• It is crucial to remember the SAP BW/4HANA limitation that transitive attributes only work for one step; if higher levels are needed, a virtual master data approach via an SAP HANA Calculation View must be used instead.

Step-by-Step Execution:

1. Access transaction RSECADMIN and navigate to the Authorizations tab.
2. Create or edit an analysis authorization and add the special characteristic 0TCAKYFNM.
3. Choose Details for the characteristic and navigate to the Value Authorizations tab.
4. Set the Including/Excluding column to I and the Operator column to EQ.
5. Enter the technical name of the permitted key figure in the Technical Characteristic Value field.
6. Save the authorization and ensure it is assigned to the user.

Example Values:

• Special Characteristic: 0TCAKYFNM
• Technical Characteristic Value: 0QUANTITY

Expected Result: The user can only view the authorized key figure in their report; unauthorized key figures are hidden and no values are displayed for them.

Quick Mistakes:

• Attempting to mark a single key figure as authorization-relevant in InfoObject maintenance instead of using 0TCAKYFNM.
• Forgetting to include the technical names of all base key figures used in a calculated key figure when granting access to it.

Exam Insight:

• Tests the knowledge of special characteristics in SAP BW/4HANA security.
• Highlights that individual key figures cannot be marked as authorization-relevant directly; the restriction must be applied globally via 0TCAKYFNM.

Resolution:

1. Access the SAP BW/4HANA Cockpit and navigate to the Master Data Administration app.
2. Identify and delete any dependent transactional data or hierarchies referencing the Characteristic.
3. Rerun the Delete Data function directly on the master data table.

Prevention Tip: Always run a where-used check to verify data dependencies before attempting a direct deletion from the master data tables.

Resolution:

1. Open the query definition and set the authorization variable to be input-ready.
2. Instruct the user to narrow the proposed selection during the query execution prompt.
3. Alternatively, use Customer Exit variables instead of authorization variables to enforce strict dependencies.

Prevention Tip: Combine multiple multidimensional analysis authorizations into a single authorization whenever possible to prevent rectangular superset conflicts.