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
Sasikiran
Yes. You can use session/request variables to change the target table in the RPD.
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.).
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
I am getting syntax error when im trying to add full table hint in evaluate for an obiee report analysis column. This is the function im adding the below: why isnt the syntax working, what is missing or incorrect here in the function?
Hello everyone, We use OBIEE 11.1.1.9, on Oracle Linux. We have set up Usage Tracking. It shows users but it misses some of them. How can I see all users?
Hi everyone, I have a cascading prompt setup in OAS Classic (OBIEE 12c) that works for single selection but fails on multi-selection due to variable formatting. The Setup: Column Prompt 1: "Cost Center" (Multi-select enabled). Sets variable @{COSTCENTER_CONCAT_PROMPT}. Column Prompt 2: "Organizational Unit". Filters its…
How can you put a total number of records in your oracle OAC table footer
