nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE web catalogue migration from 12c to 11g

User_E9OMM

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.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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

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

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

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]

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]

@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

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]

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

Gotta love IT...