Page 95 - DCAP606_BUSINESS_INTELLIGENCE
P. 95
Business Intelligence
Notes Attributes can be coordinated into user-defined hierarchies that supply navigational routes to
assist users when browsing the data in a cube.
Use the Dimension Wizard in SSDT to create a database dimension in a Microsoft SQL Server
Analysis Services project. After a database dimension is created, you can use Dimension Designer
to modify its properties. To understand the concept better we will create a DateTime Dimension.
6.4.2 Time Dimension
To Create DateTime Dimension follow these steps:
Go to Dimensions in project’s Solution Explorer. Right-click on Dimensions and click New
dimension. A wizard will open. Click Next on that wizard. Choose Use an existing
table option and click Next again. On Specify Source Information window, select your
Data source view, Main table, Key columns and Name columns.
Figure 6.3: Dimension Wizard: Specify Source Information
Source:http://www.blrf.net/blog/wp-content/uploads/2011/06/visual_studio_2008_dimension_
wizard_create_datetime_dimension.png
Click Next and on this window, un-check all related tables offered to you and click Next again.
On Select Dimension Attributes only Attribute Names T, Year, Month and Day should be Enabled.
90 LOVELY PROFESSIONAL UNIVERSITY
