Semi-additive measure

Last Post 17 Feb 2008 09:47 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

17 Feb 2008 08:08 PM
I am working through some exercises and have gotten the following error:

Error 1 Cube 'Adventure Works DW' > Measure Group 'Fact Internet Sales' : Semi-additive measure requires a time dimension. 0 0

I do not find anything in books online about this. Any assistance is appreciated.
New Member
New Member

17 Feb 2008 09:47 PM

Some measures (semi-additive measures) are simply not meant to be aggregated (e.g. SUM function..) across specific dimensions, particularly time. Consider for instance inventory levels, staffing demographics or current account balances.

Which aggregate function are you using?

Which perspective are you using?

Do you have a time dimension?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: The Best SQL Server 2005 Training in the World!

Acceptable Use Policy