Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

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 ?

Need Help
Show and Tell

1 Reply

  • FarhanJeelani's avatar
    FarhanJeelani
    Icon for Super User rankSuper User
    1 year ago

    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

    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.