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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
