SSAS Tips 
NULL default measure might improve querying performance
NULL default measure might improve querying performance | NULL default measure might improve querying performance |
| Tuesday, 25 September 2007 19:09 | ||||
|
In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there is no default measure by default, which can lead to long query times for queries that specify no measures. We have seen slow behavior with several query tools that display an initial default query or heavily browse the hierarchies, especially Proclarity. Read more in then Nicholas Dritsas blog.
|
||||
Comments (1)
Top Rated
- Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration ...
- Avoid redundant attribute relationships because these relationships may prevent data from being ...
- Avoid having 10 or more dimensions with a single attribute. Consider unifying them
- If you can, list in SELECT statement real measures first and calculated measures after
- Remove aggregation designs that are not used by any partitions
- Process only one partition so you can browse the cube
- NULL default measure might improve querying performance
- Create hierarchies in non-parent child dimensions
I think is always set the default measure yourself, because you better the values in the measures then SSAS. E.g., choose a Interger measure instead of numeric/float, etc..
Tiago.