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: | 639 |
| Created: | 2015-12-30 |
Others sql Tutorials
Others related eBooks about Microsoft SQL Server 2012
Oracle Advanced PL/SQL Developer Professional GuidePL/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 ....
Microsoft Access courseThis PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....
Tutorial Oracle Database 11g: SQL Fundamentals in PDFDownload tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....
Graph Databases For BeginnersWhether 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 ....
Guide Microsoft Access 2010This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....
Database Design, 2nd EditionThis book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. ...
RavenDB in ActionThe data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....
Protecting SQL Server DataDownload free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....
Getting started with Oracle 8This pdf tutorial is about fundamental of relational database with Oracle , a free training document for Beginners....
Migrating SQL Server Databases to AzureDownload free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....