on 09-10-2010 7:09 PM
Hi,
I am new to WebI. I am runiing BO Xi 3.1. Does anyone know how to create a Webi report using free hand sql?
Put the SQL into a derived table in a universe, and publish it that way. There is no direct support for free hand SQL in Web Intelligence.
Alternatively you can use Crystal, which allows direct entry / maintenance of the SQL code.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You CAN use free-hand SQL in WebI. Just log into the InfoView, open the report for editing (in the Java editor), go to the query editor and press on the SQL button. You can provide there your own SQL statement. Still keep in mind that your statement should have a select clause which is compatible with the query objects.
Regards,
Stratos
Hi Efstratios -
I have to agree with the statement:
There is no direct support for free hand SQL in Web Intelligence.
If by "direct support" we're talking about an intuitive and manageable way to enter free-text SQL and "let Webi do the rest", then it's certainly not true. Currently, an end-user is required to endure several painstaking steps and cautions to align the SQL select of a freehand sql written in the Webi SQL pane with that's been dragged-and-dropped to the Result Objects pane in the Java Report Panel. Even after this process is finished and the user has a report, any change in # of result objects (columns) requires the user to once again re-create the SQL.
The current superior method to accomplish this is to use Desktop Intelligence, or create the derived table in a Universe as Dave mentioned.
Stratos, I agree that the user does not necessarily have to "change the universe by adding new derived tables" but at the same time it is certainly not similar to the way you use free-hand SQL in DESKI. For one you cannot write SQL without bringing any dimension in the query panel, then you have to make sure your select clause has the same number of attributes you have brought in the query panel etc.
- Noman Jaffery
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.