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

[CBI]

Hello,

I'm have well created a connection to BW from PowerBI Desktop and created a report with a simple cds view.

But we have some of those cds views which contains hierarchy as input parameters, and when i use them, I have an error saying "Dimension "Measures" is unknown. For more informations on this error, visit the SAP support site and search 'BRAINOLAPAPI 105'".

Maybe i'm wrong and there's nothing about the hierarchy and it is something else ?

Do you have any idea about it please ?

[FarhanJeelani]

Hi @CBI ,

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.