Upgrade From OBIEE To OBIEE Features and changes 11G12c[13026] Error in getting roles from BI Security Service (nQSError: 12002, 12010)NQSError:15019 - Table @1%ls is functionally dependent upon level @2%ls[39008] Logical dimension table does not join to any fact source[39059] Logical dimension table has a source at level that joins to a higher level fact sourceAct as (Proxy user) FunctionalityActionAction Framework - How to create and invoke a Java Method (EJB)Administrator AccountAdministration Tool (admintool)Repository Admintool Object Copy/PasteHow to configure BI Server against the LDAP of ADSI ?(Weblogic|OBIEE 11G) - Active Directory (ADSI) Configuration(Ibot|Agent)Aggregate At Function"Aggregate By" FunctionAggregate (Navigation|Table|Content)Aggregate Persistence (Script)Aggregate Persistence Wizard (aka Data Mart Automation)Repository Aggregation rules based on dimension (dimension-specific aggregate)Aggregation RulePeriod to period comparison with the AGO Function Alias (synonyms)Answer/AnalyticsGrand Total Formatting in a Pivot viewApex IntegrationOracle BI Fusion Middleware ArchitectureAt Sign (@)(Presentation column|Attribute Columns)Authentication (ATN)AuthenticationAuthorizationBaseline columnBi-init.cmd (or on UNIX)BI Domain - The complete OBI SystemBI Server (Obis) (Architecture|Overview)Bi Server metrics functionsHome page (bieehome)BIP report integrationBIPlatform SchemaBiserverxmlcliBiserverxmlexec (RPD creation and patching)BiserverxmlgenBISQLProviderBISystemUserBlob data typeThe Business Model and Mapping (BMM)BottomN functionBriefing BookAll the cachesCache ManagerCalculated ItemCalculationCapacity planning / SizingCase When StatementCast as date - Which date format to use ?Cast(NULL as INTEGER)Catalog GroupCatalog ManagerCentral configuration through Fusion Middleware Control(Browser|Database|Third party product) CertificationChoose FunctionBI Server Clients (ODBC, JDBC)Client ToolsCluster (High Availability)Complex (Join|Operator) (Physical and Logical)ConditionsConditional FormattingConnectionConnection PoolConnection ScriptCopy Request Xml to ClipboardCosmetic Formatting (Style, Css)Count (and sometimes Sum)Criteria TabCurrencyDashboardEnable column sorting in DashboardsThe (dashboard|column) promptDashboard parameter prompt - The WHEN 1=0 or ifnull solutionHow to constraint the values of a dashboard prompt based on the selection of an other ?Dashboard Prompt with data level securityHow to create a prompt to handle a parameter ?Dashboard (Url|Link)Data FormatDatabase ObjectDatabase Features ParametersDatatypeHow to mix String and Number data type in one column and obtain a sum ?Date Datatype and FunctionsDbGateway (DB_GATEWAY_THREAD_RANGE)OBIEE / Weblogic 11G - (Create|Recreate) a default authentication provider (with administrator, ...)DeliversAdvanced Publication with Delivers (In Java)What means "Data is dense" ?Densification / Dimensions Preservation PossibilitiesDensification with the fact-based fragmentation capabilitiesLog Files (Oracle Diagnostic Logging - ODL)Dimension (Logical Table)Dimension fragmentation design to add an automatic filter with the choice of a columnIdentifying a Dimension TableHow to create a measure from data that is stored in a dimension tableDirect Database RequestTable Function/Stored Procedure in Direct Database Request(Display Function|Derived Measures) (Rank, TopN, Median, ...)Basic Discrete Distribution ReportDMS Metrics(Universe|Domain)Double column (Descriptor Id)Drilling (Down and Through)Driving TableDXE ExecutionEBS IntegrationEqualizing ObjectsEqualizerpds utilityEssbaseEvaluate - Embedded DB FunctionsEvent Pooling table (Event Table) to purge the cache after ETL processMicrosoft ExcelHow to create an HTML view (Narrative, Static Text) to get a good Excel formatting ?EXECUTE PHYSICAL CONNECTION POOL StatementOracle BI Server Execution EngineExtractprojects utilityFact table (of logical fact table)Defining a Non-Aggregated Measure (Baseline column) of a Fact TableIdentifying a Fact TableDefining the Logical Key of a Fact TableFederated Query / Multi-Database or Cross-Database JoinFilterConditional Filtering based on Presentation Service VariableHow to force a user to filter on a column A every time column B is in the requestPivot Measures (The Filter Function)Filter on current timeThe relative path fmapForeign Key or Physical Join (Fragment|ation) (Partitioning)Fragmentation Content, value-based, horizontal partitioningFact-based vertical partitioning/fragmentationAggregate Navigation with level-based fragmentationFull outer JoinFunctionsTime Series Conversion Functions : AGO and TODATEFunnel ViewGauge ViewGetting Started / TutorialThe Go URLGrain - Level of (summarization|aggregation)(Chart|Graph) View(Group|Security Role|Application Role)Aggregation rules in Logical SQL with the GROUP BY and BY clauseGUIDGuided NavigationHadoop HiveSAP HanaHardenXSS - Specifying Whether to Allow HTML Input in OBIPS FieldsDimension Hierarchy (logical dimensions)Level-based HierarchyHintHistoryHtml Content CachingHTML MarkupIbotVoid (Id)Repository Object IdentifierIframeIIS BI Presentation Service Plugin (OC4J listener)Where and how to call an image / picture ?ImpersonateImplicit Fact ColumnImport WizardHow to retrieve data from BI Server in Excel ?IndexCol Function - Handle hierarchy Level securityInitialization BlockInstallation / ConfigurationOracle Business Intelligence 11.1 Simple installation steps on Windows and OEL Linux 32 bitInstanceInstanceconfig.xml (Configuration Presentation Services)Integer DatatypeOracle BI Open Intelligence Interface (ODBC and JDBC) client connectivityMobile Application, Mobile DeviceIssue SQL (the IssueRawSQl Url)Java HostJavascriptJdbcOracle BI JDBC DriverJob ManagerJoinHow to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?Joins definitions in the repository (complex, foreign, logical table source)KPIPeriod to period comparison (YAGO, MAGO) with the analytical function Lag/LeadLast/First functionThe drop targets of a layout (view|pane)LDAP over SSL with Global Security Kit (GSKit)Left outer joinLogical levelConfigure Level Number of Elements in Dimensional HierarchiesLinux OEL 5 x86 Installation version system session variableLocalizationCommon Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)Logical ColumnLogical JoinLogical Request (before navigation)Logical SqlLogical TableLoginSetting a Query Logging LevelLookup FunctionLogical Table Source (LTS) (Physical and Logical Column Mappings)How to see the Physical SQL generated by a request in Presentation Service ?(Manage|Configure) Map DataBI Management PackMap ViewMapviewerOracle Marketing SegmentationMaster Detail(MDS|Metadata Service) (XML|XUDML)Measures (Columns|Attributes)Level-Based Measure CalculationsNested aggregate measureMerge RepositoryCustom MessagesGenerating and Deploying a Metadata DictionaryOracle BI DMS MetricsMonitoring - (Performance|Perfmon) (Metrics|Counter)Redirect to MonitoringReporting on Multiple Subject Area (Advanced Logical SQL)MultiUser Development Environment (MUDE - Projects)Narrative viewHow to set up a navigate interaction ?(Invoke|Navigate) to an URL (Web Page|HTTP Request)Data Navigation (Drill Down, Through, Link, ...)No Result ViewNQClient.exeNqcmd.exe ODBC Client ToolNqgenoldverrpd (Repository Downgrade)The nQuireID ( Authentication nqid )The Log Viewer (nQLogViewer)Nqquery.log (Query logging)Connection Pool Password ChangeNQSConfig.iniNQsError: 35008 - An error occurred while trying to check outNQServer.logAuthentication Web Service with SAWSessionService (nQSessionService)Nqudmlgen.exeHow to find the value, the data type of a Server variable ?How to define OBIEE to leverage SQL OLAP Query ?Oracle Warehouse Builder IntegrationThe answer PromptHow to customize the background color of a graphBackupHow to define a Many-to-Many relationship with a Bridge table ?How to connect remotely to the servers (BI, Presentation) ?Complement SoftwareFederated Query with Excel SheetHow to limit the number of records fetchHow to define a One to Many RelationshipNullArchitectureRss FeedScript to start Oracle BI Servers and Cluster ControllersOC4JOracle Call Interface (OCI) configurationODBCODBC ClientOracle BI ODBC driverHow to create an Analytics ODBC Data Source (System DSN ODBC connexion)BI Server (JDBC|ODBC) Driver FunctionsMicrosoft Office Server and (Add-in|Plug-In)Opaque ViewORA-00937 - Not a single-group group functionOuter JoinParameters (parameterized query)PasswordPatchIn-Place Upgrade - Patch Set Installation from version to version Upgrade - Moving from to Server PatchHow to redeploy the BI Presentation Service Plug-in (after a patch Installation, Don't forget to redeploy the WAR/EAR file)PDFPERF_PREFER_INTERNAL_STITCH_JOIN database featurePerformance Monitor (Perfmon)Repository PermissionPersist connection poolPhysical Alias Physical LayerPhysical SQLCross conditional formatting on a pivotHow to sort on a measure column of a pivot view ?How to sort on the column grand total value of a pivot view ?How to suppress detail rows of a master group in a pivot view ?How to pivot a character column ?Pivot ViewPlus ComponentsPopulate StatementPorts(Presentation Hierarchy|Hierarchical Column)Presentation LayerBI Presentation Service (SAW/OBIPS)Presentation Services ArchitecturePresentation Service (Query|Result|Cursor) CacheHow to install an other instance of Presentation Services on one Application Server (OC4J)Presentation Service Plug-inPresentation VariablesDatatype of a presentation variableDate Format in presentation variable, dashboard prompt and logical SQLHow to set a presentation variable ?Presentation Variable System (reserved variable)Where can I use a presentation variable ?Privilege packagePrivilegesProjects Release (Promotion|Migration) - From Dev, Test to ProductionPromptFully Qualified Name Object Identifier (Object Path)BI Server (Logical Query|Result) CacheLogical Query Result Cache ParametersPurging / Disabling the Query CacheWhy a Query is Not Added to the Query Cache ?Query CompilerQuery PlanQuery ProcessingRankRegular Expression (Regexp) and how to filter on string pattern ?How to model the different relationships ?Report-based TotalRepository (RPD file)Repository DesignObjects Import from another repositoryRequestRequest variableRight outer join(Row-wise|List of Values) server variableOracle BI Server XML API (XUDML)Running Sum (RSum)How to produce and show a total section on **each line** (Running total)?Usage Tracking S_NQ_ACCT TableS_NQ_INSTANCE tableS_NQ_SUMMARY_ADVISOR tableSA System subject areaSametaexport utility (Metadata Exchange)Installation Sample Application version 825Sample App V107SAP BWSASchInvoke (command line Triggering of Oracle BI Scheduler Jobs)Saw Url - Symbolic URL Parameters AppletHow to set a request/session variable using the Saw Url (Go/Dashboard)Presentation Services log (sawlog.log)ScalingBI SchedulerBI Scheduler Configuration (for Delivers)How to configure the Mail server of Scheduler/DeliversScorecards (and Strategy Management)SecuritySecuritySecurity (Level|Type)How to define the BI server security to add automatically a filter when a column is added to an answer (row security level)The Security ManagerSELECT_PHYSICAL statementsSelection Steps"Server Complex Aggregate" ruleInstalling Oracle BI Components on Different MachinesServer ThreadBI Server Variables (session and repository)How to set and use a server variable (system/repository) of type date ?Where can I use a BI Server variable (session/repository) ?SessionSession ManagerHow to set a server variable with the session type via a dashboard prompt (with a request variable) ?How and where can I set a Request variable (SET VARIABLE) ?How to define one different database credential for each user (the shared logon) ?Single table model.Look and feel Customizing (Style and Skin)OBIEE 11G ( - How to configure a new SkinOBIEE 10G/ - How to create a New Style and Skin ?Quick Skin and Style customizationData Source (Oracle Analytics Adapter)Special CharactersStarting Oracle Business Intelligence on WindowsHow to Start and Stop the services ?How to start and stop OBIEE automatically with a Bat file ?Static Text ViewStaticports.iniStitch Join (Intern Join Operations)Subject Area / Presentation catalogExalytics Summary Advisor(Error Correction) SupportSystem (Configuration) Management (Mbean)System session variables (reserved variables)How to perform a pivot in a table viewTable viewTemps filesHow to set up the time dimension (for time series functions Ago, Todate, ...) ?Time zoneTitle ViewTopNUDML(Upgrade|Refresh|Recover) GUIDUpgrade from the Sample App SampleSales 10gUpgrade ID (UID)Base URLPassing Filters through the Go and Dashboard URL(Usage Tracking|UT) (Query Log)Which Usage Tracking time measure should be used to gauge the performance of SQL retrieval time ?UserBI Server UtilitiesAll type of variablesVariable ManagerThe variable promptOBI VersionVersioningHow to control the use of the WITH CLAUSE and of STITCH Join ?ViewsVirtual Private DatabaseWeb Services API (SOAP,WSDL)The (Web|Presentation) Catalog (Webcat)Translate the WebCat (Dashboard, page and report names)WEBLANGUAGE system session variableHow to add a wiki to OBIEE (installation of a wiki on OC4J standalone)Windows Installation Version Services as Windows Services InstallationSSO Authentication with Windows Native Authentication (WNA)Writeback Capabilities (Table of Pivot)XMLHow to retrieve a result set with the XMLViewService WebService and the logical SQL ?


OBIEE - System session variables (reserved variables)


System session variables are session variables that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.

System session variables have reserved names, that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

System session variables obtain their values from initialization blocks.

Every active BI Server session generates session variables and initializes them. Each session variable instance can be initialized to a different value.

11G 10G



PROXY and PROXYLEVEL are used to authenticate proxy users in the act as functionality.


time zone setting


Used for Oracle BI Presentation Services. It contains the name that will be displayed to the user in the greeting in the Oracle BI Presentation Services user interface. It is also saved as the author field for catalog objects. For internal Oracle BI repository users (nondatabase users), this variable is populated with the user's full name.


Contains the user’s default email address for use with Answers. If the delivery option of Answers is enabled, an email device using this address will be created for the user upon first log in. Users can override this address by changing their account settings in Oracle BI Presentation Services.


Contains the groups to which the user belongs. These are used by both the Oracle BI Server and Oracle BI Presentation Services. When a user belongs to multiple groups, separate the group names with semicolons. Do not delimit text (for example, do not surround the text with single or double quotes). Use a Varchar column in a database table to contain the group memberships. For example, if a user belonged to groups called Sales US, Sales UK, QA and Dev, and Doc, the text entered into a Varchar data type column in a database table would be: Sales US;Sales UK;QA and Dev;Doc. Note: The Oracle BI Presentation Services Administrator needs to make sure that the names of Presentation Services groups are different from any user IDs that will be used to log on to Oracle BI Presentation Services. If a user and a Presentation Services group share the same name, the user will receive an Invalid Account message when attempting to log on to Oracle BI Presentation Services.


These two variables are set and tracked by Oracle BI Presentation Services to manage the synchronization of Oracle BI Disconnected Analytics. For more information, refer to Oracle Business Intelligence Disconnected Analytics Administration and Configuration Guide.


The value of LOGLEVEL (a number between 0 and 5) determines the Logging level that the Oracle BI Server will use for user queries. This system session variable overrides a variable defined in the Users object. If the Administrators Users object has a Logging level defined as 4 and the session variable LOGLEVEL defined in the repository has a value of 0 (zero), the value of 0 applies.


Used for Oracle BI Presentation Services. It identifies the default dashboard the user sees when logging in (the user can override this preference after logged on here : Settings → My Account → Preferences → “Default Dashboard”). See How To Configure A Default OBIEE Dashboard Or A Welcome Page For All Users Using PORTALPATH Variable


Used for Oracle BI Presentation Services. Any users with the same nonblank request key will share the same Presentation Server cache entries. This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Server. Sharing Presentation Server cache entries is a way to minimize unnecessary communication with the Oracle BI Server.


Determines certain elements of the look and feel of the Oracle BI Presentation Services user interface. The user can alter some elements of the user interface by picking a style when logged on to Oracle BI Presentation Services. The SKIN variable points to an Oracle BI Presentation Services folder that contains the nonalterable elements (for example, graphics such as GIF files). Such directories begin with sk_. For example, if a folder were called sk_companyx, the SKIN variable would be set to companyx. Style and skin names cannot include underscores.




Specifies additional groups specific to Oracle BI Presentation Services, if any. The use of Presentation Services groups provides a mechanism for more granular content control.


The WEBLANGUAGE variable contains the language of the user. More: OBIEE 10G/11G - WEBLANGUAGE system session variable.


OBIEE two-letter (shown in the LOCALE parameter entry of NQSConfig.INI File)


If this value has the value 1 for a request, then the BI server doesn't try to find a query cache. More … OBIEE - Purging / Disabling the Query Cache


If this variable has the value 1, the result will not be seeded in the query cache.


This variable store the preferred currency value of the user.


This system session variable permit to indicate the subject area where the priority group of the logical table source can be reversed. It permit with the help of the variable REVERSE_LTS_PRIORITY to dynamically select a source at run time.


This system session variable indicate all subject area where the priority group of the logical table source is permantely reversed.


This system session variable is much more use as request variable to reverse the value of the priority group of the logical table source.




Determines if the initialization blocks required for authentication are executed. This variable has a value of Yes. The value is case-insensitive.


contains the application roles to which the user belongs.



If a semicolon must be included as part of a role name, precede the semicolon with a backslash character (\).


Contains the global unique identifiers (GUIDs) for the application roles to which the user belongs. GUIDs for application roles are the same as the application role names.




Contains the permissions held by the user, such as




Contains the global unique identifier (GUID) of the user.



Contains the global unique identifier (GUID) of the group.










Documentation / Reference

  • Bookmark "OBIEE - System session variables (reserved variables)" at
  • Bookmark "OBIEE - System session variables (reserved variables)" at Digg
  • Bookmark "OBIEE - System session variables (reserved variables)" at Ask
  • Bookmark "OBIEE - System session variables (reserved variables)" at Google
  • Bookmark "OBIEE - System session variables (reserved variables)" at StumbleUpon
  • Bookmark "OBIEE - System session variables (reserved variables)" at Technorati
  • Bookmark "OBIEE - System session variables (reserved variables)" at Live Bookmarks
  • Bookmark "OBIEE - System session variables (reserved variables)" at Yahoo! Myweb
  • Bookmark "OBIEE - System session variables (reserved variables)" at Facebook
  • Bookmark "OBIEE - System session variables (reserved variables)" at Yahoo! Bookmarks
  • Bookmark "OBIEE - System session variables (reserved variables)" at Twitter
  • Bookmark "OBIEE - System session variables (reserved variables)" at myAOL
dat/obiee/system_session_variable.txt · Last modified: 2014/07/14 09:22 by gerardnico