Working With Filters

Working With Filters:

1. What is a filter?

A) Filter is useful to restrict the data in OBIEE.

a. It is equal to where and having clauses of SQL.

2. In how many ways we can develop filters and what are those?

A) We can develop filters in 11 ways:

1. Creating Filter Using Criteria Column,

2. Creating Filter Using Subject Area Column,

3. Creating Filter Using Saved Filter in a Report,

4. Creating Filter Using One Report  output AS Filter in Another Filter,

5. Creating Filter Using Variables,

6. Creating Filter Using Sql Expression,

7. Creating Filter Using Group Filters,

8. Creating Filter Using Add a Column Prompt to a Request,

9. Creating Filter Using Image Filter Prompt,

10. Creating Filter Using Variable Prompt

11.Global Filter Or RPD LTS Filter.

3. How can we create filter using criteria column?

A) By clicking on required column which is for producing result, Go Filter Option & Assigned a Value.

4. How can we create filter using subject area column?

A) By clicking on filter button in filter pane.

5. How can we use a saved filter in a report?

A) By clicking on filter option  from new button.

a. By going on to saved filter which is present below subject area (Bottom of Catalog).

6. How can we use one report output as filter in another report?

A) By saving a report as filter we can utilize the same report as filter in another report by clicking on option based on result of another analysis which is present  in respective column filter.

7. How can we create filter using variables?

A)  By creating a variable filter present in manage menu of RPD

a. By using the defined variable in the respective column filter option which is in add more options repository variables.

8. How can we create a filter using SQL expression?

A) It is equivalent to Database Sub Query concept

a. By clicking on respective column filter and add more options into sql expression.

9. What is advanced SQL filter?

A) It is useful to customize  where clause of SQL expression.

10. How to create a filter using group filters?

A) Using group filter we can define more than one condition in  a report.

a. Develop 3 filters and observe that AND Or OR operators assigned .

b. We can change AND to OR and vice versa by clicking on either AND or OR operators.

11. What is a column prompt filter?

A) The filter which is a user friendly filter or run time filter or dynamic filter called as prompt.

a. The prompt which is applied at the level of column is called column prompt.

b. By clicking on prompt tab just after the result tab we can go for column prompt.

12. Can we create ‘n’ no of prompts for ‘n’ no of columns?

A) Yes, we can create ‘n’ no of prompts for ‘n’ no of columns.

13.Does OBIEE provides options to check the functionality of our prompts?

A) Yes,OBIEE provides the facility to check the functionality of prompts.

14. What are the options present in OBIEE to check the prompts?

A) Options in prompts are:

1. Limited Values

2. Include All Column Values

3. Enable User to Select Multiple Values,

4. Enable User to Type Values

5. Required User Input

6. Default Selection

15. What is image filter prompt?

A) When ever we are running the report, image will be displayed.

If we click on any part of the image then corresponding data will be displayed.

16. What is a variable filter prompt?

A) It is used to capture USERS response . In this prompt we will use presentation or request variables.

For Example we can make title of the report dynamic.

17. What is a global filter or RPD LTS filter?

A) The filter which is applied on LTS of RPD is known as Global filter or RPD LTS filter.

a. Normally it is used to filter unwanted data from BI application.