dbTalk Databases Forums  

the aggregate function cannot operate on calculated measure

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


Discuss the aggregate function cannot operate on calculated measure in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eric Wiltrout via SQLMonster.com
 
Posts: n/a

Default the aggregate function cannot operate on calculated measure - 04-13-2005 , 11:03 AM






I get the following error in my cube when browsing.

Unable to display cell properties. The aggregate function cannot operate
on calculated measure "Year To date"

The cell diplays #ERR on my Year to Date cell, but my Amount field is
retrieving data.

Eric

--
Message posted via http://www.sqlmonster.com

Reply With Quote
  #2  
Old   
David Botzenhart
 
Posts: n/a

Default Re: the aggregate function cannot operate on calculated measure - 04-13-2005 , 08:43 PM






Hi Eric,
According to BOL the Aggregate function doesn't work with Calculated
Members. So I would expect this error.
What are you browsing with?
David Botzenhart

"Eric Wiltrout via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote in
message news:9f7b2544a74e466fa81b30eb64aae7c4 (AT) SQLMonster (DOT) com...
Quote:
I get the following error in my cube when browsing.

Unable to display cell properties. The aggregate function cannot operate
on calculated measure "Year To date"

The cell diplays #ERR on my Year to Date cell, but my Amount field is
retrieving data.

Eric

--
Message posted via http://www.sqlmonster.com



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.