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