OBIEE - Initialization Block

Bi Server Architecture With Client

Connection Pool

Query Only Selectable Object

This option will show you all connection pool that are not the first one.

Obiee 11g Connection Pool Query Only Selectable

Option

Required for authentication

This option is designed to check the Initialization block who hold security/important variables.

In other word, if the initialization of this variables does not succeed the user is not authorized to log in otherwise for instance:

  • OBIEE can show data where the user has no authorization (for instance, with the GROUP variable)
  • some functionalities will not work

It's not recommended to check it on a authentication init block oterhwise you can get this error:

[nQSError: 13024] Successful completion of init block 'Authentication' is required

How to

Create a date server variable

Init block parameters:

  • SQL Statement
SELECT to_date(to_char(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') FROM DUAL
  • The Variable Target Default Initializer defines the data type
date '2013-01-01'

Documentation / Reference





Discover More
Bi Server Architecture With Client
OBI Server - User

User is a system session variable that: represent an account holds the value the user enters as his or her logon name. It is involved: in the authentication security process to set it up and...
Obiee Row Wise
OBIEE - (Row-wise|List of Values) server variable

A server variable can be initialized to a list of values (vector) with the row-wise initialization option of an Init block. cached This SQL statement populates the variable MY_VARIABLE_NAME with...
Obi Edition
OBIEE - Authentication (ATN)

Authentication in an OBIEE context. USERinit block1609872.1can authenticate a user The goal of the authentication configuration is to get a confirmation of the identity of a user based on the credentials...
Obiee Variable Manager
OBIEE - BI Server Variables (session and repository)

The OBI Server can handle two types of variable : repository variable: constant or refreshed periodically session variable: depend of the user and are then set up during the login process. system...
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Obiee Repository Variable Date Type
OBIEE - How to set and use a server variable (system/repository) of type date ?

This article is a tutorial on how to set a date in a server variable (session variable of repository variable) and use it. This article use the schema SH : SH repository installation in the database and...
Obi Edition
OBIEE - Password

The password is a system session variable that: is involved in the authentication security process holds the password the user enters during the login process. The Password variable is populated...
Obiee11g System Session Variable
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...
Bi Server Architecture With Client
OBIEE - Variable Manager

The variable manager is an application included in the administation tool created in order to initialize the server variables with the help of initialization block
Obiee11g Default Logging Level
OBIEE 10G/11G - Setting a Query Logging Level

The login level is a parameter which control the number of information that you will retrieve in the log file from nothing (level 0 - no_log_found) to a lot of information (level 5). You can enable logging...



Share this page:
Follow us:
Task Runner