Page 96 - DCAP606_BUSINESS_INTELLIGENCE

Unit 6: Business Intelligence Project

Notes
Figure 6.4: Dimension Wizard: Select Dimension attributes

Source: http://www.blrf.net/blog/wp-content/uploads/2011/06/visual_studio_2008_dimension_
wizard_select_dimension_attributes.png
Click next and on the next window, name this dimension as DateTime and click Finish.

Every dimension has its own Attributes and those attributes can be assigned into Hierarchies,
which define how different attributes are related to each other.
In Microsoft SQL Server Analysis Services, you can use the Dimension Wizard in SSDT to create
a time dimension when no time table is available in the source database. This can be done by
selecting one of the following options on the Select Creation Method page:

Generate a time table in the data source: Select this option when you have permission to
create objects in the underlying data source.

Generate a time table on the server: Select this option when you do not have permission to
create objects in the underlying data source.

6.4.3 Modifying the Date Dimension

In this we will create a user-defined hierarchy and change the member names that are displayed
for the Date, Month, Calendar Quarter, and Calendar Semester attributes.
Adding a Named Calculation

You can add a named calculation to a table in a data source view. The expression appears and
behaves as a column in the table.

LOVELY PROFESSIONAL UNIVERSITY 91