Hello Experts,
Is there any way to list-out the users and its associated session variables (with value) information in OBIEE 11G/12C.
Please post your suggestions if anyone came across this similar requirement.
Thanks in advance,
Lowest-hanging fruit: OBI system variables overview – Dimensionality
Hi,
Christian's answer is more for you as the current user.
For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.
If you mean for all the users in general of course it isn't possible as a session variable only exists if there is a session, so you can't list variables which doesn't exist.
One reason I also didn't want to go into more detail is that if you script that you are pulling quite a bit of information in a programmatic way which may be security-sensitive so I wouldn't necessarily productize it
Thanks for your inputs..
But my requirement is get the session values for all users in a time.Let me check if any way to find the solution.
Thanks.
Gianni Ceresa wrote:For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.
Mahesh KR wrote:But my requirement is get the session values for all users in a time.Let me check if any way to find the solution.
That will only work if your program something which logs on a s each users at a time, dumps out all variables, logs on as the next, dumps out variables,... and loops through all users.
Also I find that approach questionable since most variables are totally dynamic in nature. Meaning they can change from login to login even for one given user.
That's what you get out of the box: take it or leave it (because of all the reasons already posted above)
Mahesh KR wrote:But my requirement is get the session values for all users in a time
The OP probably implicitly doesn't mean one by one but in bulk.
Your comment is 1000% valid and what I would do / use too but he probably targets something more global and "less effort" as so often
I know, but that's why I added the "That's what you get out of the box: take it or leave it" ...
As you said above and I also said: nowhere you find that list in a nicely accessible way. Sessions variable are based on sessions, so to get them all at once it means to code a lot by hand.
And here is the question is: why? Why does someone want the list of variables? Take the init blocks with the queries and problem solved: at any point in time you can get the value of any given variable for any given user. So the need itself has no or little use case also because it depends on the users currently connected.
So out of the box there is that screen for one by one analysis of what are the variables, for all take the init block queries and execute them. Of course if VPD or other strict security is in place then it doesn't work anymore, but here is't maybe better to not have access to that list ...
All in all we are looping again and again: out of the box is one by one, anything else is done by hand.
You can put the variable names and their values in a Narrative view (then you can lay out the information in HTML the way you want to see it) ... then using 'act as' you can login and see what a given user is getting as the values for their session (or you can allow them to go to a dashboard which shows them their current values -- I've done this a ton and it helps in solving issues).
Doing it for ALL users is going to be a ton of customization - for not a lot of value. You only care when the value isn't right and then you are looking at a single user for debugging purposes.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
