Hello Experts,
I have created a Crystal Report (Crystal 2008 SP1) with BEx Query (7.10) and have been able to refresh successfully when the SAP_ALL authorization is included in my user role. I don't want my end users to have SAP_ALL so I created a role and assigned the authorizations recommended in the SAP Integration Kit for BusinessObjects 3.1 Install Guide.
When I run the report as one of the users assigned to my new role I get the following error in the trace file.
ERROR: .\crdb_bwmdx_execution.cpp [200]: l_bapiGetStreamInfo failed with return code RFC_RC = 0 Exception: BAPI Error: BAPI Error #:0
Unknown error when executing MDX
2188 6556 Caught DbError #1 with Message 'BAPI Error #:0
Unknown error when executing MDX'
2188 6556 Caught DbError #1 with Message 'BAPI Error #:0
Unknown error when executing MDX'
2188 6556 Caught DbError #1 with Message 'BAPI Error #:0
Unknown error when executing MDX'
I tried all the Fix Packs (ie 1.1., 1.2 and 1.3) for XI 3.1 Integration Kit to try resolving the error but it didn't work.
The same query works fine in BEx Web when running as one of the users in the new role I created for Crystal Report users.
Are there any other Authorizations that I need to include in the role?
Cheers.
Paul.