• Applied Microsoft Analysis Services 2005 Goes E-Book

    March 27, 2008 / No Comments »

    I happy to announce my book "Applied Microsoft Analysis Services 2005" is now available as an Adobe PDF e-book. The first retailer that Google Alerts reported to sell it is Diesel Ebooks. It should soon pop up on all popular ebook retailer sites, such as ebooks.com. The suggested retail price for the ebook version is set to $39.95, which is ten bucks cheaper than the suggested retail price of the paper copy. The ebook is DRM-protected but fully functional with unlimited printing and copying capabilities. The DRM protection is handled by the retailer. Since the distributor is not set up to handle different pricing models, such as buy the paper copy and get the ebook free, there is no discount pricing model for the e-book version at this time. Also, the same book is now available on Amazon Kindle. Since I don't have an Amazon Kindle, I don't know what...

  • The Rational Guide To Planning with Microsoft Office PerformancePoint Server 2007

    March 15, 2008 / No Comments »

    I have to admit that my preoccupation with Reporting Services and Analysis Services don't leave me much bandwidth nowadays to tackle other Microsoft BI (far less third-party) offerings. One of the products I know I need to catch up is the planning component of PerformanceServer, formerly known as Biz#. Fortunately, Nick and Adrian followed up on their The Rational Guide To Planning with Microsoft Office PerformancePoint Server 2007, which I wrote about, with a new book The Rational Guide To Planning with Microsoft Office PerformancePoint Server 2007. Initially, they were planning a single PerformancePoint book but they decided to split it because of book size limitations that the publisher has. The planning piece of PerformancePoint requires more than solid knowledge of Analysis Services because of its strong financial focus. You need to know quite a bit about budgeting, planning, chart of accounts, and other financial concepts. Fortunately, The Rational Guide...

  • SQL Server 2008 February CTP Is Out

    February 22, 2008 / 1 Comment »

    February CTP is out. It brings the much anticipated integration with Visual Studio 2008 and the new BIDS Report Designer. Download the February CTP here: http://www.microsoft.com/sql/2008/prodinfo/download.mspx Updated Books Online for February CTP are available here: http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en What's new in Reporting Services February CTP (compared to the previous November 2007 CTP): Support for Microsoft Word Rendering This allows users to render reports as Word documents that are compatible with Microsoft Word 2000 and greater. Data Visualization Enhancements Data Visualization Enhancements provides significantly improved support for Chart and adds support for Gauge controls directly within reports. SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report rendering, processing and management capabilities in SharePoint Integrated mode.  This version includes Data-driven subscriptions. Report Design Enhancements in Business Intelligence Development Studio (BIDS) BIDS overall has...

  • Last Non Empty Affairs

    February 6, 2008 / No Comments »

    Enterprise Edition of Analysis Services 2005 and 2008 supports semi-additive functions, such as LastNonEmpty, LastChild, and so on, to facilitate working with semi-additive measures, such as account balances and inventory snapshots. For example, the screenshot below shows LastNonEmtpy in action. To demonstrate this, I added a Last Sales measure to the Internet Sales measure group in the Adventure Works cube and set its AggregationFunction property to LastNonEmpty. Of course, this doesn't make much sense because sales amounts are fully additive but it's OK for demo purposes. As expected, the quarter and year totals show the last non empty sales. The customer totals are correct too because semi-additive measures sum across any dimension except Time. But what about the grand total of $14.98? Shouldn't we get the sum of the quarter (or year) subtotals? To answer this question, we need to understand how LastNonEmpty operates. LastNonEmtpy works across time and not...

  • SQL Server 2008 Expected Q3 2008

    January 25, 2008 / 1 Comment »

    Francois Ajenstat, Director of Product Management for Microsoft SQL Server, tells us that SQL Server 2008 will be released in Q3 2008 while Release Candidate (RC) is expected in Q2. The February 27th marketing launch date remains unchanged.

  • Where Are Report Server Content Types Gone?

    January 13, 2008 / No Comments »

    SharePoint always has a trick up its sleeve to surprise the innocent. I have to admit that I continue to be baffled by this technology. Not that I know too much about it, of course. But this thing is like the Pacific Ocean – web applications, site collections, sites, oh my. The further you go, the deeper it gets. Things that still escape my mind include how to get the default Office Server web site (with the Report Center, etc.) after upgrading from WSS 3.0, why I cannot implement custom SharePoint filter provider web parts in WSS given that the interfaces are in WSS, and the mother of all questions, why WSS supports Windows Server OS only. One thing, however, I managed to figure out (of course, after hours of experimenting, installing, and head-scratching since documentation is, shall we say, wanting) is how to get the Report Server content types...

  • Trying to Communicate

    December 23, 2007 / No Comments »

    Visual Studio 2008 embraces the exciting new world of Windows Communication Foundation (WCF) for communicating with services. However, pitfalls await the unwary. I've recently tackled invoking the Reporting Services Web service with WCF and I want to share my findings. The Visual Studio Add Web Reference menu has been renamed to Add Service Reference to denote that WCF can communicate with much more than Web services, including probably my Zune device. Although the dialog has somewhat changed, you will be find your way to generate the proxy. What's more surprising is that the auto-generated proxy methods now have somewhat different signatures. For example, the SQL Server Books Online has the following signature of the Reporting Services GetExecution Options API. public ExecutionSettingEnum GetExecutionOptions (string Report,out ScheduleDefinitionOrReference Item); Yet, WCF generates the following signature: public ServerInfoHeader GetExecutionOptions(string Report, out ExecutionSettingEnum executionOption, out ScheduleDefinitionOrReference Item); So, the returned value becomes an out parameter...

  • Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques Whitepaper Available

    December 22, 2007 / No Comments »

    The Microsoft CAT team has released a new whitepaper Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques. "Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services to resolve many-to-many queries. This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique. It demonstrates that optimizing many-to-many relationships by compressing the common relationships between the many-to-many dimension and the data measure group, and then defining aggregations on both the data measure group and the intermediate measure group yields the best query performance. The results show dramatic improvement in the performance of many-to-many queries as the reduction in size of the intermediate measure group...

  • Brian Welcker Leaving SSRS

    December 17, 2007 / No Comments »

    As he posted here, Brian Welcker (Group Program Manager of Reporting Services) is leaving the Reporting Services team and moving to the Microsoft Healthcare Solutions Group. Brian did so much to build and promote Reporting Services. SSRS wouldn't have been the same if it wasn't for Brian. The technical community (myself included) will surely miss him. Let's wish Brian good luck with his new career!

  • Relational Guide to Monitoring and Analyzing with Microsoft Office PerformancePoint Server 2007

    December 16, 2007 / No Comments »

    As you know, business scorecards are the latest BI craze. Nick Barclay was kind enough to send me a copy of his new book Monitoring and Analyzing with Microsoft Office PerformancePoint Server 2007 by Rational Press which he co-authored with a co-worker and friend Adrian Downes. This is one of these relatively-small and very practical books which helps you hit the ground running quickly. As its name suggests, the book focuses only on the monitoring and analyzing piece of PerformancePoint which was previously known as Business Scorecard Manager. Nick and Adrian wrote another book, the Rational Guide to Planning with Microsoft Office PerformancePoint Server 2007, which covers the Biz# portion of the product. I liked the author style and the practical examples included in the book. The authors show you how to build scorecards from a variety of data sources and deploy them to SharePoint or Reporting Services reports. I...

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.
For more information or to register click here!

Books

Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Syndication