dbTalk Databases Forums  

How to do aggregate function on a measure as in AS2000

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


Discuss How to do aggregate function on a measure as in AS2000 in the microsoft.public.sqlserver.olap forum.



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

Default How to do aggregate function on a measure as in AS2000 - 01-08-2006 , 04:38 AM






In AS2000 you can create a measure from a source column with a aggregate
property. Ex. MIN, MAX.

I have tried creating calculated members, but cant seem to get the same
functionalty. Is is also possible in AS 2005
--
Regards
Henrik Juel

Reply With Quote
  #2  
Old   
Henrik Juel
 
Posts: n/a

Default RE: How to do aggregate function on a measure as in AS2000 - 01-08-2006 , 06:25 AM






I just create a measure as in AS2000. Just found out how easy it is with 2005.
--
Regards
Henrik Juel


"Henrik Juel" wrote:

Quote:
In AS2000 you can create a measure from a source column with a aggregate
property. Ex. MIN, MAX.

I have tried creating calculated members, but cant seem to get the same
functionalty. Is is also possible in AS 2005
--
Regards
Henrik Juel

Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: How to do aggregate function on a measure as in AS2000 - 01-08-2006 , 02:38 PM



AS2005 provides the same aggregations features and more.
create a new measure, in the property pane, select the required aggregation.

"Henrik Juel" <HenrikJuel (AT) discussions (DOT) microsoft.com> wrote

Quote:
In AS2000 you can create a measure from a source column with a aggregate
property. Ex. MIN, MAX.

I have tried creating calculated members, but cant seem to get the same
functionalty. Is is also possible in AS 2005
--
Regards
Henrik Juel



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.