OLAPQuery Member and Level Rules

If you include both members and levels together in a query, a union of the two data sets occurs, and not an intersection. For example, if you select a State level and select San Francisco (which is a city), your query retrieves all states and San Francisco.

The following able shows the results of different queries.

Table 41. OLAPQuery Member and Level Rules

Data Layout item(s)	Component Type	Query returns:
Country (All)	Level	All countries
State (All)	Level	All states regardless of country
City (All)	Level	All cities regardless of state or country
Canada	Member	Canada only
CA	Member	California only
San Francisco	Member	San Francisco only
State (All), San Francisco	Level, Member	All States regardless of country and San Francisco
Country (All), CA	Level, Member	All Countries and California (not just the USA)
Country (All), State (All), CA, NV, San Francisco	Level, Level, Member, Member, Member	All Countries, All States