If you target the SSRS Report Builder as an UDM client you may find the following two workarounds (aka hacks) useful. Both hacks require manually updating the SMDL definition. Alas, so much about model auto-generation L. Multi-grain Relationships Don't Appear If a dimension joins a measure group at a higher grain the corresponding Report Builder role is excluded from the model. Steps to repro: Open…
Read articleSQL Minds has released Companion for MS Analysis Server. Companion for MS Analysis Server is a product that helps with the health monitoring and performance tuning of Microsoft SSAS 2005. The product offers historical baseline, custom aggregations and their usage, meta data browsing, cube browsing, various reports on SSAS inner workings, trace information on slowest SQL, DMX, MDX and XMLA requests, processing information broken down…
Read articleThe ASP.NET ReportViewer control has a HyperlinkTarget property which may give false expectations. You may believe that this property applies to all hyperlinks, including links to drillthrough reports. For example, you may attempt to set the HyperlinkTarget to _blank to open a drillthrough report in a new window. However, you will be disappointed to find that drillthrough reports ignore the HyperlinkTarget property completely. That's because…
Read articleA little known but very useful SSRS feature which debuted in SQL Server 2005 SP2 is that the SSRS Windows service automatically upgrades the report catalog (ReportServer database) if required. As I discussed in this blog, you may need to swap the report catalog for testing or troubleshooting purposes. In the past, you had to manually upgrade the catalog from a previous version using the…
Read articleMy breakout TechEd session BIN305 - Applied Microsoft SQL Server 2005 Reporting Services is scheduled for June 4 at 10:30 AM - 11:45 AM in room S320 A. That's right – let's talk reporting right after the keynote! I hope to see some of you there.
Read articleI'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 article
