2011232 - BI 4.1: Error: 'Query script generation failed. See your administrator. No member found for Caption 'XXX' in Characteristic 'XXXX'. (IES 00013)' when “Text” is passed as a constant

SAP Knowledge Base Article - Public

2011232 - BI 4.1: Error: 'Query script generation failed. See your administrator. No member found for Caption 'XXX' in Characteristic 'XXXX'. (IES 00013)' when “Text” is passed as a constant

Symptom

  • In BI4.1, when “Text” is passed as a prompt constant via OpenDoc, the error below is displayed

Query script generation failed. See your administrator. No member found for Caption 'XXX' in Characteristic 'XXXX'. (IES 00013)

  • In BI.40 no error message is generated and the report is generated as it should

Environment

BI4.1 SP3

BW7.3

Reproducing the Issue

1. Create a webi report on top of a BEx Query that has date prompts.

2. Create a dashboard on top of the Bex Query on which data is dependent on date

3. Create an OpenDoc from the webi report created earlier

4. Include the opendoc to an excel cell in dashboard design and also include parameters in that same cell that will filter the data depending on the time selected for the dashboard.

5. Refer that excel cell to an object on the dashboard.

6. Run the dashboard and click on the object which refers to the OpenDoc

Cause

This has been raised as problem report ADAPT01725696

When display is set up as "Text", all LOV build in webi query filter panel is only TEXT.

Therefore all parameters passed have to be text .

If a key is passed then error "No member found for this caption" is showing

Resolution

This issue has been forwarded to Development for further investigation

Workaround :

Change the "Display as" property from TEXT to KEY in the InfoObject definition of the BEx query.

Tthe LOV built in webi query filter panel will now be based on KEY therefore all parameters passed to this filter can now be KEY.

Keywords

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

Product

SAP BusinessObjects Dashboards 4.0