Summary
MSAS 2000 includes numerous helpful wizards that will help the cube architect create basic dimensions and cubes easily. However, if you get beyond the basic functionality, you need to know where to look and which options to tweak. This article discussed some of the advanced features such as ragged hierarchies, dimension level security, cube schema optimization, and advanced dimension properties. By using these features, you can make your Analysis Services solutions more flexible and better tailored to your users’ needs.