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 |
| Downloads: | 643 |
| Created: | 2015-12-30 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263
Others related eBooks about Microsoft SQL Server 2012
Download free course Data Science with Microsoft SQL Server 2016, pdf file on 90 pages by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok.
Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL.
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 .
Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com.
SQL is a standard language for storing, manipulating and retrieving data in relational databases.