In the previous sections, we explained what the Data Source View (DSV) is and how to create DSV. However, sometimes, there is a requirement to change the DSV. For example, you might want to add a calculated column in the DSV with SQL commands and functions, you might want to create a relationship between two views, or you might need to write a query and create a DSV table based on that query. All of these modifications can be done in the DSV, and in this section, we will go through some of them.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By :
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By:
Overview of this book
Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Data Warehouse Design
SQL Server Analysis Services Multidimensional Cube Development
Tabular Model Development of SQL Server Analysis Services
ETL with Integration Services
Master Data Management
Data Quality and Data Cleansing
Data Mining – Descriptive Models in SSAS
Identifying Data Patterns – Predictive Models in SSAS
Reporting Services
Dashboard Design
Power BI
Integrating Reports in Applications
Index
Customer Reviews