Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 11, 2002

Introduction to SQL Server 2000 Analysis Services: Working with the Cube Editor - Page 15

By William Pearson

Next in Our Series ...

In this article, Working with the Cube Editor, we reviewed and integrated many of the components that we have constructed and the concepts that we have explored individually in the last four lessons. We undertook a complete cube build, demonstrating the assembly of a cube more sophisticated than the cube we generated in our first lesson with the Cube Wizard. We also introduced new capabilities and concepts as we constructed our new cube "from scratch."

In this article, we also discussed the use of the Cube Editor, as opposed to the Cube Wizard, as a means of cube construction, and then we created a basic "starter" cube directly from the fact table, to serve as a foundation for a more elaborate cube. We expanded the dimensions of the cube after adding the associated dimension tables. We worked with the dimensions, defining the appearance of the Member Name Column to meet illustrative business requirements of information consumers; in addition, we reviewed sample uses and purposes of member properties.

We made use of the Dimension Browser for design and observation tasks at various points. We added a derived dimension, and we revisited calculated members, adding a calculated measure to our cube. Throughout the lesson, we worked with various properties of measures and dimensions to control the behavior and characteristics of our cube.

In our next lesson, Exploring Virtual Cubes, we will introduce the concept of virtual cubes. We will discuss the options that virtual cubes provide in allowing us to combine measures from more than one existing cube, as well as in the removal of dimensions and/or measures from our cubes for various reasons. We will practice the use of the Virtual Cube Wizard to create a virtual cube that is a subset of an existing cube, as a means of "customizing" the information presented by a cube to a given information consumer or consumer group. We will expose a process by which we can combine measures from multiple cubes, as well as a means for creating calculated members in our virtual cube. Finally, we will practice the import of calculated members from a sample source cube to our virtual cube.

See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM