This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples.
It's a free training course under 169 pages for download created by Microsoft.
Table of contents
- Defining a Data Source View within an Analysis Services Project
- Creating an Analysis Services Project
- Defining a Data Source View
- Modifying Default Table Names
- Adding Attributes to Dimensions
- Reviewing Cube and Dimension Properties
- Deploying an Analysis Services Project
- Modifying the Customer Dimension
- Modifying the Product Dimension
- Modifying the Date Dimension
- Defining Advanced Attribute and Dimension Properties
- Automatically Grouping Attribute Members
- Hiding and Disabling Attribute Hierarchies
- Sorting Attribute Members Based on a Secondary Attribute
- Specifying Attribute Relationships Between Attributes in a User-Defined Hierarchy
- Relationships Between Dimensions and Measure Groups
- Referenced Relationship
- Fact Relationship
- Many-to-Many Relationship
- Key Performance Indicators
- Drillthrough Action
- Defining and Browsing Translations
| Size : | 1,970.38 Kb |
| Downloads: | 637 |
| Created: | 2015-12-30 |
Others related eBooks about Microsoft SQL Server 2012
Download SQLite tutorial in PDF format, document created by StackOverFlow intended to beginners.
Download free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com.
Download free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community.
Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry.
This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version.