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
Size1,970.38 Kb
File typepdf
Downloads662
Created2015-12-30
Cover of Microsoft SQL Server 2012
Preview PDF

Download

  • How to Install SQL Server 2008

    With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners....

  • MySQL Notes for Professionals

    MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out exampl...

  • Protecting SQL Server Data

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

  • 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. ...

  • SQL queries Tutorial

    Download free SQL tutorial course in PDF, training file in 62 chapters and 166 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

  • Introduction to SQL

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

  • Oracle database tutorials for professionals

    Download free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

  • Quick Guide to SQL Server Management Studio

    This PDF tutorial will teachs you how to install and use SQL Server Management Studio from Home using VPN,it's a free training courses for beginners...

  • Oracle Advanced PL/SQL Developer Professional Guide

    PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....

  • Tutorial Oracle Database 11g: SQL Fundamentals in PDF

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