Microsoft® SQL ServerTM 2005 Analysis Services Step by Step
Teach yourself the fundamentals of SQL Server Analysis Services-one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization. Discover how to: Start building cubes using...
| Autor principal: | |
|---|---|
| Autores Corporativos: | , |
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627358706719 |
Tabla de Contenidos:
- Microsoft® SQL ServerTM 2005 Analysis Services Step by Step; About the Companion CD-ROM; System Requirements; Installing and Using the Sample Files; Conventions and Features in This Book; I. Getting Started with Analysis Services; Reviewing Data Warehousing Concepts; The Structure of a Dimensional Database; A Fact Table; Dimension Tables; Stars and Snowflakes; Alternative Dimension Table Structures; Chapter 1 Quick Reference; 2. Understanding OLAP and Analysis Services; Metadata-Based Queries; Spreadsheet-Style Formulas; Understanding Analysis Services; Analysis Services and Metadata
- Cube MetadataAnalysis Services Formulas; Analysis Services Tools; Chapter 2 Quick Reference; 3. Building Your First Cube; Exploring Menu Commands; Preparing to Create a Cube; Creating a New Analysis Services Project; Creating a Cube; Specify a data source; Add measures; Add dimensions; Define time periods; Add a special calendar; Relate dimensions to measures; Finish the Cube Wizard; Reviewing the Cube Structure in the Cube Designer; Generating a Schema; Loading Data into the Relational Schema; Processing and Browsing a Cube; Browsing a Cube; Chapter 3 Quick Reference; II. Design Fundamentals
- Building a Standard DimensionCreating a Data Source View; Using the Dimension Wizard; Deploying a Dimension; Changing Attribute Properties; Working with a Time Dimension; Creating a Time Dimension; Working with Role-Playing Dimensions; Add role-playing time dimensions to a cube; Creating a Parent-Child Dimension; Totaling Data for Non-Leaf-Level Data Members; Managing Levels within a Parent-Child Dimension; Create a level naming template for a parent-child hierarchy; Chapter 4 Quick Reference; 5. Designing Measure Groups and Measures; Changing Properties for Measure Groups and Measures
- Format measuresSpecifying Dimension Usage; Browsing Multiple Measure Groups; Aggregating Semiadditive Measures; Using a Semiadditive Aggregate Function; Calculating Distinct Counts; Creating Simple Calculations; Applying Conditional Formatting; Chapter 5 Quick Reference; 6. Working with a Finance Measure Group; Using Unary Operators; Set the UnaryOperatorColumn property; Aggregating by Account; Use the ByAccount aggregate function; Designing Nonadditive Financial Measures; Chapter 6 Quick Reference; 7. Designing Aggregations and Hierarchies; Inspecting Aggregations; Changing Partition Counts
- Adding Attributes to the Aggregation DesignDesigning User Hierarchies; Aggregating User Hierarchies; Optimizing Aggregations; Viewing Usage Data; Using the Usage-Based Optimization Wizard; Maintaining the Query Log; Chapter 7 Quick Reference; III. Advanced Design; Creating an MDX Calculation for Percent of Parent; Querying with MDX; Working with Basic MDX Queries; Designing Custom Members; Creating Cumulative Calculations; Working with MDX Scripts; Adding a Script Assignment; Developing Key Performance Indicators; Using MDX Expressions with Key Performance Indicators
- Chapter 8 Quick Reference
