Errors while changing prompt values in WebI which uses a HANA view

[former_member212706]

Dear Experts,

     I have created analytic views in SAP HANA. I have then created Business Layer/ Universes on top of them. Now when i try to create a WebI report it works fine until the prompt values are unchanged . But once i try to refresh the query it throws the following error

Post checking with WebI experts , i came to know that these kind of errors happen only when the database could not uinderstand the synatx of prompt. The following is the SQL script which is created by the WebI report.

SELECT

  sum("_SYS_BIC"."XXX_V1"."MEASURE"),

  "_SYS_BIC"."XXX_V1"."FIELD1",

  "_SYS_BIC"."XXX_V1"."FIELD2",

  "_SYS_BIC"."XXX_V1"."FIELD3",

  "_SYS_BIC"."XXX_V1"."FIELD4",

  "_SYS_BIC"."XXX_V1"."FIELD5",

  "_SYS_BIC"."XXX_V1"."FIELD6",

  "_SYS_BIC"."XXX_V1"."FIELD7",

  "_SYS_BIC"."XXX_V1"."FIELD8",

  "_SYS_BIC"."XXX_V1"."FIELD9",

  "_SYS_BIC"."XXX_V1"."FIELD10",

  "_SYS_BIC"."XXX_V1"."FIELD11",

  "_SYS_BIC"."XXX_V1"."FIELD12",

  "_SYS_BIC"."XXX_V1"."FIELD13"

FROM

  "_SYS_BIC"."XXX_V1"

WHERE

"_SYS_BIC"."XXX_V1"."FIELD3"  =  @prompt('Enter values for Persona Title:','A','Bimt An Use Case Persona V1\Persona Title',Mono,Free,Persistent,,User:8)

GROUP BY

  "_SYS_BIC"."XXX_V1"."FIELD1",

  "_SYS_BIC"."XXX_V1"."FIELD2",

  "_SYS_BIC"."XXX_V1"."FIELD3",

  "_SYS_BIC"."XXX_V1"."FIELD4",

  "_SYS_BIC"."XXX_V1"."FIELD5",

  "_SYS_BIC"."XXX_V1"."FIELD6",

  "_SYS_BIC"."XXX_V1"."FIELD7",

  "_SYS_BIC"."XXX_V1"."FIELD8",

  "_SYS_BIC"."XXX_V1"."FIELD9",

  "_SYS_BIC"."XXX_V1"."FIELD10",

  "_SYS_BIC"."XXX_V1"."FIELD11",

  "_SYS_BIC"."XXX_V1"."FIELD12",

  "_SYS_BIC"."XXX_V1"."FIELD13"

Please help me here.

Thanks in Advance !!!!

Regards,

Rajesh.

[former_member184768]

Hi Rajesh,

Ideally it should not happen. The Prompt should get added to the generated SQL script. Can you please refer to the following document on using SAP HANA variables in BO. Although the document is about using variables defined in HANA in BO, you may find some pointers.

http://scn.sap.com/docs/DOC-27676

Regards,

Ravi