Problem with SQL Statement in Visual Composer !

32 Views

Hi all,

I use BI JDBC System & connect to MaxDB Database. The connection is Ok. According to the documents in help.sap.com, data services for BI JDBC connector are Tables with a default relational query and custom SQL queries or Relational queries created with the BI Integration Wizard.

- When I click on Find Data Button & select system, I just see all the tables in my database, but now, if I want to use my store procedures defined in my database, how can I do ?

- When using BI Wizard, I just can select data of table with a static condition (ex: select ... where ID = '1'), but how can I do with dynamic variable which is got from the input form ?

- When I drag & drop a table into storyboards, drag out input port of this data service & add an input form. I configure SQL Statement of the Submit line between Input Form & dataservice as:

<b>"Select DBADMIN.Class.ClassID, DBADMIN.Class.ClassName from DBADMIN.Class where DBADMIN.Class.ClassID == @CLASSID"</b>

The formula is correct, but when running the iView, I have error :<b>Query Execution failed.</b>

Could you please help me to solve this problem ?

Thank you very much & Kindly regards,

Tweety.