dbTalk Databases Forums  

Suppress All member in attribute dimension (AS 2005)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Suppress All member in attribute dimension (AS 2005) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PeterG
 
Posts: n/a

Default Suppress All member in attribute dimension (AS 2005) - 11-22-2005 , 12:59 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?


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Suppress All member in attribute dimension (AS 2005) - 11-22-2005 , 07:28 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 (AT) microsoft (DOT) com>,
PeterG (AT) discussions (DOT) microsoft.com says...
Quote:
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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.