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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Aug 8, 2005

Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Create Aging "Buckets" in a Cube - Page 4

By William Pearson

Procedure

Create a New Aging Shared Dimension

We will create support for aging within our cube by adding a new shared dimension. It will be within this dimension that we construct the logic to derive our aging buckets.

1.  Right-click the Shared Dimensions folder within the new AgingDim Analysis Services database.

2.  Select New Dimension from the context menu that appears.

3.  Select Editor from the cascading menu that appears next, as depicted in Illustration 12.


Illustration 12: Select New Dimension --> Editor from the Context Menus

The Choose a Dimension Table dialog appears.

4.  Scroll down in the Tables pane (left half of the dialog), to locate the time_by_day table in the clone database.

5.  Select the time_by_day table, as shown in Illustration 13.


Illustration 13: Select the Time_by_day Table

6.  Click OK to accept the selection, and to progress to the Dimension Editor.

7.  From the Schema tab in the Dimension Editor, drag the field named the_date from within the time_by_day table to the left, dropping it onto the <New> dimension in the tree, as depicted in Illustration 14.


Illustration 14: Drag the Field Named The_date to the New Dimension

The Date appears as the first level under the <New> dimension.

8.  Click <New> in the Dimension tree to highlight it.

9.  Type Aged Period into the Name box, on the Basic tab of the Properties pane.

10.  Click the The Date level in the Dimension tree.

11.  Replace the Name on the Basic tab of the Properties pane with the following:

Transaction_Date

Our changes appear as shown in a partial view of the Dimension Editor in Illustration 15.


Illustration 15: Highlighted Changes in the Dimension Editor (Partial View)

We now need to insert a new level within the new dimension.

12.  Right-click the Transaction Date level in the Dimension tree.

13.  Select New Level, as depicted in Illustration 16.


Illustration 16: Select New Level ...

The Insert Level dialog appears.

14.  Select the_date as the member key column (it will be a temporary assignment, as we shall see), as shown in Illustration 17.


Illustration 17: Selecting The_date as a "Placeholder..."

15.  Click OK to accept the selection.



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