A named query in SSAS is a SQL expression represented as a table. The user can define a SQL expression in a named query to select rows and columns that are returned from one or more tables.
A named query is like any other table in a data source view with rows and relationships, except that it is based on an expression and extend the relational schema of existing tables in a data source view without modifying the underlying data source.
Named queries can be used in series to split up a complex dimension table into smaller, simpler dimension tables for use in database dimensions.
Use Below steps to create named Queries.
1. Double-click the Bedrooms Named Calculation in the Customers table to open the Named Calculation dialog and copy the SQL text.
2. Right-click in the DSV Designer, and select New Named Query.
3. Enter the query name Homeowners, and optionally enter a description.
4. Click the Add Table button, select the Customers table, and close the Add Table dialog box.
5. Select the * (All Customers) check box on the Customers table.
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2