Skip to Content
0
Former Member
Mar 08, 2017 at 06:26 AM

User input enabled text variable is not supported in BICS based WEBI

157 Views

Hi All,

BO Version - BO4.1 SP6 Patch7

After BO plantform patch update, we are getting a below query script generation issue while refreshing the webi report. But before patch upgrade it was working fine.

Bex --> Direct BICS --> WEBI

Report is running fine for the first refresh. We are getting this below issue, when we try to change the user input value of prompt (user input enabled Text variable from Bex) in second refresh. If we didn't give/ change user input values of prompt (user input enabled Text variable from Bex), this error will not occur. Only the user input enabled text variable is causing this issue. (User input enabled text variable is being included in key figures description)

We have raised this concern to SAP. As per the SAP workaround, we have re-created the BO report. But still we are facing the same issue.

Any idea why text variable is not supported after patch upgrade. Kindly let me know if you know about this issue & have any work around for this issue.

(For temporary fix we are going to remove this variable from BEx. Instead of this we are going to use formula variable to get the user input)

Thanks,

Angavai Elangovan

Attachments

capture.png (12.2 kB)