Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Change Schema for OBIEE Reports

Received Response
291
Views
19
Comments
2»

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Bhaskar,

    Not sure if the error is related to schema change. What I could find was a support document.

    https://support.oracle.com/epmos/faces/DocumentDisplay?id=2167987.1

    I do not know what changes other than the schema change was done to the environment. What is your OBIEE version?  Also test in a different browser.

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    Hi Sherry George,

    thats very helpful , its right on exact same error m getting

    to answer we are using : Oracle Business Intelligenc 11.1.1.9.0

    guess , i will need to figure our where this java code was built? so i can modify per the article to see if that helped

    do you know where can i find the java code with in obiee?

    Regards:

    Bhasker.V

    Jsglp

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Bhaskar,

    You will need to provide more details about what exactly you are experiencing with "some" reports. This can include your observations like if it is happening for some particular columns or in dashboard prompts etc..A reproducible test case will help.  May the report has some java script in narrative view (you can find this in results tab).

    I will also suggest that you may close this thread by marking it "Answered"(since your original question about pointing OBIEE to new schema has been answered)  and open a new one to discuss the current issue, (you can refer this thread from the new one) and you can provide all the details about the issue there.

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    Hi Sherry George,

    thanks for all your inputs, infact that doc that you have shared did help me in resolving that java error it perfectly worked with that solution

    with Catalog-->Dashboards-->Report(Select)-->Edit-->Selection 1 -->Text 1--> copy that Java code and paste in notepad/editplus etc, find below text(1st one)  and change to 2nd one

    Change from -->

    if( ! h.verifyPromptValuesAndDisplayError(b))

    Change to-->

    if( ! h.verifyPromptValuesAndDisplayError(b,{bCheckForRequired:true}))

    Thanks for all your help and support

    I truly appreciate all your inputs

    Regards:

    Bhasker.V

    Jsglp

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    is there way to close this thread?

    please let me know i will do that, i cant find one

    Regards:

    Bhasker.V

    Jsglp

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Bhaskar,

    Glad it worked for you. You can mark one of the responses as correct answer and that should be all.

    pastedImage_0.png

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    did thanks again

    Regards:

    bhasker.V

    Jsglp

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi Christian,

    I would discourage people using this as a standard for 12c as it is all too easy to save the local back to the server which corrupts the rpd password, which depending on your rpd discipline can be painful.... the download / upload functionality with 12c is fast and robust and encourages version control or at least keeping local copies - just an opinion....

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    True. I just wanted to say "it is there"