-
Microsoft PerformancePoint Server 2007 Shipped!
-
Woo hoo!! Now Available
Evaluation Edition on Microsoft Download Center for everyone:
(Parent link: http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&productID=F52B1E9C-E169-4654-9A83-14A58A51C275)
· PerformancePoint Server 2007 Evaluation Version (x86)
o http://www.microsoft.com/downloads/details.aspx?FamilyId=6372C24F-67DD-42DD-B034-748907B23420&displaylang=en
· PerformancePoint Server 2007 Evaluation Version (x64)
o http://www.microsoft.com/downloads/details.aspx?FamilyId=3ADAC793-DEF0-4BA8-A9AB-228979B8DB40&displaylang=en
Documentation
See Documentation roadmap (when you install) for all the following information
- On the base install: All context-sensitive help and base product documentation including conceptual information and procedures. Also contains links to the following.
- On Office Online: Links to README and other useful information
- On TechNet: For the IT pro - Deployment Guide, Operations Guide, Whitepapers
- On MSDN: For the Developer - Planning Server, Business rules development guide and Monitoring SDK
· What is Microsoft Office PerformancePoint Server 2007
· News and Reviews
· New! Interactive demo
· New! Customer videos
Support
· External Support link for customers
o https://support.microsoft.com/common/international.aspx?rdpath=1&gprid=12922&c1=508
· 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.
Cheers,
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:

(http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Aggregation%20Manager&referringTitle=Home )
-
Scale-Out Querying with Analysis Services Using SAN Snapshots
-
Hi
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.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7ac8e03d-bf1f-4733-93e0-bc0f6e567608&DisplayLang=en
I'm working on my own post regarding SSAS configuration and setting a performance baseline. More details soon.
Itay Braun
Veni Vidi Fixit