Here is some information about filtering and
ranking tables, graphs, and geographical maps:
Working with formatted and unformatted values
If you are filtering on unformatted values, then you must enter values that match
the casing of the values in the
data source. If you select the
Filter
on formatted values option, then you must enter the formatted values. If the
filter does not return any results, then try using a different casing. Note that you can
select the
Ignore
case check box if you are working with relational data.
How time periods are counted
When filtering dates,
times, and timestamps in tables and graphs, you can specify time periods
such as days, weeks, months, and years. When SAS Web Report Studio
counts by these time periods, it treats each period as a unit and
begins counting from the beginning of the specified period type in
which the current date falls. For example, if you use Months as
the period type, SAS Web Report Studio counts the specified number
of whole months from the current month, regardless of where the current
date falls within the current month.
Here are two examples that illustrate how time periods are counted in this type of
filter:
-
Today is December 20, 2009, and
you want to filter a table so that it includes sales that were posted
before three months ago. If you use Months as
the period type, the table includes data from sales that were posted
before September 1, 2009. SAS Web Report Studio counts back three
whole months from the current month and returns data before the first
day of that month. To filter the table so that it includes sales that
were posted 90 days before December 20, 2009 use Days as
the period type. If you specify 90 days, the table includes sales
that were posted before September 21, 2009.
-
Today is December 20, 2009, and you want to filter a graph so that it includes employees
who were born more than 10 years ago. If you
use Years as
the period type, the graph includes employees who were born before
January 1, 1999. SAS Web Report Studio counts back 10 whole years
from the current year and returns data before the first day of that
year. To filter the graph so that it includes employees who were born
3,650 days (365 * 10) before December 20, 2009, use Days as
the period type. If you specify 3,650 days, the graph includes employees
who were born before December 23, 1999.
What time is used for time and date filters
When you create time or date filters, the filter is relative to the time that the
section
query is generated, not to the time that the filter is imposed on the table or graph.
When filters and rankings are applied
When filtering a table or graph based on relational data,
measure filters are applied after
category filters. This behavior is explained in the
Filter
and Rank dialog box, which contains the following text:
The
measure filter will be applied after any category filters.However, when filtering a table or graph based on multidimensional data, measure filters
are applied to the values of the underlying
cube instead of to the values that are visible in the table or graph. For this reason,
you might see values in the table or graph that you would not see whether the measure
filter had been applied based on visible category filters.
Restrictions on filtering and ranking
You cannot create filters
that use categories and hierarchies that are assigned to group breaks.
You cannot filter data items that are defined as hyperlinks in an
information map.
You cannot filter on percent of total values.
You cannot create a percentage ranking for relational data.
For scatter plots or bubble plots, you cannot create a measure filter or ranking if
there is no category or
hierarchy assigned to the optional marker group function.
When you can select category values
For data items in relational
data sources, the availability of the Get Values button
is controlled by your data administrator.
Consequences of changing data assignments in a crosstabulation
table
If you add or hide a category or hierarchy column, then any row filters and rankings
that are based on a column measure are removed. Filters are not affected by adding
or hiding measures.
If you add or hide a category or hierarchy row, then any column filters and rankings
that are based on a row measure are removed. Filters are not affected by adding or
hiding measures.
Filters are retained
if you move all the data items that are currently on rows to the columns
and all the data items that are currently on the columns to the rows.
In this case, any existing filters remain and are evaluated based
on the new positions.
Consequences of turning percent of totals off
If a table contains
percent of totals for rows that are based on row subtotal values,
then those percent of totals are removed when you turn off subtotals
for the table.
If a table contains
percent of totals for rows that are based on row total values, then
those percent of totals are removed when you turn off subtotals for
the table.
If a table contains
percent of totals for columns that are based on column subtotal values,
then those percent of totals are removed when you turn off subtotals
for the table.
If a table contains
percent of totals for columns that are based on column total values,
then those percent of totals are removed when you turn off subtotals
for the table.
The basis for ranking is different between section filters
and report object filters
When you use a section filter, the rank is based on only the filtered data. However,
when you use a report object
filter, then the rank is based on all of the data.