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

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

News Via RSS Feed

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 7

By William Pearson

The list of columns in the expense_fact table appears in the Details pane on the right half of the dialog. As most of us realize, expenses, or costs, are not the only components of an Income / Profit & Loss Statement. Our plan is to add in the revenue / sales and other necessary information after we create our basic cube. We will discuss methods of accomplishing this at a later stage in our cube design and creation.

5.      Click OK.

The Fact Table Row Count message box appears, asking if we want to count fact table rows, as shown below.

Click for larger image

Illustration 13: The Fact Table Row Count Message Box

6.      Click Yes.

The Cube Editor window appears, showing the cube tree (top) and properties pane (bottom) on the left side of the window, and the fact table schema (the Schema tab view) on the right, by default. The window should appear as depicted in Illustration 14 below.

Click for larger image

Illustration 14: The Cube Editor, with the Expense_Fact Table Schema View (Compressed)

7.      Add the following measure to the Measures folder, by dragging it from the expense_fact table, and dropping it onto the folder:

  • amount

The selected measure field appears in the Measures folder (initial caps is an automatic conversion feature, as we have noted in earlier lessons) as shown below:

Illustration 15: The Measures Folder with Newly Added Amount Measure

A cube must contain a minimum of one measure from the designated fact table; in addition, it must also contain at least one dimension that is associated with a key column in the table.

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