Microsoft’s Performance Management Gambit
An interesting article on TDWI about PerformancePoint Server.
PerformancePoint Server Announced
As a follow-up to previous post, during the webcast Microsoft announced a new product called PerformancePoint Server due to be released in mid-2007 alongside Office 2007. PerformancePoint will be a convergent product of Scorecard Manager, ProClarity, and Biz# (yes, Microsoft finally let the cat out of the bag about the strictly confidential so far Biz# initiative). The product will be designed as a web-based portal and will offer performance management, planning and forecasting capabilities.
I personally very excited about this new product offering. PerformancePoint will definately help Microsoft to compete better with other heavy-weight BI players, such as Cognos. More information about PerformancePoint can be found on its website.
Microsoft’s Business Intelligence Product Roadmap Webcast
Jeff Raikes, President of Microsoft’s Business Division and Lewis Levin, Corporate Vice President of Microsoft’s Office Business Applications Group, will present a Live Meeting webcast at 11 am (PDT) regarding Microsoft’s Business Intelligence product roadmap. Click here to register.
MDX Performance Tips Article
I found a short but very useful MDX Performance article on sqlserveranalysisservices.com. I know I am guilty of breaking not once the first rule (Don’t Filter on Member Property Values). Maintained by Richard Tkachuk (Lead Program Manager on the SSAS team), this site offers other interesting tips and insights.
Cumulative hotfix package (build 2153) for SQL Server 2005 is available
Microsoft has released a post-SP1 hotfix which addresses various bugs and issues in SQL Server 2005 and its add-on services.
Create Reports from Any Data Source Using SQL Server Reporting Services Custom Data Extensions
DevX published my article “Create Reports from Any Data Source Using SQL Server Reporting Services Custom Data Extensions”. Learn how to develop a custom data extension to bind server reports to ADO.NET datasets.
Custom Report Items (When You Are Too Sexy For Standard Report Items)
One of the most exciting (but not well known and documented) extensibility areas of SSRS 2005 is custom report items (CRI). As its name suggests, custom report items allow you to implement your own reporting controls when the standard SSRS report items (textbox, chart, table, matrix, etc.) are not enough. For example, the attached screenshot shows a report that uses a CRI I wrote to show a KPI value graphically.
If you have experience in developing Windows Forms .NET controls, you will feel immediately at home with CRI. In fact, I dare say that you can take the GDI+ source code of any Windows Forms.NET control and convert it easily to an SSRS CRI. As you can imagine, it won’t be long before third-party vendors come up with all sorts of cool SSRS widgets.
If you want to learn more about CRI, check out the PolygonsCRI sample which Chris Hays wrote. It is included with the latest refresh of the SQL Server 2005 samples. I have an article in the works for MSDN Magazine that explains the implementation details of a progress tracker CRI.. I will post an update here when the article is available (most likely July-August issue of MSDN Magazine).
SQL Server 2005 Samples and Sample Databases April 2006 Refresh
Download the April 2006 refresh of the SQL Server 2005 samples and databases.
SQL Server 2005 SP1 Released
SQL Server 2005 SP1 was released yesterday. Kudos to Microsoft for releasing SP1 on time!
As the conventional wisdom goes, one should postpone deployment of production applications until the first service pack has been released. Well, that time has come to pass. May your SQL Server 2005-based solutions be successful!
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
