Skip to Content

Oracle funtions in BOXIR2 universe designer not working in WEBI 4.1 after migration

Dear Experts,

We are facing an issue after migrating a WEBI report to BO 4.1 SP5.The report is developed in BOXIR2 SP5 and is using Universe UNV based on Oracle store procedures and functions.The report is working fine on XIR2 but after migration to BO 4.1, it's giving incompatible objects error when we try to edit it in the query panel, reports object based on Oracle function unable to refresh the data .Please find the below screenshot of the error for reference.

Waiting for your quick response

Thanks and Regards,

Muhammad Shafiq

pastedImage_0.png (15.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2016 at 09:54 AM

    Hi Muhammad,

    - How many reports are giving this issue?

    - If you create a new report and drag same objects, do you get the issue?

    - How have you migrated the reports? did you first upgraded them to XI 3.1 or directly to XI 4.1?

    - Were any changes made to the universe after migration?

    Regards,

    Yuvraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2016 at 08:16 AM

    Dear Muhammad Shafiq


    In IDT data foundation layer use Insert calculation column and insert you function it will work.



    Regards,

    Harish Puthran

    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.