Chapter 2. Defining Analysis Services Dimensions
In this chapter, we will cover the following recipes:
- Defining data sources
- Defining data source views
- Defining entity relationships in DSV
- Extending data source views
- Creating named calculations and queries
- Creating simple dimensions
- Building dimension hierarchies
- Setting up dimension properties
- Setting up the essential attribute properties
- Browsing dimension data
- Sorting the attributes
- Customizing advanced attribute properties
- Creating parent-child dimensions
- Creating date and time dimensions
Introduction
This chapter explains how to build and configure most commonly encountered SQL Server Analysis Services (SSAS) dimensions. Each Analysis Services multidimensional project consists of dimensions and cubes; knowing ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
