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

OBIEE web catalogue migration from 12c to 11g

Received Response
51
Views
8
Comments
User_E9OMM
User_E9OMM Rank 4 - Community Specialist
edited Aug 13, 2024 5:27PM in Oracle Analytics Cloud and Server

Hello,

Due to certain reasons, we are having to downgrade OBIEE 12c to 11g.

There are around 5 dashboards and 40 reports and many more front end objects are present in OBIEE 12c.

We have to migrate the code to OBIEE 11.1.1.9 Can you please suggest the best approach to execute this task?

Thank you.

AB

Answers

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

    Uuhhh that's the worst idea I have heard in this forum in the last 12 months. Easily.

    What could possibly make you downgrade to an unsupported version?

  • User_E9OMM
    User_E9OMM Rank 4 - Community Specialist

    Yes that's true, the premium support would end soon however, there are certain reasons for which we want it to be downgraded.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    1877648 wrote:Can you please suggest the best approach to execute this task?

    Take a workstation with 2 screens, open the 12c OBIEE on one screen, open the 11g OBIEE in the second screen.

    Start recreating every single object by hand, one by one.

    5 dashboard, 40 analysis (a report is a BI Publisher report, I doubt you have those) and few more things will not be too long.

    This will give you the cleaner downgrade possible.

    (and I'm not even joking on this! )

  • Gianni Ceresa
    Gianni Ceresa Mod

    Of course you could try by copying the XML around between the versions, but you could have unsupported XML not allowed by the 11g XSD or things which are allowed but not working in that way.

    So any automated approach could take you long to compare and debug. Being such a small environment in 1-2 days you must be done by recreating things (and why not try to implement some minor cosmetic changes you have maybe been asked for? Would give you an excuse for justifying doing it by hand if somebody ask )

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

    What the...

    Are you kidding? This is WRONG. Just WRONG. @Gianni Ceresa you think you're a funny guy, but you just sent him off into a wall. And having added that last bit doesn't make it any better.

    @1877648 Do NOT do that!!

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

    @1877648 What made you take that decision? Because the decision is wrong to begin with. You're about to destry your whole project and implementation.

  • Gianni Ceresa
    Gianni Ceresa Mod

    I'm totally with you on the fact that a move back to 11g isn't a solution to a failed move to 12c. He said he has "certain reasons", not giving a single one. This sounds like somebody somewhere decided that, and we can't do much against "smart people" knowing better.

    Of course they better try to solve the "certain reasons" and stay on the only really supported and evolving version (12c), but the OP sadly isn't asking for that.

    And trust me: I hate myself enough for having posted what I posted above...

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

    And most likely the OP will never ever look at his thread again and just blindly do this without thinking.

    Gotta love IT...