Tecflix

Using SQL Server Data Tools-BI Purchase the entire course

26 February 2015 · · 2033 views

SSAS Cube Design Series

SQL Server Data Tools-BI (SSDT-BI, previously called BI Development Studio or BIDS) is the name for the Visual Studio templates used for building SQL Server Analysis Services projects, which are fully introduced in this 40-minute video by Chris Webb, expert on all things SSAS.

SSDT-BI should not be confused with SSDT, which is the Visual Studio experience for building SQL Server relational databases. SSDT-BI is a separate download, available free of charge from Microsoft.

There are two ways of working with SSAS in SSDT-BI: Online mode, where every time you save your project the changes are saved back to the deployed SSAS database, and Project mode where, when you save, those changes are only saved to the project and you have to Deploy your changes to the server separately. Project mode is the safest option, mainly because it allows you to use source control.

There are a number of useful properties you should set on a project when you first create it, such as Deployment Server Edition, the Target Server and Database, and Processing Option.

Once you have created a new project, the first thing you need to do is to create a new Data Source to connect to a relational database. Doing this involves two things: giving SSAS all of the details it needs to generate a connection string, and telling SSAS which credentials to use when it connects back to the relational database. Next, you need to create a Data Source View. A Data Source View (DSV) allows you to choose which tables you want to work with in your SSAS project, and also to tell SSAS about any relationships between those tables. You can also create Calculated Columns (similar to derived columns) and Named Queries (similar to views) in your DSV, although you would be better off doing this work in the relational database itself if that is possible for you.

Finally, on any new SSAS project you should also be using BIDS Helper, a free add-in for Visual Studio that adds a lot of useful functionality for Microsoft BI developers, which you can download from GitHub.

If you are planning to become a cube expert, make sure to watch the remaining videos in our cube design and MDX courses.

Log in or purchase access to play the video.

  • Using the Deployment Wizard 5-min Watch with Free Subscription

  • Using SQL Server Data Tools-BI 40-min

  • Designing Dimensions 1-hour 4-min

  • Cubes, Measures and Measure Groups 1-hour 10-min

  • Cube Security 30-min

  • Cube Deployment, Processing and Admin 36-min

  • Aggregations & Cube Performance 57-min

Purchase a Full Access Subscription

 
Individual Subscription

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
 
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo