Error using BW CDS View with a hierarchy as an input parameter

Hi Anonymous ,

The error "Dimension 'Measures' is unknown" with reference to "BRAINOLAPAPI 105" in SAP BW usually occurs when Power BI struggles to interpret or process the hierarchy input parameter from the BW CDS view. Here's how you can troubleshoot and resolve the issue:

1. Verify the Hierarchy Input Parameter

• Check the CDS view in SAP BW and ensure the hierarchy is properly defined.
• Confirm that the hierarchy input parameter is correctly configured and that it allows values compatible with the data.

2. Test Without the Hierarchy Parameter

• Remove the hierarchy input parameter and try loading data from the CDS view in Power BI.
• If the error disappears, it confirms the issue is related to the hierarchy.

3. Use a Flat Data Structure

• If hierarchies are causing problems, consider flattening the data in the CDS view.
• Alternatively, you can process the hierarchy into a flat structure in SAP BW and then use it in Power BI.

4. Update or Patch SAP Connector

• Ensure that you’re using the latest version of the SAP BW connector in Power BI. Updates often fix compatibility issues with CDS views or hierarchies.

5. Check Authorization in SAP BW

• Sometimes, this error can occur if the user doesn't have the required permissions to access certain hierarchy elements in SAP BW.
• Verify user authorizations for the CDS view and its hierarchy.

6. Review SAP Documentation

• Look up the "BRAINOLAPAPI 105" error on the SAP support site to find specific guidance.
  SAP Support Site for BRAINOLAPAPI 105

If none of these work, try capturing the query in SAP BW (e.g., via RSRT or a debug tool) to analyze the issue further or consult your SAP BASIS or BI team for assistance.

Let me know how it goes!

Please mark this as solution if it helps you . Appreciate Kudos.