Database Reference
In-Depth Information
distinct values. If you find that such queries take too long to complete or if SSAS
runs out of memory during dimension processing, you could alter the
Process-
ingGroup
dimension property. The default value for this property is
ByAttribute
.
Changing the property to the
ByTable
value will advise SSAS to run a single
SELECT
statement for the entire dimension, instead of running separate queries
for each attribute. Furthermore, the query will no longer include the
DISTINCT
keyword.
Search WWH ::
Custom Search