What are the different types of Filters available in BUSINESS OBJECTS?

Showing Answers 1 - 69 of 69 Answers

cherub

  • Nov 7th, 2007
 

hi all,

We can apply 4 types of filters to data providers when you build data providers using the Java Report Panel:

1.Predefined Filters

2.Custom Filters

3.Prompts Filters

4.Advanced filters

We can combine all 4 types of filters on a single query

Thanks
Cher

  Was this answer useful?  Yes

avbaby

  • Jan 4th, 2008
 

there are 4 types filters in BO:
predefined filters : these filters are created at the time of universe creation and can be directly used at a report level.

custom filters: these are the filters which are created at the report level. there are two ways of creating report level filters. one is before running a query... second one is after running a query.

prompt firters: these are the dynamic filters which askes the user for the values and depending upon these values, filters are applied.

advanced filters: advanced filters consists of ways of restricting data view using clauses like 'ranking'. for example, applying ranking for top 10 rows.. it will return only top 10 rows.

  Was this answer useful?  Yes

Designer: When you make object we restrict data in object properties through condition/filter...

Web Intelligent: Same Condition which we were use in Designer its make in web Intelligent  Predefine filters to restrict our data. also,
REPORT LEVEL:  We also have a report level filter on run time.
Custom Filter : These filter we can create like variable(global filter) and condition(current report filter). 

  Was this answer useful?  Yes

kishore

  • Oct 17th, 2011
 

In Business Objects have two types of Filters
1.Query level Filters
2.Report level Filters

a) Query level Filters are reusable.This type of Filters Created in Universe Design level.
b) Report level Filters are two types
1.Global level Filter.
2.Block level Filter.
Global level filters applying in overall report.
Block level filters applying in only one block level

EX: I have one report in report 3 Blocks is there 1. Cross tab,2. Pie Chart,3. H-table.in this Report we will applying Filter reflect overall data in Report this type of filters called Global Filter

we applying only particulate Block (ex:Pie-Chart) only Data Reflect particular Block this type of Filter called Block level Filter.

  Was this answer useful?  Yes

Reddygaris

  • Sep 14th, 2012
 

There are four types of filters
1. Predefined Filters: Are created in the universe
2. Custom Filters : filters which are defined by the user on the query
3. Prompts : Dynamic filters, which display a question every time you refresh a document.
4. Advanced Filters : subqueries and ranking

  Was this answer useful?  Yes

vyankatesh valakate

  • Oct 19th, 2012
 

There are two types of filters in Business Objects:
1. Local Filter
2. Global Filter

  Was this answer useful?  Yes

shashank

  • Nov 23rd, 2012
 

There are 1) Predefined
2) Local
3) Global

  Was this answer useful?  Yes

Shrikant

  • Jan 24th, 2013
 

There are three types of filters:
1) Predefined
2) db Level
3) Report Level (Global / Local)

  Was this answer useful?  Yes

Deepa

  • Feb 22nd, 2013
 

Query filters
Report filters

  Was this answer useful?  Yes

hindumathi

  • Mar 6th, 2013
 

we have three kind of filters;
1.universe level filter
2.query level filter
3.report level filter

  Was this answer useful?  Yes

Arjun

  • Aug 22nd, 2013
 

There is Two filters.

Global (UNIVERSE) Filter -> here we can set the filter this filter effects complete report and automatically applied.

Local(REPORT)filter it has again two types edit report level, and after generate the report there we can add input control filters.

  Was this answer useful?  Yes

nandani

  • Sep 27th, 2013
 

report filter
advanced filter
predefined filter

  Was this answer useful?  Yes

vivek kumar

  • Oct 17th, 2013
 

Below are the types of filters in BO
1) Pre Defined filter
2) Custom Filter
3) Quick Filter
4) Combined query Filter
5) Filters with Prompts

  Was this answer useful?  Yes

Bharat

  • Dec 26th, 2013
 

FILTER(s)

• It is for restricting the DATA

In BO we have 3 kinds of filters

1. Global Condition [Universe Level Filter]
2. Query level filter
3. Report level filter

Global Condition:

• It is a filter created on the Universe level for reusing all the reports executing
on particular universe


Query Level Filter:

• It is for restricting the data for desired report while executing on the database.
• This filter is also called as a local filter some times.

In BO we have 2 kinds of query level filters: 1. Static filter 2. Dynamic filter

1. Static filter:

• If the filter is static the report always run for constant values

2. Dynamic filter or Prompt:

• It is for creating a dynamic report
• If the filter is dynamic, the end user can pass the values for the filter on
run time and they can see the data as per the prompt values submitted


Report level filter:

• It is for hiding the data in report level

In BO we have 2 kinds of report level filters.

1. Block level filter

• Its applicable for desired block in the report


2. Global filter (report level) [where as Global condition is universe level]

• Its applicable for all the blocks there in the report

  Was this answer useful?  Yes

purvanshu

  • Jan 26th, 2014
 

In BusinessObjects there are 2 types of filters :-

1.) Local Filter - Local Filter would apply to just a single block (table,cross table,chart) with in a report. Local filter effect only single block.

2.) Global Filter - Global Filter would apply to all blocks in report, so if we had many table the filter would apply to all of them. Global filter effect whole report.

  Was this answer useful?  Yes

S.Arun rao

  • Apr 21st, 2014
 

There are 3 types of filters in BO they are:

1)Global level filter : Filter is applied at universe level.
2)Query level filter : Filter is applied at the time of creating a query in webI reports.
3)Report level filter : Filters applied on report..filter can be block level or report level

  Was this answer useful?  Yes

Riaz Sultana

  • Apr 30th, 2014
 

There are 2 types of filters in BO.

1. Global: which is at universe level filter

2. Local : This is further divided into 2 types:

(a) Query filter
(b)Report filter


Query filter is further divided into 2 types:

(a) Static filter
(b) Dynamic filter

  Was this answer useful?  Yes

azzar

  • Apr 13th, 2015
 

Simple,Multiple,Complex,Predefined(Function),Prompt .

  Was this answer useful?  Yes

Jose Roy

  • Apr 8th, 2016
 

3 type of filters are there
1) Query filter
2) Report Filter-Two type a) Global Filter b) Block Filter
3) Predefined Filter

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions