Measure Group with mixed aggregation

This is a discussion on Measure Group with mixed aggregation within the sqlserver-datawarehouse forums in Data Warehousing category; What is the best way to handle the situation where a measure group contains some measures which are summed and others which have AggregationFunction set to None ? I would instinctively split these measures into two separate measure groups to exploit aggregation. Is this a reasonable approach to take?...

Go Back   Database Forum > Data Warehousing > sqlserver-datawarehouse

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-04-2008, 09:15 AM
Default Measure Group with mixed aggregation

What is the best way to handle the situation where a measure group contains
some measures which are summed and others which have AggregationFunction set
to "None"? I would instinctively split these measures into two separate
measure groups to exploit aggregation. Is this a reasonable approach to take?

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:18 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.