Categories
- All Categories
- 151 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
how to read, without error, session variable

Hi Community,
First time community user, hopeful this is a good place to post.
Have some Analysis where we use session variables like NQ_SESSION.user ... works no problem.
Now, attempting to iterate thru a list of User Groups or Roles, to determine if the logged in user, has the role, associated with a specific value. Trying to figure out how to adjust the formula column to process that, using either the NQ_SESSION.ROLES or NQ_SESSION.GROUP session variable.
Initially thought there might be a function like 'split' but that does not appear to be exposed thru the user interface.
Objective:
looking to perform a similar operation where we want to use the session variable representing the Roles the logged in user is in, to determine if they are in a pending approver role. The Session Variable ROLES (or possibly GROUP) should return the list of all Roles (semicolon separated string). However, for simplicity, if we set the Formula of a column up to return the string … we are consistently getting a too many rows.
Any thoughts, insight or direction here would be greatly appreciated.
Brian
Answers
-
Take one step back and explain in detail what you're trying to achieve. "Now, attempting to iterate thru a list of User Groups or Roles, to determine if the logged in user, has the role, associated with a specific value."
What exactly do you want to compare NQ_SESSION.ROLES against? Something in a DB table?
You're probably too deep in the solution you chose already.
0