If you want to browse the cube and validate dimensions, hierarchies and calculations using the data from only one partition, here is what you can do. Deploy the new cube solution, run a process structure for the cube and then process only one of the partitions...

If a report does not use formatted cell values, query time can be reduced. An example is a Reporting Services report that does its own formatting and therefore would not use the formatted values from SSAS. By returning only the value of the cell and not...

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...

As you may already know from Brian Moran's SQL Server Magazine article " SQLCAT to Offer Six Sessions at PASS ", the SQLCAT team will be providing 6 SQLCAT tracks at the 2007 SQLPASS event in Denver this year. Below are the SQLCAT tracks schedule. (The...

Scale-Out Querying with Analysis Services Using SAN Snapshots