This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,963 Users
  • 2,269,775 Discussions


OBIEE- Same report , different users , different physical query

Hi All,

In OBIEE, is there any way to achieve this?

When users with different responsibilities login to OBIEE, and access same report, OBIEE should hit different physical table (or opaque view query)

Thanks in advance




  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,730 Gold Crown

    Yes. You can use session/request variables to change the target table in the RPD.

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director SwitzerlandMember Posts: 6,761 Blue Diamond

    While Christian is right and the answer is "yes", you are maybe overthinking what you need.

    Because keeping it simple: why a same "report" (do you mean analysis? dashboard page?) would be sources from different places based on a role? Wouldn't that be more 2 different analysis and so the need would be covered by showing analysis A to user A and analysis B to user B based on their roles or something like that?

    Keep in mind that you need to maintain your model, and if you start switching sources based on roles, it will become quite difficult for anyone to have a clear view of what is used where (think about lineage etc.).