Database Reference
In-Depth Information
Dimension properties
The following table summarizes most frequently used dimension properties:
Dimension property name
Explanation
Specifies the name of the top level of
each attribute hierarchy. For example, if
you set this property for promotion's di-
mension to
All Adventure Works
Promotions
, each attribute hierarchy
will show
All Adventure Works
Promotions
as its top level. The default
value is
All
.
AttributeAllMemberName
This property does not apply to user-
defined hierarchies. You can set the
ALLMemberName
property for each user-
defined hierarchy to override its default.
The default value is
MOLAP
(Multi-dimen-
sional OLAP), which stores dimension
data in Microsoft's proprietary multidimen-
sional 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
state-
ments to the relational source and retriev-
ing data at query time. With previous re-
leases of the software, very large dimen-
sions had to use the
ROLAP
mode be-
StorageMode
Search WWH ::
Custom Search