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

[Former Member]

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

[Former Member]

Hi Jothi,

Thanks for your reply.

Bex query is running fine. We are facing issue on BO only. Even in BO also report was working fine before the patch upgrade.

Yes. Prompt will get only number (ex: 10, 5).

(User input enabled text variable is being used in field name). This text variable is being used in customer exit to manipulate values for the date range based on the user input days(for ex: 10, or 5 )

Thanks,

Angavai Elangovan

[jyothirmayee_s]

Hi,

We are on 4.2 SP6 Patch3 and text variables are working without any issue though.

What happens when you run the same query thru Analyzer?, Also, Does your prompt based on a number, date?.

Thanks,

Jothi