| Table of Contents | |
|---|---|
|
|
| Excerpt |
|---|
|
- 选择尺寸的报头中的交叉标签来过滤
- 在分析带状工具栏，选择“过滤器”
- 选择“滤镜会员......”
- 作出选择并单击确定
会员在过滤交叉表
- 过滤的成员的值 。
- 拖放的价值：
- 在维度页眉或在设计面板行或列筛选该值
- 这个值
会员筛选数据通过右键点击
| |
You can insert a filter component to your analysis to simplify the filtering. This helps you to quickly change the view of the displayed data, for example to different periods of time. |
Filter data by Member
via the Toolbar
- Select a cell in the crosstab that belongs to the dimension you want to use for filtering.
- In the Analysis ribbon toolbar, select the "Filter"
- Select "Filter By Member..."
- The Filter by Member dialog box appears.
- Make the selection and click OK
via right click
From the crosstab
Select one cell for each member that you want to filter for. To select multiple members, hold down the Ctrl or Shift key as you select members. Right click on the cells.
The context menu box appears
- Choose Filter Members to exclude data according to your selection
- Choose Filter Other Members in the context menu to filter out the selected members
- Choose Filter By Members to make a selection
From the design panel
Right click on the dimension in the design panel and select Filter By Member
Filter data via Background Filter
You select members for filtering that should not be displayed in the crosstab. These non-visible filters are background filters.
You can add the dimension using drag and drop or you can choose Move to Background Filter in the context menu.
Filtering Individual selections or range selections
- You can select "Filter By Member..." for individual selections. In this case you can select/unselect individually each value
- or you can select "Filter By Range..." to filter a range of data.
Remove a Filter
Solution 1: Select the dimension header, right click and Select All Members
Solution 2: In the Analysis Tab, select the dimension, right click and Select All Members.
Filter by Measure
You can define rules to filter the data of your analysis to your current scope of interest. You can apply one or multiple rules to a measure.
- Select the Dimension.
- Click the « Filter » button and select « Filter by Measure ».
- Select the measure,
- Set your filter,
- You can Add multiple filter
- Press OK .
| Note |
|---|
If you choose a Dimension instead of a measure before filtering by measure, the filter is applied directly on the level of the selected dimension |
The following options define on witch level the filter is applied :
- All Dimensions Independently
If you select this option, the filter is applied to all dimensions in the analysis, from the outermost to the most detailed one. For example, in an analysis with three dimensions in columns A, B and C, the filter is first applied to the dimension in column A, then to the dimension in column B and finally to the dimension in column C.
- Most Detailed Dimension in Rows
If you select this option, the filter is applied to the most detailed dimension of the rows. For example, in an analysis with three dimensions in columns A, B and C, the filter is applied to the dimension in column C. This option is optimized for threshold value filtering.
- Most Detailed Dimension in Columns
If you select this option, the filter is applied to the most detailed dimension of the columns. For example, in an analysis with three dimensions in rows 2, 3and 4, the filter is applied to the dimension in row 4. As with the option above, this option is also recommended for threshold value filtering.
Remove a filter by Measure
Solution 1: Select the dimension, right click and Select Filter by Measure, select « Reset »
Solution 2: Select the dimension, Filter and Filter by Measure, then select « Reset »
Filter out Zeros in Rows or Columns
In some cases, the BW report will still display a row or column even if all the values are equal to 0. This is usually the case when the "0" is the result of a sum of positive and negative numbers.
You can choose to remove those columns/rows via the "Suppress Zeros in Rows" and "Suppress Zeros in Columns" options in the Filter menu.
从交叉表：
- 右键点击一个维度
- 选择«过滤方式会员»
从设计面板：
通过背景过滤器过滤器数据
背景过滤器过滤允许在不在交叉表维度
- 在设计面板中选择一个维度，右键单击并选择«添加到过滤器»
- 让您的选择，然后按OK
过滤个人选择或选择范围
您可以通过个人的选择过滤。在这种情况下，您可以选择/取消选择单独的每个值：
您可以通过“范围选择” ：
拆卸过滤器
解决方法 1：选择维标题，点击鼠标右键，选择所有成员
解决方法 2：在分析选项卡中，选择维，右键单击并选择所有成员。
通过测量滤波器
- 选择尺寸。
- 点击«筛选»按钮，然后选择«过滤器的测量»。
- 选择测量，设置过滤器，你可以添加多个过滤器，然后按确定。
| Note |
|---|
如果通过过滤措施之前，选择一个维度，而不是一个措施，过滤器上选定维的水平直接应用 |
下列选项对巫级别定义应用过滤器：
- 所有尺寸Independantly
如果选择此选项，过滤器被应用到分析中的所有维度，从最外层到最详细的。例如，在与在列A，B和C三个维度的分析，该过滤器被首先应用到尺寸在列A，然后在列B中的尺寸，最后到在列C的维
- 最详细的维度行
- 最详细的尺寸在列
删除一个过滤器测量
解决方法 1：选择维，单击右键，选择过滤器的测量，选择«复位»
解决方法 2：选择维，过滤器和过滤措施通过，然后选择«复位»
使用的的BEx筛选条件
条件是特殊的预定义（在查询生成）动态过滤器，可以激活或关闭报告。
如果该报告存在的条件下，你可以点击“过滤器”菜单，然后进入“的BEx条件”，并选择一个从列表中。
过滤掉零的行或列
在一些情况下，BW报告将仍显示一个行或列，即使所有的值都等于0，这是通常的情况下，当“0”是正数和负数的总和的结果。
您可以选择通过“消零行中的”和“禁止在零列”在滤镜菜单选项删除那些列/行。
