There has been a lot of discussion on the ETL aspect of business intelligence solution. Let us now discuss about the reporting aspect of business intelligence. Oracle BI as a part of fusion middleware solution provide its standard reporting platform Oracle business intelligence enterprise edition(OBIEE 11g) for doing reporting. OBIEE 11g as a reporting tool provides feature and functionalities that are used to provide out of box solution to different business needs. It leverages the weblogic technology and legacy Siebel Analytics solution platform.
In OBIEE 11g we have a concept of variables. Variables in OBIEE are used to store global values that are used in multiple areas. There are two types of variables in OBIEE.
1. Repository variable: These variables are initialized only once or are refreshed only after a certain interval. These variables are used for storing values like global currency for reporting. Default values for all the users for some variable.
These variables are of two types:
a. Static variable: These variables are initialized during creation time only and the values can be modified only from repository administration tool > Variable Manager.
b. Dynamic variable: These variable can be changed after creation using event polling.
2. Session variable: These variables have a copy for each user instance. These variables are initialized after a user logs in to the system.
The variable are initialized using the initialization block. These variables are of two types.
a. System variable: These variables are system sepcific variable like USER etc. These are system reserved variables and no new variables can be defined with the same name as system variable.
b. Non System variable: These variables are defined by user for project spefic purpose and are initialized using initialization block at each login by any user.
Although you would think why I suddenly started with variables in OBIEE as a start of discussion on OBIEE. Well this has to do with the problem I faced while learning OBIEE. During my learning curve I had a lot of confusion regarding variables and its types in OBIEE. In a hope to solve my problem I endlessly searched for a place to clear my concept. However all my endeavours ended in failure.
In the next post we would discuss about the concept of aggregation in BMM layer of OBI.
In OBIEE 11g we have a concept of variables. Variables in OBIEE are used to store global values that are used in multiple areas. There are two types of variables in OBIEE.
1. Repository variable: These variables are initialized only once or are refreshed only after a certain interval. These variables are used for storing values like global currency for reporting. Default values for all the users for some variable.
These variables are of two types:
a. Static variable: These variables are initialized during creation time only and the values can be modified only from repository administration tool > Variable Manager.
b. Dynamic variable: These variable can be changed after creation using event polling.
2. Session variable: These variables have a copy for each user instance. These variables are initialized after a user logs in to the system.
The variable are initialized using the initialization block. These variables are of two types.
a. System variable: These variables are system sepcific variable like USER etc. These are system reserved variables and no new variables can be defined with the same name as system variable.
b. Non System variable: These variables are defined by user for project spefic purpose and are initialized using initialization block at each login by any user.
Although you would think why I suddenly started with variables in OBIEE as a start of discussion on OBIEE. Well this has to do with the problem I faced while learning OBIEE. During my learning curve I had a lot of confusion regarding variables and its types in OBIEE. In a hope to solve my problem I endlessly searched for a place to clear my concept. However all my endeavours ended in failure.
In the next post we would discuss about the concept of aggregation in BMM layer of OBI.
No comments:
Post a Comment