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

BO3.1 to BO4DeskI to WebI report conversion using RCT (2 database)

Hello,

I have to convert reports from BO 3.1 to BO 4.0 version.

I have a DeskI report which has 2 Freehand SQL and both are pointing to different databases.

So my questions are:

1. Is it possible to convert DeskI report which uses multiple databases?

2. RCT will convert these SQL and generate different universes for both databases?

Do we have any other suitable approach to convert DeskI reports which uses multiple db?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 07, 2014 at 08:48 AM

    Hi

    1. yes, it is.

    2. I think for this you need to follow below steps:

    1. Refresh the Query in DeskI make sure it is refreshing perfectly.
    2. Convert the DeskI report using RCT to WebI report
    3. Refresh the converted WebI report make sure it refreshes prefect.
    4. Find out which connection has been used for Default FHSQL universe
    5. Find out any universe has using the same connection.
    6. Create a derived table using the same query from WebI report
    7. Export the universe to RCT universe folder.
    8. Open the WebI report and to point the universe.
    9. Map the objects to existing WebI report objects

    If you need more help on this kindly revert me back.

    Hope it must help you!

    Cheers,

    Shardendu Pandey

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 08, 2014 at 12:55 AM

    Chetan,

    Freehand SQL is still NOT support, even with the latest version BI 4.1.3. These DeskI reports will NOT convert properly.

    Regards,

    Ajay

    Add a comment
    10|10000 characters needed characters exceeded

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.