Browse by Tags

• Aggregations
• Cache
• OLAP
• Partitions
• Performance
• Scalability

• Including Child Members Multiple Places in a Parent-Child Hierarchy

  Author: Carl Rabeler Contributor: Scott Hulke Reviewers: Richard Tkachuk, Thomas Kejser, Denny Lee When designing your SQL Server 2005 (or 2008) Analysis... Posted Mar 17 2008, 07:46 PM by CarlRabeler with | with 3 comment(s) Filed under: Analysis Services, Performance, OLAP

• Analysis Services Synchronization Best Practices

  Authors : Denny Lee, Edward Melomed, Mike Vovchik Contributors: Duy Vuong, Greg Washburn Reviewers : Prem Mehra, Stuart Ozer, Thomas Kejser, Nicholas Dritsas... Posted Mar 16 2008, 12:18 AM by denny.lee with | with 1 comment(s) Filed under: Analysis Services

• Sample Robocopy Script to customer synchronize Analysis Services databases

  Authors: Eric Jacobsen, Denny Lee Contributors: Mike Vovchik Technical Reviewers: Guillaume Fourrat, Richard Tkachuk, Thomas Kejser Applicable to: SQL... Posted Jan 17 2008, 02:51 PM by denny.lee with | with 1 comment(s) Filed under: Analysis Services, Scalability

• Analysis Services 2005 Aggregation Design Strategy

  Author: Eric Jacobsen, Denny Lee Introduction Designing effective aggregations are a well known way to improve query performance (for the sake of AS processing... Posted Sep 11 2007, 07:54 PM by admin with | with 1 comment(s) Filed under: Analysis Services, Aggregations

• How to warm up the Analysis Services data cache using Create Cache statement?

  Author: Eric Jacobsen, Christian Petculescu Updated by Denny Lee Goal This document describes how to build Create Cache commands. Create Cache for Analysis... Posted Sep 11 2007, 07:53 PM by admin with | with no comments Filed under: Analysis Services, Cache

• SSAS Partition Slicing

  Author: Eric Jacobsen Updated by Denny Lee Summary SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes... Posted Sep 11 2007, 07:45 PM by admin with | with no comments Filed under: Partitions, Analysis Services