Create date range filters
Date range filters enable you to show only
data that meets the conditions of the filter in a report. For example, you can create
filters to display data between 2010 and 2013, or all data after 2010. After you have
applied your filter, the Analyzer report
shows only data specified by the date ranges that you selected.
Perform the following steps to create date range filters:
Procedure
Log in to the User Console, then open an existing analysis report that contains a time dimension or choose
.For a new report, select the data source that you want to use and click OK.
Create the report with a time dimension, such as year or quarter.
Click the icon to Add A Filter, then drag the time dimension that you want to filter on to the Filters board.
You can also right-click on the dimension and add it as a filter.Choose one of these options to create your filter:
- Choose a commonly used time period: Use this option to specify a time period. In this Filter on Quarters example, you
have your time period specified. Click OK to apply the filter. This filter is dynamic and changes with the current date. The other date filters are
static.NoteThe Choose a commonly used time period and the Between, After, Before filters are available only if time dimension levels are set up with the 'AnalyzerDateFormat' annotation. For more information, see Adapt Mondrian Schemas to Work with Pentaho Analyzer.
- Select from a list: Use this option to select values
from a list. You can use the single Right and Left Arrows to add or subtract
one value at a time, or use the Double Right and Double Left Arrows to add
or subtract all of the values in the list. Select OK
to apply the filter to your report.
- Select a range: If you select this option, click
the Select from date picker link to use the date
picker calendars to select beginning and ending dates for your report data.
Click Apply, then OK, to apply
the filter to your report.
- Choose a commonly used time period: Use this option to specify a time period. In this Filter on Quarters example, you
have your time period specified. Click OK to apply the filter. This filter is dynamic and changes with the current date. The other date filters are
static.
Results
Once you select a date, the data is validated to make sure that your date ranges actually contain that date. Analyzer searches for the nearest time period, up to plus or minus 30 time periods, if no date is found the first time. You will not be able to save the date filter if no
dates are found.
NoteWhen you create a date range filter using the 'Between (and incl.)' operator and parameterize it, as described in Add Query Parameters in Analyzer Reports,
you specify one parameter name, but two parameters are created. One parameter controls the start of the range, and another controls the end of the range. The start date parameter is
<YourParameterName>_START, and the end date parameter is <YourParameterName>_END.