Skip to Content
0

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

Mar 08, 2017 at 06:26 AM

54

avatar image
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

capture.png (12.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jyothirmayee A Mar 08, 2017 at 08:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 09, 2017 at 09:14 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded