pg电子游戏网站试玩平台

書名： Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
作者名： Reza Rad
本章字?jǐn)?shù)： 243字
更新時(shí)間： 2021-08-13 17:55:23

Time for action – using a Named Query

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.

What just happened?

In this example, we used a Named Query and a query designer to write customized queries on the database. The query language used is T-SQL because the underlying database is SQL Server. However, it can be different based on the database.

You can also create logical keys for Named Queries or views. You can also create relationships between tables, views, and Named Queries in the DSV. These features in the DSV will provide the ability to develop a powerful base for the cube.

官术网_书友最值得收藏!

Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide

Time for action – using a Named Query

What just happened?