Applying filter settings
Filter by
Criteria | Description |
---|---|
Caption and unique name | Filters elements by their unique names or by their captions. Use the text filter to search for texts and strings. |
Attribute | Filters the attributes of the elements defined in the OLAP Server database. |
Value | Filters the values of a range. You must specify the filter settings and the data area
of the filter.
See Defining the Data Area.
Note: Value is available in the axis designer for slice segments but not in the list designer
for slice segments.
See Filters in slice segments. The data area is not applicable to values filters that you create in in the axis designer for slice segments. |
Custom MDX | Creates a filter with an MDX statement. |
Hierarchy
The hierarchy list is available only from the axis designer for slice segments. The list contains the hierarchies that are on the axis.
Filter type
Regular expressions with Analysis Services
To use .NET regular expressions with Analysis Services data sources, you must install an assembly on the Analysis Services server.
The assembly file is called Mis.Reporting.ServerExtension.dll and is installed to C:\Program Files\Infor BI\Application Studio by the Application Studio setup.
Use SQL Management Studio to connect to the Analysis Services database and add an assembly to the Assemblies folder.
The assembly must have these parameters:
- Path: ..\Application Studio\Mis.Reporting.ServerExtension.dll.
- Name: MisOlapYukonExtension
- Permissions: Safe
- Impersonation: Default
Overview of the wildcards
Search string | Explanation |
---|---|
*xyz/xyz* |
The asterisk (*) in front of, or behind, a search string returns the elements that start or end with the search text. |
?xyz |
The question mark represents a missing character. You can use several question marks. |
x?z |
A search request with this string returns all elements containing one character at the position of the question mark. |
.Net regular expressions
To use .NET regular expressions select Regular Expression as the filter type.
Expression | Explanation | Example |
---|---|---|
^ |
Match-beginning-of-line operator |
^A finds list elements starting with an A. |
$ |
Match-end-of-line-Operator |
er$ finds list elements ending in er. |
+ |
Match-one-or-more operator |
e.+r$ finds all list elements ending in r and also containing an e. There must be at least one character between e and r. |
| |
Alternation Operator |
^A|^B finds list elements beginning with A or B. |
( ) |
Grouping |
^(..) finds list elements containing an even number of characters. |
. |
Any character |
^c..d finds list elements beginning with c, followed by two characters, followed by d. |
\ |
Defines the subsequent character as a literal. |
\\ finds all list elements containing the character \. |
Regular expressions are case-insensitive. Prefix an expression with (?-i) to make it case-sensitive. |
Condition
Operator | Description |
---|---|
* | No restriction. No condition is set (default setting). The input box is disabled. |
= | The entered value will be considered. |
>= . | Values greater than the entered value and the value itself will be considered |
<= | Values smaller than the entered value and the value itself will be considered. |
> | Values greater than the entered value will be considered. |
< | Values smaller than the entered value will be considered. |
<> | Values greater and smaller than the entered value will be considered. |
Value
Enter the value that the filter settings refer to. This can be a string or a number.
Filtering element names
Filtering attributes
Open Filter in the List Designer, click
and select Attribute in the Filter Settings section from the Filter By list. Select the filter type, the attribute, the condition and the value.Filtering values
Open the Filter in the List Designer, click
and select Value in the Filter By list. Select the operators and values. Use the Data Area to define the range of data to which to apply the filter.You can use a value filter to exclude zero and null values. A cell that has a null value is empty. A cell with a zero value contains the figure 0. Zero can be used in calculations but null cannot. In no circumstances do ’null’ and ’zero’ have the same meaning.
If data contains both null and zero values:
- A filter which looks for all values equal to null will not return any zero values
- A filter which looks for all values which are not null will return zero (and other) values.