Skip to Content
author's profile photo Former Member
Former Member

Filters Query and Web Template

Dear All,

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

is the difference?

Regards,

KS

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 08:12 AM

    Hi

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

    Hope this solve ur query

    Cheers

    BI Learner

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 08:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 09:12 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.