Aggregation per Dimension

Aggregation per Dimension

This is a discussion on Aggregation per Dimension within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> I have a measure 'Food Consumption/day/person' and dimensions of Year, Country and Commodity (say Wheat, Barley, ...) . I ...

		Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing
Aggregation per Dimension

#1 (permalink)

02-27-2008, 07:07 PM

=?Utf-8?B?UmljaGFyZCBSb2NoZQ==?=

Posts: n/a

Aggregation per Dimension

I have a measure 'Food Consumption/day/person' and dimensions of
Year, Country and Commodity (say Wheat, Barley, ...) . I would
like to use the SUM aggregate across Commodity, but use AVERAGE
across Country and Year. It does not make sense to SUm across
country or year.

Is this possible? If so how.

Thanks.

--
Richard

« BI Studio: Poor Performance When Opening a Solution | Data Mart rollbacks »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 05:56 AM.