• SQL Server
• Business Intelligence
• Technologies
• Coding Tips
  • Analysis Services
  • Integration Services
  • Reporting Services

Consultancy

Analysis Services

SQL Server Analysis Services (SSAS)

By William E Pearson

• Creating Our First Cube
• Working with Dimensions
• Handling Time Dimensions
• Parent-Child Dimensions
• Working with the Cube Editor
• Exploring Virtual Cubes
• Custom Cubes: Financial Reporting
• Custom Cubes: Financial Reporting - Part II
• Drilling Through to Details: From Two Perspectives
• Reporting Options for Analysis Services Cubes: MS Excel 2002
• Reporting Options for Analysis Services Cubes: MS FrontPage 2002
• Reporting Options for Analysis Services Cubes: Cognos PowerPlay
• Build a Web Site Traffic Analysis Cube: Part I
• Build a Web Site Traffic Analysis Cube: Part II
• MSAS Administration and Optimization: Simple Cube Usage Analysis
• MSAS Administration and Optimization: Toward More Sophisticated Analysis
• Using Calculated Cells in Analysis Services, Part I
• Using Calculated Cells in Analysis Services , Part II
• Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I
• Reporting Options for Analysis Services Cubes: ProClarity Part II
• Putting Actions to Work in Regular Cubes
• Actions in Virtual Cubes
• Introduction to Local Cubes
• Another Approach to Local Cube Design and Creation
• Creating a Dynamic Default Member
• Derived Measures vs. Calculated Measures
• Basic Storage Design
• Partitioning a Cube in Analysis Services - An Introduction
• Performing Incremental Cube Updates - An Introduction
• Semi-Additive Measures and Periodic Balances
• Distinct Count Basics: Two Perspectives
• Manage Distinct Count with a Virtual Cube
• Point-and-Click Cube Schema Simplification
• Presentation Nuances: CrossTab View - Same Dimension
• Process Analysis Services Cubes with DTS
• Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube
• Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II
• Mastering Enterprise BI: Create Aging "Buckets" in a Cube
• Reporting Options for Analysis Services Cubes: MS Excel 2003 and More ...
• Introducing Data Source Views
• Migrating an Analysis Services 2000 Database to Analysis Services 2005
• Named Sets Revisited
• Usage-Based Optimization in Analysis Services 2005
• Process Analysis Services Objects with Integration Services
• Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. I
• Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II
• Mastering Enterprise BI: Introduction to Key Performance Indicators
• Mastering Enterprise BI: Working with Measure Groups
• Introduction to the Analysis Services 2005 Query Log
• Mastering Enterprise BI: Introduction to Perspectives