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

[Former Member]

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?

[CdnConnection]

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

[Former Member]

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