If you use a Flex-based Management view, you can use certain Management view components as a filter selection for other components of this Management view. One Management view component acts as the filter source, another as the filter target.
If you are using a table-based Management view component as the filter source, selecting a row in the table uses the combination of individual dimension values from this row as the filter setting for the dependent filter target component.
Example
The screenshot below shows a table-based Management view as the filter source.
Selecting the second table row in the lower Management view component (filter source) sets a dimension filter for the combination of Plant=Oak Springs (3000) and Time=Dec 06 and Material=Machines and Sold-to party=Brazil in the upper component (filter target).
Define interactive filters
You define interactive filters for each Management view component by specifying in the filterMasters parameter of the init method of your Management view component in an array the instantiated Management view component that is going to be the filter source for this Management view component, e.g., [mvFilter].
Combine interactive filters
You can use multiple filter sources if you separate the instantiated Management view components in the filterMasters parameter by a comma, e.g., [mv1, mv2]. Their order determines the priority - the first filter source component listed has the highest priority.
All filters specified for a Management view component are linked by an AND operator. If multiple filter source components contain filters for the same dimension, only the filter in the filter source component with the highest priority will be used.
To avoid empty result sets when setting filters, you should ensure that setting a filter in the filter source component returns data for the filter target component. For example, if you link two Management view components based on different process type groups for filtering, the result set can be empty. It is even possible that errors occur during data retrieval if certain dimensions are not available at all process type groups and process types.
Warning
Make sure that the dependency between the filter target and the filter source does not cause any cyclic dependencies between the Management view components.
Example
In the following example of a Management view structure file, it is specified for the filter target component mv0 (Query1) with [mv1,mv2,mvGblFilter] for the filterMasters parameter, that the component in the MV display will first adopt the dimension filters set in the filter source component mv1 (Query2), then filter settings from the filter source component mv2 (Query3), and finally global filter settings.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"
<html>
<head>
<script language="javascript"
src="../assets/javascript/mvhelper.js">
</script>
<script language="javascript"
src="../assets/javascript/linkhelper.js">
</script>
<script language="JavaScript" type="text/javascript">
initializeFlex();
// MVFilterComponents has to be declared here
//
var mvGblFilter = new MVGlobalFilterComponent();
// MVComponents has to be declared here
//
var mv0 = new MVFlexComponent();
var mv1 = new MVFlexComponent();
var mv2 = new MVFlexComponent();
// MVComponents has to be initialized here, after
// page has been loaded
//
function initMVComponents() {
mvGblFilter.init("mvNodeGlobalFilter");
mv0.init("mvNode0", "Query1", "FAVORITES_PRIVATE",
"FLEX", "100%", "400", [mv1,mv2,mvGblFilter]);
mv1.init("mvNode1", "Query2", "FAVORITES_PRIVATE",
"FLEX", "100%", "400", [mv2]);
mv2.init("mvNode2", "Query3", "FAVORITES_PRIVATE",
"FLEX", "100%", "400");
}
</script>
</head>
<body onload="initMVComponents();">
<div id="mvNodeGlobalFilter" style="position:absolute;
top:0px; z-index:1; width:100%;">
</div>
<div>
<table cellpadding="0" cellspacing="0" rules="none"
frame="void" border="0" bgcolor="#FFFFFF"
width="100%" height="100%">
<tbody>
<tr>
<td id="mvNode0"></td>
<td id="mvNode1"></td>
<td id="mvNode2"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>