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: | 637 |
| Created: | 2015-12-30 |
Others sql Tutorials
Others related eBooks about Microsoft SQL Server 2012
Access 2013 Lab manualDownload free Microsoft Office Access 2013 file under 115 pages,pdf manual , course tutorial training on pdf by David Murray (University at Buffalo)....
MySQL Notes for ProfessionalsDownload free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....
Mastering SQL Queries for SAP Business OneSAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers..., download free SQL Queries tutorial in PDF (352 pages) created by Gordon Du ....
Microsoft Access 2013 courseDownload free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....
Oracle database tutorialDownload free Oracle tutorial course in PDF, training file in 33 chapters and 104 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Learning Microsoft SQL ServerDownload free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....
Essential MySQLThis 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....
Migrating SQL Server Databases to AzureDownload free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....
MySQL Notes for ProfessionalsMySQL'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...
Guide to NoSQL with Azure Cosmos DBDownload free course Guide to NoSQL with Azure Cosmos DB, pdf file on 205 pages by Gaston C. Hillar , Daron Yöndem....