Prompt Syntax In Business Objects Freehand Sql
Prompt Syntax In Business Objects Freehand Sql. Incorrect syntax for dateadd function, syntax is dateadd (datepart,number,date1) is there a specific syntax required by smart reporting ? In this query create a prompt with the object that you want to use in your.
It allows the business objects universe developer to define the relative order of the prompt. Getting your @prompt syntax right. All i have a report based on freehand sql all i need to do is add a prompt to the report so that the user can filter the data sql is select * from peg_agg_value it has a date column.
First, Create Another Data Provider In The Report Which Uses The Universe.
Sends the specified message or a blank line to the user',s screen. Sap businessobjects business intelligence platform 4.1 (bi 4.1) support pack 6 (sp6) and higher, I have a date prompt in a freehand sql query in a web rich client report.
Click Ok Twice And Then The Query Panel Opens Showing The Objects.
Click run query and the report returns. First, both @select and @prompt must refer to universe objects, not columns. In my filter i selected prompt.
Next, We Need To Find The Names Of Queries (Or Data Providers) Contained Within This Document:
Click edit data provider on the. Pro[mpt] [text]where text represents the text of the message you want to display. Hello yf community, i want to pass a user prompt parameter into a function.
Created By Tammy Powlas On Jun 16, 2013.
I have been using businessobjects for just over a year and have only used 4.0. Hi nicty you have written the prompt using sql*plus syntax. Manually defining the @prompt function for an sql statement.
Click Parse To Check The Syntax Of The @Prompt.
The text appears in the prompt box when the user runs the query. And a_dept_code = @prompt(',enter dept',,,,,) note i have typed 4. This is the right most icon on that object (at least for me).
Post a Comment for "Prompt Syntax In Business Objects Freehand Sql"