Aggregate Function Set to None Workaround

Last Post 22 Apr 2008 10:25 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kjmcsd
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.
SQLUSA
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: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy