Packt+ | Advance your knowledge in tech

You're reading from Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Get to grips with Microsoft Business Intelligence and Data Warehousing technologies using this practical guide

Product type Paperback

Published in May 2014

Publisher

ISBN-13 9781849688888

Length 350 pages

Edition 1st Edition

Tools

SQL Server

Concepts

Business Intelligence

Authors (2):

Abolfazl Radgoudarzi

Reza Rad

View More author details

Table of Contents (14) Chapters

Preface

1. Data Warehouse Design FREE CHAPTER

2. SQL Server Analysis Services Multidimensional Cube Development

3. Tabular Model Development of SQL Server Analysis Services

4. ETL with Integration Services

5. Master Data Management

6. Data Quality and Data Cleansing

7. Data Mining – Descriptive Models in SSAS

8. Identifying Data Patterns – Predictive Models in SSAS

9. Reporting Services

10. Dashboard Design

11. Power BI

12. Integrating Reports in Applications

Index

Time for action – adding a Fact relationship

As a business requirement, you need to add the order line number as a dimension attribute and show it in the browser. As you know, in the current cube, we have an Internet Sales measure group, which has some measures such as order quantity and sales amount, but we need to fetch the order line number from FactInternetSales as a dimension attribute (this is degenerate dimension, which is explained clearly in Chapter 1, Data Warehouse Design).

Perform the following steps to add a Fact relationship:

Open the Data Source View designer and explore data in the FactInternetSales table. You will see that there is a SalesOrderNumber and SalesOrderLineNumber column there. In this exercise, we will create a dimension based on these columns.
Add a Named Calculation in the FactInternetSales table and name it Order Number. Write the following expression to calculate the concatenation of the order line and order number:
```
'Order Number: '+SalesOrderNumber+', Order...
```

The rest of the chapter is locked

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Abolfazl Radgoudarzi

See other products by Abolfazl Radgoudarzi

Reza Rad

Reza Rad has more than 10 years of experience in databases and soft ware applications. Most of his work experience is in data warehousing and business intelligence. He has worked with Microsoft technologies from SQL Server 7 and Visual Basic 6 to the latest versions of SQL Server and .NET. He has a Bachelor's degree in Computer Engineering. Reza is a DW/BI architect and consultant. He has worked with large enterprises around the world and delivered high-quality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics, Sales, Order Management, Manufacturing, Telecommunication, and so on.Reza has been awarded the Microsoft Most Valuable Professional in SQL Server from 2011 to 2014. He is an international speaker in SQL Server, BI, and DW conferences around the world. He speaks in SQL PASS Summits, Microsoft TechEd, SQL Saturdays, SQL Server user groups, and code camps.Reza has written books on SQL Server and databases. One of his most recent books is SQL Server 2012 Integration Services: An Expert Cookbook, Packt Publishing.Reza is a big fan of data-related technologies, his expertise is in EIM, ETL, Data governance, big data, data warehousing, BI, data visualizati on, Master Data Management, OLAP, and so on. He is the author of Webcast series on the RADACAD website (http://www.radacad.com). He writes articles and blog posts on his technical blog (http://www.rad.pasfu.com); he writes about most of the Microsoft technologies, such as SSIS, MDS, DQS, SSAS, Power BI, HDInsight, and so on. His blog contains the latest information on his presentations and publications.Reza is a Mentor and a Microsoft Certified Trainer. He has been in the professional training business for many years. He conducts extensive 400 handed-level training for many enterprises around the world via both remote and in-person training. He is an active member of MSDN forums, especially those on SQL Server and Power BI. He is also the leader of the New Zealand Data Warehousing and Business Intelligence user group, which is a registered chapter of PASS.

See other products by Reza Rad