Compound dimension search extends the functionality of default dimension search by returning not single dimension values, but combinations of dimension values called navigation references.
A navigation reference is essentially a navigation query waiting to happen.
To start a compound dimension search, you provide the search terms. After the terms are provided, the following happens:
The MDEX Engine looks at each term individually, and searches for any dimension values that match the term. The result of this process is a list of dimension values.
The MDEX Engine combines the dimension values it found in Step 1 into navigation references, and tests the validity of those references.
A navigation reference is valid if executing a query with it returns at least one record. In the example above, two navigation references are valid:
Red Hill + 1996 Red River + 1996
The MDEX Engine continues evaluating navigation references until it has assessed all possible combinations.
The MDEX Engine returns any valid navigation references it has found in Step 2.