Skip to Content
avatar image
Former Member

Re: FHSQL feature in BO4.1 SP6

Hi Gurus,

I was able to convert the FHSQL based report and Configured the FHSQL data provider,

but i am not able to see the report results, i have to manually select the objects and drag

and drop them to the results panel for the output.

Is there any workaround to get the results without manually selecting the objects for the results.

Also when i am trying to edit the Query it is giving the message:

"You cannot edit this data provider, because it is based on a free-hand SQL script"

Cant we edit the report based out of FHSQL.

Thank you for the Help !!!

FHSQL error.PNG (22.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 28, 2015 at 10:02 AM

    Hi Lilkar,

    You should not get the error below BI4.1SP06 onwards since FHSQL is supported.

    Error: "You cannot edit this data provider, because it is based on a free-hand SQL script"


    We have converted many DESKI rerports to WEBI and used them in BI4.1SP06(Edit/View) and they worked just fine.


    Could you please check whether the report is successfully converted or not?


    ~SwapnilY

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Lilkar,


      There are actually three ways to convert and migrate the DESKI reports to BI4.1.


      So we have followed the following approach.


      We have converted the Desktop Intelligence (.rep) reports from the XI 3.x CMS systems to Web Intelligence (.wid) using the Report Conversion Tool of BI 4.1SP06, and published them to BI 4.1SP06 CMS system (target) without moving the dependencies of source report to the target.

      Here, we did not use the Upgrade Management Tool. RCT will only publish these converted WEBI reports to the target system under the folder "Report Conversion Tool->Report Conversion Tool Documents". If you want you can also change these target folders before publishing.

      After the successful conversion, we have tried to view/refresh/edit it on the target system and it worked fine for us, Please go through the screenshots below.

      Design Mode:

      Edit Query:


      Add Query: We were also able to add a new query.

      NOTE: To maintain the confidentiality of our environments I have removed the object names. Report conversion tool itself will migrate the connections for the DESKI reports to the target as well. The connections would be renamed as "FHSQL002_ConnectionNameOfSourceSystem". We have tested this approach for universe based and FHSQL based DESKI reports, both worked fine for us.

      Followings are our environment details we used:

      Source System: BO 3.1 SP6.2

      Target: BI4.1SP06

      DB: Oracle 11G

      Hope this would help you 😊

      ~SwapnilY

      SCN.png (12.9 kB)
      SCN2.png (39.8 kB)
      SCN3.png (110.7 kB)
  • Oct 27, 2015 at 04:38 PM

    This is by design. Objects in the Select statement cannot be used similar to Universe objects as they are no where physically available.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mani,

      But if we see the report in Structure view, it is displaying as it is in Deski.

      why cant we see it in results.

      Thank you for Help !!!

  • Oct 27, 2015 at 05:54 PM

    Was your source report deski or webi?

    SP6 and before, RCT used to create Universe when you convert FHSQL report, but from SP6 , it does not create any universe, converted report will have FHSQL.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jawahar Konduru

      Hi Jawahar,

      I converted the Deski FHSQL report, and when i am running the report in Webi 4.1 SP6,

      The report is blank, i need to manually select the objects in the results panel for the output.