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
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 6, 2003

Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I) - Page 8

By William Pearson

We will add dimensions next.

8.      Add the following dimensions to the Dimensions folder, by dragging each from the expense_fact table onto the folder, in the following order:

  • time_id
  • store_id
  • category_id

The selected dimension key fields appear in the Dimensions folder (sans underscores, and with initial caps, once again) as shown below:

Illustration 16: The Dimensions Folder with Newly Added Dimensions

The dimensions that we have added are private dimensions, meaning that they belong to this cube only. Now let's make some adjustments to the measure and dimension properties, to make them more useful to our model, as well as to refresh our memories, in some cases, of member properties attributes.

9.      Click the Time Id dimension to select it in the cube tree.

10.  Click Properties beneath the tree pane to display the properties of the Time Id dimension.

11.  Click the Basic tab in the Properties pane.

12.  Rename the dimension to Calendar.Time.

The Basic tab of the Properties pane for the Calendar.Time dimension appears as shown below:

Illustration 17: Calendar.Time Dimension, Properties Pane, Basic Tab

13.  Click the Time Id level underneath the Calendar.Time dimension to select it in the cube tree.

14.  Ensure the Basic tab in the Properties pane is selected.

15.  Rename the level to Calendar Time (note that the delimiter "." is not allowed here).

The Basic tab of the Properties pane for the single Time level appears as shown below:

Illustration 18: Time Level, Properties Pane, Basic Tab

16.  Click the Calendar.Time dimension again, to select it in the cube tree.

17.  Click the Advanced tab in the Properties pane.

18.  Modify the All Caption to read All Calendar Time.

The Advanced tab of the Properties pane for the Calendar.Time dimension appears as shown below:

Illustration 19: Calendar.Time Dimension, Properties Pane, Advanced Tab

19.  Complete steps 9 through 18 above, for each of the other two dimensions, Store Id, and Category Id, to rename the dimensions (and their associated single underlying levels) to Store and Category, respectively, on the associated Properties panes, Basic tab.

20.  Modify the All Caption fields, on the Advanced tab in the Properties panes for Store and Category, to read All Stores, and All Categories, respectively.

At this juncture, the cube tree should appear as shown below:

Illustration 20: Cube Tree, Reflecting Modifications of the Dimensions (and Associated Levels) Names

Keep in mind that the dimensions we have defined are, again, private dimensions. Because private dimensions (and the associated dimension levels) are defined for the individual cube, they are created / modified, as we have seen above, using the Cube Editor. We must be "inside" the cube with the Editor to readily see the private dimensions exposed in the cube tree.

We will process the cube at this stage.

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



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