MS SQL Server OLAP - Suppress All member in attribute dimension (AS 2005)

Author

Suppress All member in attribute dimension (AS 2005)

PeterG

2005-11-22, 1:23 pm

I have an attribute dimension for Year 2002 through 2005. I do not want the
All member on the dimension - it will be used as report parameter and I want
to list just the years.

From my understanding, to not include an All member in an attribute
dimension you set IsAggregatable property to False. That does indeed suppress
All, but my cube now only has values for Year 2002, which is not the desired
result. Is there a way to set IsAggregatable to False and still aggregate
across the members?

Is there another way to suppress the All member in an attribute dimension?

Darren Gosbell

2005-11-22, 8:24 pm

Are you sure the other values are definitely not in the cube?

The reason I ask is that the "All" member is usually the default member
for the dimension and if you remove it, the dimension will default to
using the first member in the dimension (2002 in your case), if you have
not explicitly specify a member to use in the query.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <9CAEBD3B-C033-4FB1-9C99- 7B7B31ED3995@microso
ft.com>,
PeterG@discussions.microsoft.com says...
> I have an attribute dimension for Year 2002 through 2005. I do not want the
> All member on the dimension - it will be used as report parameter and I want
> to list just the years.
>
> From my understanding, to not include an All member in an attribute
> dimension you set IsAggregatable property to False. That does indeed suppress
> All, but my cube now only has values for Year 2002, which is not the desired
> result. Is there a way to set IsAggregatable to False and still aggregate
> across the members?
>
> Is there another way to suppress the All member in an attribute dimension?
>
>

Sponsored Links