You're reading from SQL Server Analysis Services 2012 Cube Development Cookbook If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast.

Product type Paperback

Published in Dec 2013

Publisher Packt

ISBN-13 9781849689809

Length 340 pages

Edition 1st Edition

Concepts

Business Intelligence

Table of Contents (14) Chapters

Preface

1. Introduction to Multidimensional Data Model Design FREE CHAPTER

2. Defining Analysis Services Dimensions

3. Creating Analysis Services Cubes

4. Extending and Customizing Cubes

5. Optimizing Dimension and Cube Processing

6. MDX

7. Analysis Services Security

8. Administering and Monitoring Analysis Services

9. Using Tabular Models

10. DAX Calculations and Queries

11. Performance Tuning and Troubleshooting Tabular Models

A. Miscellaneous Analysis Services Topics

Index

Dimension properties

The following table summarizes most frequently used dimension properties:

Dimension property name	Explanation
`AttributeAllMemberName`	Specifies the name of the top level of each attribute hierarchy. For example, if you set this property for promotion's dimension to `All Adventure Works Promotions`, each attribute hierarchy will show `All Adventure Works Promotions` as its top level. The default value is `All`. This property does not apply to user-defined hierarchies. You can set the `ALLMemberName` property for each user-defined hierarchy to override its default.
`StorageMode`	The default value is `MOLAP` (Multi-dimensional OLAP), which stores dimension data in Microsoft's proprietary multidimensional storage format. The other option is `ROLAP`, which leaves data in the relational data source. If the storage option is `ROLAP`, MDX queries are resolved by sending the necessary `SELECT` statements to the relational source and retrieving data at query time. With previous...

Dimension property name

Explanation

AttributeAllMemberName

Specifies the name of the top level of each attribute hierarchy. For example, if you set this property for promotion's dimension to All Adventure Works Promotions, each attribute hierarchy will show All Adventure Works Promotions as its top level. The default value is All.

This property does not apply to user-defined hierarchies. You can set the ALLMemberName property for each user-defined hierarchy to override its default.

StorageMode

The default value is MOLAP (Multi-dimensional OLAP), which stores dimension data in Microsoft's proprietary multidimensional storage format. The other option is ROLAP, which leaves data in the relational data source. If the storage option is ROLAP, MDX queries are resolved by sending the necessary SELECT statements to the relational source and retrieving data at query time. With previous...

The rest of the chapter is locked

Table of Contents (14) Chapters

Dimension properties

Unlock this book and the full library FREE for 7 days

Personalised recommendations for you