Sometimes, you need to write queries instead of bringing tables and views as is from the database (assume that we don't have access to the underlying database in order to create views or change the structure of tables there). Named Query is a query that runs on the database and its result will be shown as a table in DSV. In this example, we will use a Named Query to bring the product category and subcategory along with the product table columns, by performing the following steps:
In the Data Source View designer, right-click on the DimProduct table and under Replace Table, choose With New Named Query.
In the Create Named Query window, add the ProductCategory and ProductSubCategory tables, and the designer will write joined statements itself.
After that step, choose EnglishProductCategoryName and EnglishProductSubcategoryName from the columns list.
Explore data of the DimProduct Named Query and review the result.