Filters Query and Web Template

[Former Member]

Dear All,

Many reports use filters in both the query and the web template. What

is the difference?

Regards,

KS

[Former Member]

the filter used in query and web templates are same

there is no difference between filters used.

as webtemplate uses the same query as its data provider so it is going to run the same filters.

for e.g. if u have query x then if there are filters in it .

if u have webtemplate y , and u have to assign a data provider to webtemplate which is nothing but query itself....

so if u run webtemplate u will at the end execute query x only...

now wat is filter.

filter means it will filter out that data.

for e.g. if u created a variable for calendar month and u restrict it so that user can enter the calendar month value range when they execute query x....

then if u execute query x

then upon its execution the variable will pop u p and it will ask u to enter range of calendar months

lets say u enter 1/2007-12/2007

so u r query executes and it will only bring data for year 2007.

now if u wish to see the data of 2006 and try to restrict it in Context menu or Restric screen, then it will display as NO DATA.

this means it will filter the data for particular year.

so if u wish to see the data for all years

then dont create variable and dont restrict Calendar month

Instead bring calendar month in Free characteristics

so later u can run the query for different years.

i hope u understand

[Former Member]

Hi Kanagaraj

In the query you can define a Default Value (filter) or a Characteristic Restriction, a Default Value is a restriction on the characteristic that can be changed by the user during runtime of the query. A Characteristic Restriction is a hard restriction on the data that can only be changed in the query designer, this type of filter is used for restricting characteristics to values that are unlikly to change ie Fiscal Variant, it is also useful for limiting the users selection ability, ie a user can only filter the characteristics values that are included in the Characteristic Restriction if one is used.

The web template gives the query functionality and format, running a query from the query designer is still using the default web template, the template provides filter functionality through the filter link and the context menu.

Hope this helps

Josh

[Former Member]

Hi

Filters are as per ur Client's requirement..Nothing much difference in it.

Hope this solve ur query

Cheers

BI Learner