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 | |
| Downloads | 662 |
| Created | 2015-12-30 |
Others sql tutorials
Others related eBooks about Microsoft SQL Server 2012
-
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....