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
Size : 1,970.38 Kb
File type : pdf
Downloads: 639
Created: 2015-12-30

Others sql Tutorials

PostgreSQL Shell Commands free PDF

SQL Server Concurrency

Protecting SQL Server Data

MySQL tutorial for professionals

A Primer on SQL, 3rd Edition

Others related eBooks about Microsoft SQL Server 2012

Database Design

Download free course Database Design, pdf file on 153 pages by Adrienne Watt....

Graph Databases

Download free course Graph Databases, pdf file on 238 pages by Ian Robinson, Jim Webber, Emil Eifrem....

Introduction to SQL

This tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....

Tutorial Oracle Database 11g: SQL Fundamentals in PDF

Download tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....

Protecting SQL Server Data

Download free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....

PostgreSQL tutorial

Download free PostgreSQL tutorial course in PDF, training file in 29 chapters and 93 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web Applications

Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. ...

Learning Microsoft SQL Server

Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

Graph Databases For Beginners

Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....

SQL Notes for Professionals

SQL is a standard language for storing, manipulating and retrieving data in relational databases....