To complete the Smart Query:
From the Smart Query ribbon, select options for the Smart Query as follows:
Indentation (see Member Options)
Show Distinct Member Names (see Member Options)
Suppress Rows with No Data (see Data Options)
Optional: Select Change Alias to select an alias table.
The full names of duplicate members are shown regardless of the selected alias table (if any). All other member names are shown according to the selected alias table.
To save the entire Smart Query definition, from the Smart Query ribbon, select Save.
In Repository, enter a name and description for the Smart Query.
Smart Queries are also saved within the workbook, so when you save a workbook, Smart Queries within it are also saved.
Optional: To perform ad hoc analysis, from the Smart Query ribbon, select Analyze.