1.Average

2.Count

3.MAX

4.MIN

5.Median

6.SUM

Using the above aggregate functions the data will be inserted in aggregate table.The aggregate tables are used for performance optimization and data is coming fast using aggregate table.Aggregations applied on database level improves the performance of the query as the query not hits directly on table it will hit on aggregate table and fetches data.

Real Example:

If table contains the data of year 2016 and 2017 ,User wants a actual count of records in the table monthly,Quarterly and yearly.Then We need to make aggregate table which contains count of records  monthly,For Quarterly we need to create other table and push the quarterly count in that table.And we need to use that tables in the reports so that report performance will improve drastically.

13.What is Conformed Dimension in OBIEE ?

Answer :

In any case you don’t have 2 fact tables in one to one relation. To make one to one relation between two fact table one dimension table which have relation between two fact table acts as a bridge to connect two fact tables is known as conformed dimension.

14.What is mean by opaque views?Why it is used?

Answers:

When handling complex requirement is not possible in data modeling from RPD side in obiee then user needs to create direct select statement and use it in to RPD is known as Opaque view.It is not recommended to use Opaque views as it degrades the performance of the report.

15.What is implicit fact column?

Answer :

The implicit fact column is the one that is created due to the join, combinations from the different data or columns from the different tables. There may not be the exact data in form of the column in the result or even in the physical layer of database. These are implied from different data and can just be a temporary layer which help us in getting the required result.

16.Where user can check the user sessions and report duration?

Answer :

The user can check the sessions as well as report duration in OBIEE tool –>Administration –>Manage sessions.

On this tab user needs to check for the report names(CTR+F) then search report name.

17.What are different types of security mechanisms in OBIEE?

Answer :

There are two types of security mechanisms applied from OBIEE side :

1.Object Level Security

2.Data level Security

1.Object Level Security:

The Object level security is a higher level of security that allows/disallows the access for user to specific table, row or column according to his access level.

The Object level of security are permissions corresponding to the objects in the database (like database reports, dashboards, folders etc) and such permissions are set in the view level, logical level or data level.

2.Data level Security:

The Data level security level is about restrictions that are concerned about the different data that are used to generate the report of other view level information.

The Data level security mostly set in the database level and related logic table level.

18.What are different types of variables in OBIEE?

Answer :

There are following types of variables used in OBIEE:

1.Session variable

2.Repository variable

3.Presentation variables.

Repository variable : This variable is used for the whole repository.

Session variable : session variable are of two types: system variable and non system variable.
System variable uses NQ_SESSION. Examples of non system variables are user defined filters.

19.What are different caching techniques in OBIEE?

Answer :