Oracle BI (OBIEE) provides multiple categories of Variables, such as:
- Session
- Repository
- Presentation
- Global
These different categories of variables need to be referenced using a specific syntax. However, the required syntax depends on the category of variable and the context. Below are examples for referencing Session variables in Analysis/Reports and within the narrative View. This is often useful for debugging scenarios or for performing unit test when creating complex formulas.
To reference a Session Variable within a Report use: VALUEOF(NQ_SESSION.GROUP) like below:
To reference a Session Variable within a Narrative View use: @{biServer.variables[‘NQ_SESSION.GROUP’]} like below:
The complete code to reference the different Session variables (User, Group, Roles) is as follows:
[b]Derzeitiger User:[/b] @{biServer.variables['NQ_SESSION.USER']} [br/][br/] [b]Derzeitiger Anzeigename:[/b] @{biServer.variables['NQ_SESSION.DISPLAYNAME']} [br/][br/] [b]Derzeitiger Gruppen:[/b] @{biServer.variables['NQ_SESSION.GROUP']} [br/][br/] [b]Derzeitiger Rollen:[/b] @{biServer.variables['NQ_SESSION.ROLES']} [br/]
For a exessive list of available Session variables check:
For general Overview check:
For short reference card check:
For Official Documentation check (11g):