Microsoft SQL Server 2012

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

Download file

Others related eBooks about Microsoft SQL Server 2012