Compares field values against names of members in a dimension. When using <dimension-filter>, only non-shadow members of the filter dimension are matched.
Required: A reference to a field in the data file, such as field="${part}", or an expression such as field="${part}:${location}".
Required: Case-sensitive name of the dimension.
Limit the match to members in this hierarchy. The default hierarchy is assumed if hierarchy is not specified. Note that namespace takes precedence over hierarchy and level. (Default=default hierarchy)
Limit the match to members at this hierarchy level. The leaf level is assumed if hierarchy is specified, but level is omitted. Note that namespace takes precedence over hierarchy and level. (Default=leaf level)
Limit the match to members in this namespace. The default namespace is assumed if namespace is not specified. Note that namespace takes precedence over hierarchy and level. (Default=default namespace)
If ismember="true", only records whose field values match member names are let through. If ismember="false", only records whose field values do not match members names are let through. (Default=true)
If nolog="false", records that do not match are logged as errors. If nolog="true", non-matches are not logged as errors. (Default=false)
Following are some examples using <dimension-filter>:
Include only those data records where part matches the names of members in the Part dimension. Non-matching records are logged as errors.
<stage-rowsource rowsource="Parts">
<dimension-filter field="${part number}" dimension="Part"/>
...
</stage-rowsource>Filter for finished goods by letting through only those records where part matches the names of members in the Product dimension at the Finished Goods level. Non-matching records are not logged as errors.
<stage-rowsource rowsource="FinishedGoodsInventory">
<dimension-filter field="${part number}"
<dimension-filter field="${part number}"
nolog="true"/>
level="Finished Goods"
...
</stage-rowsource>