Skip to Content
author's profile photo Former Member
Former Member

DeskI report with free hand sql

Hi,

I have converted a deski report from BO 5x to BO Xi. R3. That report contains a free hand sql connection. The report run fine when running from the server. But it is not when I am trying to refresh it through Infoview; somehow I am getting the CORBA Initialization failiure.

I tested successfully the connection through Desinger. I am not sure what I need to do next.

Please help!!!!

Edited by: Brian Mangan on Sep 9, 2010 10:53 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2010 at 06:55 AM

    Hi,

    When a report with free hand sql converted from earlier versions (5x) to latest version (r3 I guess) then the connection parameters sholud be changed in latest version (r3). Please change ur connection parameters in r3. i.e the user name, password and connection string so that in r3 we can connect to back end and then try to refresh the report in webi.

    The Corba Initialization is related to invalid connection to back end.

    Cheers,

    Suresh Aluri.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2010 at 03:08 PM

    Suresh,

    I have been reading about derived table, I think I am going to use that. I am having to many issues with this free hand sql connections not working in all environment after I export it to the universe. Now I just have to learn how to create the derived table and all the links.

    Thanks,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      To Create Derived Table:

      Use that Free hand SQL in the definition/Sql of Dtable. You have to Parse it for no errors (syntax).

      When to use:

      --Whenever you are not getting exact data/join conditions by joining tables and using in reports.

      -- Inner join within inner join(sub query)

      At the same time, you have Performance delay by using DT's.

      Thank You!!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.