Description
Variables in OBIEE are characterized by utilizing the statement of DECLARE. Qualities can be allotted to factors utilizing the SET explanation or the SELECT INTO proclamation or as a default esteem when the variable is pronounced. Expressions,Literals,the result of a query, and extraordinary enroll qualities can be doled out to factors.
In OBIEE,the variable can be classified into 2 types such as:
- Session variables
- Repository variables
Description
Session factors are same as of the variables of dynamic repository and they acquire their qualities from the blocks which are in-statement. At the point when a client starts a transaction, the server of BI makes unique examples of session factors and introduces them.
Session variables consisting of multiple number of dynamic transactions on the server of BI. Every occurrence of a transaction variable could be introduced to an alternate esteem. And transaction variables can be classified into the following types such as:
- System session variables
- Non-system session variables
Description
It is utilized by Oracle BI and Presentation server for particular purposes. They have predefined saved names which can't be utilized by different factors. And system session variables can be classified into the following types such as:
- User
- Userguid
- Group
- Roles
- Roleguids
- Permissions
Description
These variables are utilized for setting the client channels,such as the one can characterize a non-framework variable called Region of scale that would be introduced to the name of the sale_region of the client.
Description
It contains a solitary esteem at any point of time. It characterized utilizing Oracle BI Administration instruments. And these are utilized as a part of place of constants in Expression Builder Wizard. Repositories can be classified into the following types, such as:
- Dynamic repository variables
- Static repository variables
Description
These variables are similar to the variables of static however the qualities are invigorated by information that are return from query. At the point when characterizing the user make an introduction piece or utilize a prior one that contains a SQL statements. And an likewise set up a calendar that the Oracle BI Server will take after to execute the inquiry and revive the estimation of the variable intermittently.
These variables are valuable for characterizing the substance of legitimate table sources. For instance, assume you have two hotspots for data about requests. One source contains current requests and alternate contains authentic information.
Description
These variables will characterized in a discourse box of a variable and their esteem exists until they are changed by the database administrator.
It consists of a default initializes that are character or numeric esteems. Likewise, you can utilize Expression Builder to embed a steady as the default initialized, for example, date, time, and so on. One can't utilize whatever other esteem or expression as the default initializes for a static archive variable.
Key points
- Variables - Characterized by utilizing the statement of Declare and other set of proclamation.
- Session variables - Same as dynamic variables.
- Repository variables - Which is unique value at any point of time.