Skip to Content

Failed to retrieve the cube for connection BEX query on BI 4.2 SP6 P4

"Failed to retrieve the cube for connection" when connecting to Bex query. Our BW version is SAP BW 7.3

Steps to Reproduce Error

1. Open report and refresh. Get error message "Failed to retrieve the cube for connection".

2. Refresh again. Report runs successfully.

OR

1. Schedule report. When trying to modify prompt, get error message "Failed to retrieve the cube for connection".

OR

1. Create new report based on same OLAP connection for same BEx query, it fails with same error.

Only Few users are facing this issue.

Same connection they can access from AFO. But when connected from webi connecting to Bex query getting error.

We have restarted SIA and servers as well as checked his authorization from BO and BW and it is as required.

Could you please help us.

Add a comment
10|10000 characters needed characters exceeded

  • User can access same Bex query from AFO. As well as can run query from BW side.

    We have tried to change the preferences of webi as Applet and then access Bex query, same issue persist. We have checked authorization from BO side as well as from BW end and its perfect. Also same connection when tried to open with web Rich client getting error.

    We have restarted the SIA and servers as mentioned in SAP note.

    Asked user to reset his password. Still No luck.

  • I have fixed your tags to better match the subject of your question.
    Also, it would help community if you provide the troubleshooting you have already done and what your analysis of the logs has shown.

Related questions

1 Answer

  • Posted on Jul 13, 2020 at 08:56 AM

    Hi

    Try to do change data source and re point to the same bex query and check again still ur facing that issue

    Thanks,

    Saurabh S.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.