-
Chris Webb, a fellow MVP and MDX guru, who's blog is a must-read for all SSAS junkies, was kind enough to let me take a look at the Intelligencia Query product he's been working on for a while with Andrew Wiles. Chris announced the product back...
-
Scenario You won't enable SSAS HTTP connectivity via a SharePoint site. Issue You followed the instructions in the Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 whitepaper but you get " Failed to...
-
Scenario You need to configure a SharePoint site integrated with Reporting Services for Internet access. In our case, the end users would authenticate with Windows security by using local Windows account created on the web server. Issues Report URLs reference...
-
Q: How to make the darn parameter drop-down list wider in HTMLViewer? HTMLViewer is the Report Manager control that displays the report when you view the report. A: HTMLViewer supports limited customization via a CSS stylesheet. Copy HTMLViewer.css to...
-
This is not an April's fool joke. I am excited to make an early announcement about my next book , Applied Microsoft SQL Server 2008 Reporting Services, which has been keeping me busy lately. There are many exciting features coming up the next (third...
-
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...
-
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...
-
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...
-
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...
-
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 27 th marketing launch date remains unchanged.
-
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...
-
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...
-
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...
-
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...
-
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...