What is the use of filters in OBIEE?

1.	What is the use of filters in OBIEE?
Answer» Filters are used to limit the results that are displayed when an analysis is run, so that the results answer a particular question. Based on the filters, only those results are shown that matches the criteria passed in the filter condition. Filters are applied directly to attribute columns and measure columns. Filters are applied before the query is aggregated and affect the query and thus the resulting values for measures. Example − Suppose you have a list of members in which the aggregate sums to 100. Over the time, more members meet the set filter criteria, which increases the aggregate sum to 200.

Answer»

Filters are used to limit the results that are displayed when an analysis is run, so that the results answer a particular question. Based on the filters, only those results are shown that matches the criteria passed in the filter condition.

Filters are applied directly to attribute columns and measure columns. Filters are applied before the query is aggregated and affect the query and thus the resulting values for measures.

Example − Suppose you have a list of members in which the aggregate sums to 100. Over the time, more members meet the set filter criteria, which increases the aggregate sum to 200.

Discussion

No Comment Found

Related InterviewSolutions

What are the different ways of assigning permissions to OBIEE repository?
Is it possible to create outer join in Physical layer?
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer?
What is the difference between OBIEE 10g and OBIEE 11g administration?
What are different Application roles in BI system?
What is OBIEE Security? How do you define a Security policy in OBIEE system?
What do you understand by Data Level Security and Object Level Security?
What do you understand by connection pool and how many connection pools did you have in your last project?
What is the use of Column Prompts? Where they are used?
What are Inline prompts?