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
& 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.