O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Cube and dimension design

This part explains things you encounter during designing your dimensions and cubes: default members, attribute relationships, natural hierarchies, unnatural hierarchies, parent-child hierarchies, utility dimensions, granularity, and so on.

Default member

The default member is a member defined as such in a hierarchy or MDX script. It sets the context for queries and calculations unless overwritten by another member of the same hierarchy or implicitly shifted by a member from a related hierarchy. The latter case can lead to unexpected results, therefore, setting the default member should only be done after a careful consideration of which attribute combinations are allowed to be made by end-users.

A default member should ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required