Hi,

I would like to build a flat dimension. I want a "Gender" dimension with
just 2 values "Male" & "Female".

The problem is MSAS 2005 inserts a default "All" level (parent). This is
what i want to eliminate while building the dimension.

Any ideas?

Thanks,

Prasad.

Hi Prasad,

Did you try setting the "IsAggregatable" property to false?

http://msdn2.microsoft.com/en-us/library/ms174497.aspx

In Microsoft SQL Server 2005 Analysis Services (SSAS), the (All) level
is an optional, system-generated level. It contains only one member
whose value is the aggregation of the values of all members in the
immediately subordinate level. This member is called the All member. It
is a system-generated member that is not contained in the dimension
table. Because the member in the (All) level is at the top of the
hierarchy, the member's value is the consolidated aggregation of the
values of all members in the hierarchy. The All member often serves as
the default member of a hierarchy.

The presence of an (All) level in an attribute hierarchy depends on the
IsAggregatable property setting for the attribute and the presence of an
(All) level in a multilevel hierarchy depends on the IsAggregatable
property of the attribute at the top-most level of multilevel hierarchy.
If the IsAggregatable property is set to True, an (All) level will
exist. A hierarchy has no (All) level if the IsAggregatable property is
set to False.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Thanks a lot.

I have one other question. In MSAS 2000 within the cube editor, i used to go
to different levels in multi level hierarchial dimension and specify whether
to involve a particular level in the Aggregation strategy while building the
cube or not.

I am not sure how to do the same in MSAS 2005?

Thanks & Best Regards,

Prasad.

"Deepak Puri" wrote: