2072270 - Error: "At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values." in WebI prompt screen based on BICS in BI 4.0

SAP Knowledge Base Article - Public

2072270 - Error: "At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values." in WebI prompt screen based on BICS in BI 4.0

Symptom

  • com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values error when list of values is retrieved for WebI Query level filter.
  • With the second refresh it gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)" error.

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.0

Reproducing the Issue

  1. Create Mandatatory filter in  Characteristic Restriction of BEx designer (eg date range).
  2. Add some dimension and key figures in rows and columns.
  3. Save the query.
  4. Create a WebI report based on BICS connection on top of same BEx query in BI 4.0 .
  5. Drag some dimension and key figures in Result Objects and add one Dimension as Query filter and make its as prompt.
  6. Refresh the report, prompt screen appears.
  7. Prompt screen displays two prompts which are mandatory date range filter coming from BEx query and second coming from Webi quey filter.
  8. Ignore BEx level prompt and navigate to WebI query filter.
  9. Enter '*' to retrieve the list of values for WebI prompt.
  10. WebI prompt gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values" error.
  11. With the second refresh it  gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)" error.

Cause

  • As the BEx level filter is mandatory, input value for mandatory BEx filter should be given first.
  • This is expected behavior with BI 4.0( See KBA  1984983 )
  • Starting from BI 4.1, if BEx query has Mandatory prompts Set Variable pops up first before going to Query Panel.
  • This is not case with BI 4.0, it gives Query Panel directly even if BEx query has Mandatory filters.

Resolution

  1. Navigate to "Set Variables" and provide a default input value for Mandatory BEx filter and click Ok.
  2. Run the report

Keywords

KBA , BI-RA-WBI , Web Intelligence , Problem

Product

Crystal Reports 2008 V0