Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to read, without error, session variable

Received Response
1
Views
1
Comments
Brian P
Brian P Rank 1 - Community Starter

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

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.