1959457 - Error “The Mandatory Variable (VAR_name) has not been given a value WIS(00000)” while running Web Intelligence report if “Set as prompt” unchecked for any variables defined in BEx query if using more than one Mandatory and/or Optional variable

• Error “The Mandatory Variable (VAR_name) has not been given a value WIS(00000)” while running Web Intelligence report if “Set as prompt” unchecked for any variables defined in BEx query if using more than one Mandatory and/or Optional variable 
• Observed Behaviors:
• Scenario 1:
• Two mandatory variables, one optional variable defined in the BEx query, then we receive the error message
• When we uncheck “set as prompt“ for any of the variables including the optional
• Scenario 2:
• One mandatory variable and one optional variable defined in the BEx query, we get the error message
• When we uncheck “set as prompt “  for the optional variable, however if we uncheck “set as prompt” for  the mandatory variable then it works fine
• Scenario 3:
• One mandatory variable defined in the BEx query then it works fine if we uncheck “set as prompt “
• Scenario 4:
• One optional variable defined in the BEx query then it works fine if we uncheck “set as prompt “
• Scenario 5:
• Two mandatory variables defined in BEx query, and if we uncheck “set as prompt“ for any variable we get the error message
• Scenario 6:
• In case of BI4.1 SP 1 Patch 2, all bove scenarios work
• However if we include an object in the query filter as a prompt, observe the same error message “The Mandatory Variable (VAR_name) has not been given a value WIS(00000)”

• SAP Business Intelligence 4.1
• SAP BusinessObjects Enterprise
• Web Intelligence

WebI WebIntelligence Web Intelligence BICS BEx SAP Query variable prompt LOV Set As uncheck unselected not checked selected WIS00000 WIS 00000 mandatory optional VAR name VAR_name error exception run refresh ADAPT01714750 ADAPT1714750 ADAPT 01714750 1714750 TE: 5050162246 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed