When the connection has been configured to load values on request, the hierarchy filter will query the cube for the currently shown values only, and a new query is sent to the cube each time a new category is expanded.

When hierarchies are loaded on request, the filter cannot display the search field that is otherwise available. You may also see progress indications for each category you expand, as new values are fetched from the external source.

Hierarchy filters from external cube sources will include an (All) check box and the setting that indicates that a category is only partially selected will be turned on by default. These settings can be switched off in the Filtering Scheme Properties dialog.