WIS 10901 - Report error from SAP source

29 Views

Hi,

I have created a Universe on SAP BeX Query 7.0. In WebI report, if I take one object (characteristic)to report panel, I can see the data for that object in the report. But if I take 2 objects (either 1 characteristic and 1 key figure OR 2 characteristics) it thows the below error :

"A database error occured. The database error text is: The MDX query SELECT { [Measures].[0CREDIT_DC] } ON COLUMNS FROM [$0FIAR_C03] failed to execute with the error See RFC trace file or SAP system log for more details. (WIS 10901)"

We have checked in RFC and found the below details:

"Communication error, CPIC return code 020, SAP return code 456"

Below are the steps we did to get a webI report:

Installed BO XI 3.0 in Desktop and Server

Installed BO XI Integration kit for SAP in Desktop (not done in Server yet)

Logged in Universe Designer with Enterprise authentication

Created Universe on SAP BW query (with specific user name and password)

Export the universe to BO Enterprise

Open Webi in Infoview with the exported Universe as source

Please let me know anyone faced this issue.

Thanks

Jai