"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.
1. Schedule report. When trying to modify prompt, get error message "Failed to retrieve the cube for connection".
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.