Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
List all users and associated session variables
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,
Answers
-
Lowest-hanging fruit: OBI system variables overview – Dimensionality
0 -
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.
0 -
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
0 -
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.
0 -
Gianni Ceresa wrote:For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.
0 -
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.
0 -
That's what you get out of the box: take it or leave it (because of all the reasons already posted above)
0 -
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
0 -
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.
0 -
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.
0
