September 2007 - Posts

Microsoft PerformancePoint Server 2007 Shipped!

Woo hoo!! Now Available


Evaluation Edition on Microsoft Download Center for everyone:


(Parent link:

·         PerformancePoint Server 2007 Evaluation Version (x86)



·         PerformancePoint Server 2007 Evaluation Version (x64)






See Documentation roadmap (when you install) for all the following information



·         What is Microsoft Office PerformancePoint Server 2007

·         News and Reviews

·         New! Interactive demo

·         New! Customer videos




·         External Support link for customers


·         Note on MSConnect and CTP4 expiry

o   MSConnect is used for CTPs only. Please upgrade to the RTM Evaluation or Enterprise editions above at the earliest. Note that CTP4 from MSConnect will be removed in a month after today.




Itay Braun

PFE - SQL Server

Veni    Vidi    Fixit

Integrate the Aggregation Manager in Business Intelligence Development Studio

Microsoft provides an Aggregation Manager sample application which gives an advanced interface for manually editing aggregations. We have taken this sample code and integrated it into BIDS Helper. This way, it can be run from Visual Studio when you're designing your cube, and aggregations you edit will be saved into your source code for the cube. (If you prefer, you can run the BIDS Helper version of Aggregation Manager live against a deployed cube if you open it through File... Open... Analysis Services Database.)

A number of bug fixes and enhancements were coded. Look at the complete list if you're interested.

To use Aggregation Manager, right click on the cube in Solution Explorer:


Then you are given windows which allow you to edit aggregations manually:


Appendix C of the performance guide provides documentation on how to use Aggregation Manager. The UI of Aggregation Manager inside BIDS is only slightly different in a few places.

Aggregation Manager can also be launched from the Partition tab of the cube designer:

( ) 


Scale-Out Querying with Analysis Services Using SAN Snapshots


Here is a new document from the SQL CAT team:

Summary: This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services to increase the number of concurrent queries to Analysis Services servers with a rapid response time per query. Load-balanced querying distributes the load of all queries among the available servers. The use of the virtual copy SAN snapshots eliminates the need to copy data between an Analysis Services processing server and one or more dedicated Analysis Services query servers. This paper supplements the Scale-Out Querying with Analysis Services white paper. 

I'm working on my own post regarding SSAS configuration and setting a performance baseline. More details soon.

Itay Braun

Veni         Vidi         Fixit



This Blog