Custom Subquery Filters

<filterPart>
    <subQueryFilter operator="string" correlationType="None|Any|All">
        <filterObjects>
            <filterObject id="string" path="string"/>
        <queryData>
            <resultObjects>
                <resultObject>
            <sortObjects>
                <sortObject>
            <filterPart>

See the SAP BusinessObjects Web Intelligence User's Guide to learn the definition and benefits of subqueries.

Subquery Filter
Attribute Type or Value Description
operator string The operator
correctionType None|Any|All The correlation type
Operator operator Attribute Value Number of Operands Correlation Supported
Equal To (=) EqualTo One object No
Not Equal To (<>) NotEqualTo One object Yes
Less Than (<) LessThan One object Yes
Greater Than (>) GreaterThan One object Yes
Less Than or Equal To (<=) LessThanOrEqualTo One object Yes
Greater Than or Equal to (>=) GreaterThanOrEqualTo One object Yes
In InList List No
Not In NotInList List No
Filter Object
Attribute Type or Value Description
id string The object identifier used as filter
path string The full path of the object in the universe

Example

The following snippet of a query specification shows a subquery filter with no correlation.

<query xmlns="http://www.sap.com/rws/sl/universe" id="5897899822041415615" dataSourceType="unx" dataSourceId="5808">
    <querySpecification version="1.0">
        <queryOptions>
        ...
  	 </queryOptions>
  	 <queryData>
            <resultObjects>
                <resultObject path="Time|folder\Calendar|folder\Calendar Year|dimension" id="_IBo8FLIhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Customer|folder\Geography|folder\Continent|dimension" id="_IBo8M7IhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Customer|folder\Geography|folder\Country|dimension" id="_IBo8NrIhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Sales Revenue|folder\Net Sales|measure" id="_IB8eRLIhEeCk0Ylv-tlF2Q"/>
            </resultObjects>
            <filterPart>
                <subQueryFilter operator="EqualTo" correlationType="Any">
                    <filterObjects>
                        <filterObject path="Customer|folder\Geography|folder\Continent|dimension"
                            id="_IBo8M7IhEeCk0Ylv-tlF2Q"/>
                        <filterObject path="Customer|folder\Geography|folder\Country|dimension"
                            id="_IBo8NrIhEeCk0Ylv-tlF2Q"/>
                    </filterObjects>
                    <queryData>
                        <resultObjects>
                            <resultObject path="Customer|folder\Geography|folder\Continent|dimension" 
                                id="_IBo8M7IhEeCk0Ylv-tlF2Q"/>
                            <resultObject path="Customer|folder\Geography|folder\Country|dimension"
                                id="_IBo8NrIhEeCk0Ylv-tlF2Q"/>
                        </resultObjects>
                        <filterPart>
                            <comparisonFilter operator="GreaterThan" path="Sales Revenue|folder\Net Sales|measure"
                                id="_IB8eRLIhEeCk0Ylv-tlF2Q">
                                <constantOperand>
                                    <answerValue dataType="Numeric">300000000</answerValue>
                                </constantOperand>
                            </comparisonFilter>
                        </filterPart>
                    </queryData>
                </subQueryFilter>
            </filterPart>
        </queryData>
    </querySpecification>
</query>