GeekInterview.com
Series: Subject: Topic:
Question: 9 of 20

Absolute and Standard Filters

How are Absolute and Standard Filters used in different scenarios? How do they differ from one another?
Asked by: Krazy | Member Since Apr-2009 | Asked on: Apr 16th, 2009

View all questions by Krazy

Showing Answers 1 - 2 of 2 Answers
ashu_eureka

Answered On : Jun 11th, 2009

View all answers by ashu_eureka

Absolute and Standard Filters are used in Level Metrics (metrics which calculate at the specified attribute level rather than the default report level).

While defining the level metric, the target attribute at which the metric should calculate is specified along with filtering and grouping options.

The filtering option is a way of specifying how the level metric interacts with the report filter.


This filtering option is classified into 4 types:
a. Absolute
b. Standard
c. Ignore
d. None

Scenario: Consider a report with filter on 2 cities of a state1 and 1 city of another state2 and showing revenue for the states using a level metric. Thus the report will only show data for the 2 cities of state1 and for the 1 city of state2 but at the state level rather than city level as we are using a level metric here.

a. Absolute filtering: If we specify absolute filtering in the level metric definition than the report will show data for all the cities of state1 and state2. This means that even we have a report filter to display data only for 2 cities and 1 city of state1 and state2, this absolute setting will override this report filter in way that the report shows complete data for the two states to which the cities in the filter belong.

b. Standard filtering: In case of standard filtering, the report filter interacts in the usual way with the level metric and shows data only for the elements specified in the report filter.
In the above scenario, the level metric will show data only for the 2 cities and 1 city and not all the cities of state1 and state2.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
Mahipal

Answered On : Oct 19th, 2012

Standard Filter: This type of filtering option let the report filter to be applied to that particular metric.

Absolute Filter: This type of filtering option let the report filter to be applied at the category level, if it has sub-categories on the template.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.