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,