|Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys|
|Written by Nicholas Dritsas|
|Wednesday, 01 April 2009 11:10|
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 table, this process can take a while. Our customer in this case has a 100 million members dimension table in Oracle.
Using the option ByTable, SSAS sends one table scan query to the relational engine and temporarily caches in memory the results. This can work well only if you have enough memory for the cache (see related blog for potential issues here).Read more...
Latest Author Articles
- Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study
- Multi user SSAS writebacks may result to blocks on similar functions and new connections
- Proper partitioning can improve dramatically the writeback process when dealing with large data sets
- Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
- Best SQL Server 2005 MDX Tips and Tricks - Part 1