Aggregate Function Set to None Workaround

Last Post 22 Apr 2008 10:25 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

21 Apr 2008 10:50 AM
I want to add a measure to a cube in SSAS Standard Edition where the measure is of type WChar and the aggregatefunction property set to None. But I get an error saying that I cannot set it to None in Standard Edition.

Is there a way around this?

I just want to display the field data, no aggregate.
New Member
New Member

22 Apr 2008 10:25 PM
How about using the MIN aggregate function?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS:

Acceptable Use Policy