Can not create Webi report on a Universe based on Bex Query

[Former Member]

Hi,

We are using BO XI 3.1 (FP 3.4) with SAP integration Kit (same Patch Level) with SAP Authentication. We have a Universe based on a bex query and its connection is set to use SSO.

We have say two SAP users U1 & U2. Now "U1" is able to create webi reports but when we Logged in as "U2" and try to create Webi reports or try to refresh reports created by U1 it through an error ...

The database error text is: (CS) "Error on NumResultCols" . (WIS 10901).....

As per the "Authorization" section in BusinessObjects XI Integration for SAP Solution Installation Guide we have provided this users with all the mention autherizations.

Any words over this will be highly appreciated.

Regards,

[former_member142702 · Accepted solution]

It is highly probable that this is due to missing authorizations on the SAP BW side (not talking about the authroizations which are directly related to the BO/BW integration). I would recommend to ask your SAP Basis team to do a security trace while you are accessing the reports with the user, who gets the error. THey should look for failing authorization checks.

Regards,

Stratos

[Former Member · Accepted solution]

Thanks for your reply. I will check with my SAP BASIS team & update with the status.

Regards,