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 Feb 17, 2003

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

By William Pearson


Now we'll make a few changes to the Calendar.Time dimension to more precisely establish it as a time dimension.


19.  Click the Calendar.Time dimension to highlight / select it.


20.  Click the Advanced tab of the Properties pane.


21.  Change the Type field for the Calendar.Time dimension to Time, as shown below.






Illustration 35: The Calendar.Time Dimension Advanced Properties

22.  Click the Calendar Year level to highlight / select it.

23.  Click the Advanced tab of the Properties pane.

24.  Change the Level Type field for the Calendar Year level to Years, as shown in the following illustration.


Illustration 36: The Calendar.Time Dimension, Calendar Year Level Advanced Properties

25.  Click the Calendar Quarter level to highlight / select it.

26.  Click the Advanced tab of the Properties pane.

27.  Change the Level Type field for the Calendar Quarter level to Quarters, as shown in the Illustration 37 below.


Illustration 37: The Calendar.Time Dimension, Calendar Quarter Level Advanced Properties

28.  Click the Calendar Month level to highlight / select it.

29.  Click the Advanced tab of the Properties pane.

30.  Change the Level Type field for the Calendar Month level to Months, as shown in the following illustration.


Illustration 38: The Calendar.Time Dimension, Calendar Month Level Advanced Properties

31.  Click the Date level to highlight / select it.

32.  Click the Advanced tab of the Properties pane.

33.  Change the Level Type field for the Date level to Days, as shown in the following illustration.


Illustration 39: The Calendar.Time Dimension Date Level Advanced Properties

I typically style the lowest level in the Date hierarchy as Date; calendar, fiscal, and perhaps other date hierarchies would typically share Date as a common lowest level, and thus I give it a name that will serve all equally well.

Having handled the Calendar.Time member properties that will be created in our cube, let's do something similar for the Store dimension. The Store dimension consists of member naming that makes intuitive sense, as we will see upon our initial cube generation, so we will simply swap the name for the id number that previously occupied the Store member level.

34.  Right-click the store_id dimension.

35.  Select Rename from the context menu, and type in Store.

36.  Click the Advanced tab in the Properties pane.

37.  Select the All Caption property.

38.  Change the All Caption property to read "All Stores."

39.  Drag the store_id field from the store table over to drop onto the Store dimension in the cube tree.

40.  Right-click the store_id level that appears.

41.  Select Rename from the context menu, and type in Store.

42.  Click the Basic tab in the Properties pane.

43.  Select the Member Name Column property.

44.  Click the ellipses button ("..").

The Select Column dialog appears.

45.  Select the store_name column by clicking.

46.  Click OK.

47.  Press the Enter key.

The Properties pane for the new Store level, with the modification we have put into place, should appear as shown below:


Illustration 40: The Modified Properties, Store Level Member of the Store Dimension



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


















Thanks for your registration, follow us on our social networks to keep up-to-date