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

Copying Answers from 10G to 11G and its access problem

Received Response
1
Views
2
Comments
0b78e5eb-9d8d-457c-92d3-c578a6df65f6
0b78e5eb-9d8d-457c-92d3-c578a6df65f6 Rank 1 - Community Starter
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

I am migrating 10G to 11G and having both of OBIEE live, 10G will be terminated in March.

Before I terminate 10G, I need some answers in 10G moved to 11G and copied the "SQL Issued" from 10G to 11G's "New Analysis".

But when I want to open it, below error message pops up.

"You do not have access privilege for this subject area."

I do have access to designated subject area but still can't open that copied answer(analysis).

could you please help me how to solve this problem?

Answers

  • Simon.D
    Simon.D Rank 4 - Community Specialist

    What's the reason you're not migrating the entire catalogue with the migration tool that's provided to you with the 11g installation? How did you move the RPD?

  • Gianni Ceresa
    Gianni Ceresa Mod

    +1 for Simon on that

    The code (both XML and LSQL) of analysis changed between 10g and 11g, OBIEE generates queries in 11g with some extra functions if needed and so copying LSQL between version is the best way to end up with a nice 11g environment but not really clean analysis.

    You can run the Upgrade Assistant as many times as you want and you can run it only on the web catalog if you want.

    So run it against your 10g catalog, store the output in a temporary location and then copy objects (analysis) from there to your 11g web catalog and check the output.

    That's the clean way to try to reduce issues in the future (your 10g LSQL will maybe still behave the same in 11g, but what about 12c the day you migrate?).