|
by Nicholas Dritsas via Microsoft SQL Server Development Customer Advisory Team on 4/1/2009 3:48:00 AM
Author: Nicholas Dritsas
Reviewers: Thomas Kejser, Stuart Ozer
In SSAS 2005 and later, there is a dimension property called ProcessingGroup. It has two values; ByAttribute (default) and ByTable.
When you use ByAttribute, SSAS will send a SELECT DISTINCT query to the relational engine for each attribute PLUS, at the end, an additional SELECT DISTINCT that combines all the attributes plus key. As you can imagine, if you have several attributes and a very large dimension t
... [ read more ]
|
|