I've added two more RS blogs to the Reporting Services link section. The Reporting Services Team blog is used by the RS team as a whole. The Reporting Services User Education blog is used by the education group on the Reporting Services team. It's managed by a former colleague and friend of mine, Matt Mayer, who joined the Reporting Services team a year ago. The entire…
Read articleThe March release of SQL Server 2005 samples is available for download. Note that Microsoft has moved all SQL Server 2005 samples (standard and open source) to the CodePlex website. The documentation is still on MSDN. So, GotDotNet is dead, long live CodePlex!
Read articleIf you follow the Microsoft .NET roadmap, you have probably heard about the forthcoming Language Integrated Query (LINQ) in .NET 3.0. LINQ will add query capabilities directly into the CLR and will be supported by both VB.Net and C#. This means that you will be able to use standard query operators directly from within your code! To help you get started with LINQ, Marco Russo…
Read articleI had an interesting issue this week. I was working on a small test cube with financial data. The lowest grain in the measure group was the Account dimension which represents a customer bank account. I had to implement rolling 12 calculations on semi-additive measures (e.g. Avg Account Balance) by weighting the balances at the account level:Rolling 12 Bal = ∑(Number of Account Active Days…
Read articleThanks for Russell Christopher's blog, I've learned that Microsoft donated an Analysis Services Load Simulator (ASLoadSim) sample project which lets you load test Analysis Services using the VS.NET 2005 test capabilities. While I am to try the code sample, I am very impressed by the whitepaper included in the sample which got harvested from Project REAL. Chris Webb also contributed in the SSAS performance area…
Read articleMicrosoft has released a cumulative update package (build 3161) for SQL Server 2005 SP2. Among other things, the update package fixes the SSRS black preview.
Read articleNick Barclay is telling us that the book The Rational Guide to Microsoft Office Business Scorecard Manager 2005 that he co-wrote with Adrian Downes is out! You can use BSM to design scorecards that can be published to SharePoint dashboards or SSRS reports. As far as I know, this is the first BSM book which makes it even more appealing.
Read articleA bit outdated announcement perhaps but the Office team has released a Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables whitepaper. Instead of pestering you with how-to PivotTable questions, now your users can have proper documentation. A great deal of it discusses UDM implementation details but who is to say that you didn't travel the extra mile… As for me, well I…
Read article
I've been having fun lately with a dashboard page which has an Excel Web Access (EWA) web part connected to a PivotTable report. The PivotTable report is nothing to brag about. It displays a few KPI-related measures coming from an SSAS cube. PivotTable was converted to formulas to achieve a free-form report layout. So far, pretty straightforward stuff. That is, until the customer wanted the…
Read article
