Skip to Content
avatar image
Former Member

WebI - free hand sql

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 10, 2010 at 11:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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