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: | 639 |
| 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
SQL is a standard language for storing, manipulating and retrieving data in relational databases.
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
This tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download .
Download free course SQL Server Metadata Succinctly, pdf file on 85 pages by Joseph D. Booth.
This book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it.