Defining Analysis Services Dimensions - SQL Server Analysis Services 2012 Cube Development - page 33

4. Right-click on the blank area in the DSV and choose New Named Query ;
this opens the Create Named Query dialog. You have an option to either
use a generic query builder, which simply accepts SQL statements, or the
Visual Data Tools ( VDT ) query builder, which allows you to pick and choose
columns you wish to include in the query.
5. Switch to the generic query builder, enter the following query, and click on the
run button as shown in the next screenshot:
SELECT
DimProduct.ProductKey,DimProduct.ProductAlternateKey,DimProduct.ProductSubcategoryKey,DimProduct.WeightUnitMeasureCode,
DimProduct.SizeUnitMeasureCode,DimProduct.EnglishProductName,
DimProduct.StandardCost,
DimProduct.FinishedGoodsFlag,
DimProduct.Color,DimProduct.SafetyStockLevel,
DimProduct.ReorderPoint,DimProduct.ListPrice,DimProduct.[Size],DimProduct.SizeRange,DimProduct.Weight,DimProduct.DaysToManufacture,
DimProduct.ProductLine,DimProduct.DealerPrice,
DimProduct.Class,DimProduct.Style,DimProduct.ModelName,
DimProduct.EnglishDescription,DimProduct.StartDate,
DimProduct.EndDate,DimProduct.Status,
DimProductSubcategory.EnglishProductSubcategoryName
FROMDimProductINNERJOIN
DimProductSubcategoryONDimProduct.ProductSubcategoryKey=DimProductSubcategory.ProductSubcategoryKey