Featured Database Articles MS SQL
September 3, 2002Introduction to SQL Server 2000 Analysis Services: Creating Our First Cube By William Pearson
Final Thoughts
As we progress further in the series, we will explore other options and capabilities that the power of multi dimensional analysis places within convenient reach. For the time being, it will help us to become familiar with the operation of the Cube Browser by playing around within the confines of the functionality we have discussed thus far. In addition, the online help and tutorials will certainly provide multiple perspectives from which we can enhance our understanding of the design, generation and browsing of cubes within Microsoft SQL Server 2000 Analysis Services.
See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum .
Introduction to MSSQL Server Analysis Services Series
Part 76:
Introduction to Attribute Relationships in MSSQL Server Analysis Services
Part 75:
Attribute Member Values in Analysis Services
Part 74:
MSSQL Analysis Services - Attribute Member Names
Part 73:
Attribute Member Keys – Pt 2: Composite Keys
Part 72:
Attribute Member Keys – Pt 1: Introduction and Simple Keys
Part 71:
Dimension Attributes: Introduction and Overview, Part V
Part 70:
Dimension Attributes: Introduction and Overview, Part IV
Part 69:
Dimension Attributes: Introduction and Overview, Part III
Part 68:
Dimension Attributes: Introduction and Overview, Part II
Part 67:
Dimension Attributes: Introduction and Overview, Part I
Part 66:
Dimensional Model Components: Dimensions Part II
Part 65:
Dimensional Model Components: Dimensions Part I
Part 64:
Manage Unknown Members in Analysis Services 2005, Part II
Part 63:
Manage Unknown Members in Analysis Services 2005, Part I
Part 62:
Alternatively Sorting Attribute Members in Analysis Services 2005
Part 61:
Introduction to Linked Objects in Analysis Services 2005
Part 60:
Distinct Counts in Analysis Services 2005
Part 59:
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
Part 58:
Administration and Optimization: SQL Server Profiler for Analysis Services Queries
Part 57:
Mastering Enterprise BI: Time Intelligence Pt. II
Part 56:
Mastering Enterprise BI: Time Intelligence Pt. I
Part 55:
Design and Documentation: Introducing the Visio 2007 PivotDiagram
Part 54:
Actions in Analysis Services 2005: The URL Action
Part 53:
Actions in Analysis Services 2005: The Drillthrough Action
Part 52:
Mastering Enterprise BI: Introducing Actions in Analysis Services 2005
Part 51:
Mastering Enterprise BI: Introduction to Translations
Part 50:
Mastering Enterprise BI: Introduction to Perspectives
Part 49:
Introduction to the Analysis Services 2005 Query Log
Part 48:
Mastering Enterprise BI: Working with Measure Groups
Part 47:
Mastering Enterprise BI: Introduction to Key Performance Indicators
Part 46:
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II
Part 45:
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. I
Part 44:
Process Analysis Services Objects with Integration Services
Part 43:
Usage-Based Optimization in Analysis Services 2005
Part 42:
Named Sets Revisited
Part 41:
Migrating an Analysis Services 2000 Database to Analysis Services 2005
Part 40:
Introducing Data Source Views
Part 39:
Reporting Options for Analysis Services Cubes: MS Excel 2003 and More ...
Part 38:
Mastering Enterprise BI: Create Aging "Buckets" in a Cube
Part 37:
Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II
Part 36:
Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube
Part 35:
Process Analysis Services Cubes with DTS
Part 34:
Presentation Nuances: CrossTab View - Same Dimension
Part 33:
Point-and-Click Cube Schema Simplification
Part 32:
Manage Distinct Count with a Virtual Cube
Part 31:
Distinct Count Basics: Two Perspectives
Part 30:
Semi-Additive Measures and Periodic Balances
Part 29:
Performing Incremental Cube Updates - An Introduction
Part 28:
Partitioning a Cube in Analysis Services - An Introduction
Part 27:
Basic Storage Design
Part 26:
Derived Measures vs. Calculated Measures
Part 25:
Creating a Dynamic Default Member
Part 24:
Another Approach to Local Cube Design and Creation
Part 23:
Introduction to Local Cubes
Part 22:
Actions in Virtual Cubes
Part 21:
Putting Actions to Work in Regular Cubes
Part 20:
Reporting Options for Analysis Services Cubes: ProClarity Part II
Part 19:
Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I
Part 18:
Using Calculated Cells in Analysis Services , Part II
Part 17:
Using Calculated Cells in Analysis Services, Part I
Part 16:
MSAS Administration and Optimization: Toward More Sophisticated Analysis
Part 15:
MSAS Administration and Optimization: Simple Cube Usage Analysis
Part 14:
Build a Web Site Traffic Analysis Cube: Part II
Part 13:
Build a Web Site Traffic Analysis Cube: Part I
Part 12:
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
Part 11:
Reporting Options for Analysis Services Cubes: MS FrontPage 2002
Part 10:
Reporting Options for Analysis Services Cubes: MS Excel 2002
Part 9:
Drilling Through to Details: From Two Perspectives
Part 8:
Custom Cubes: Financial Reporting - Part II
Part 7:
Custom Cubes: Financial Reporting
Part 6:
Exploring Virtual Cubes
Part 5:
Working with the Cube Editor
Part 4:
Parent-Child Dimensions
Part 3:
Handling Time Dimensions
Part 2:
Working with Dimensions
Part 1:
Creating Our First Cube
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
|
|
Receive news via our XML/RSS
feed
MS SQL Archives
IE 7
Firefox 2.0