SSAS Tips 
Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings...
Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings... | Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings... |
| Thursday, 21 June 2007 19:38 | ||||
|
Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings that allow entering ROLAP mode. Importance - Medium. Source - SSAS 2008 (Katmai) June CTP Partition and Aggregation design warning rules.
|
||||
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
