OBIEE â Variables In OBIEE, there are two types of variables that are commonly used − Repository variables Session variables Apart from this you can also define Presentation and Request variables. Repository Variables A Repository variable has a single value at any point of time. Repository variables are defined using Oracle BI Administration tool. Repository […]
Author Archives: user
OBIEE â Calculation Measures Calculated measures is used to perform calculation of facts in logical tables. It defines Aggregation functions in Aggregation tab of logical column in the repository. Create New Measure Measures are defined in logical fact tables in repository. Any column with an aggregation function applied on it is called a measure. Common […]
OBIEE â Aggregates Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table. How Aggregation Works in OBIEE? When you execute a […]