-
Kudos to Report Builder as UDM Client
January 11, 2007 / 4 Comments »
Its UDM support limitations withstanding (a partial list here), the Report Builder should definitely be on your list if your requirements call for ad-hoc reporting from an SSAS 2005 cube. Here are some Report Builder features that I particularly like: Ability to pre-filter the data on the report before the report is run. In comparison, Excel takes the optimistic approach to load all dimension members before allowing you to set a filter. This can surely send Excel in a la-la land if your cube has large dimensions (hundred thousand or more). Support of calculated columns. For some obscure reasons, the Excel UI doesn't have an UI interface for creating calculated members (you can do so programmatically however). Standard report look and feel. In comparison, Excel limits the user to the PivotTable fixed layout (assuming that the user doesn't convert the report to formulas). My Reports which allows the business user...
-
Report Viewer Enhancements in VS.NET 2005 SP1
December 20, 2006 / No Comments »
As you probably know by now, Microsoft has recently released Service Pack 1 of Visual Studio.NET 2005. Since the Report Viewer controls are owned by the VS.NET team, it turned out that they have been updated also. Many bug fixes have been implemented. The new features include: Report Viewer ASP.NET Control Enhancements Reset method to reset the control to its default values. Both ASP.NET and Windows Forms versions ServerReport.Cookies property to pass cookies to the server (useful if the Report Server is configured for custom security). ServerReport.Headers property to pass custom HTTP headers to the server (useful if the Report Server is configured for custom security). New (currently undocumented) IReportViewerMessages2 interface for localizing additional menu strings that were not covered by the original IReportViewerMessages interface. Strangely, VS.NET 2005 SP1 doesn't update the product documentation (perhaps, the next edition of MSDN library will) so you need to rely on the online documentation. How...
-
CTP3 Build of SQL Server 2005 Service Pack 2 Released
December 20, 2006 / No Comments »
In the spirit of the season, the SQL Server team give us the third (and probably last before the final release) CTP3 build (version 9.00.3033.0000) for the forthcoming SQL Server 2005 Service Pack 2.
-
SQL Server 2005 Samples and Sample Databases (December 2006)
December 9, 2006 / No Comments »
The December 2006 edition of the SQL Server 2005 Samples and Database is available for download.
-
Losing Identity
December 1, 2006 / 1 Comment »
After installing CTP2 of SQL Server 2005 SP2, I started getting a rather annoying exception when attempting to launch the Report Builder. An application for this deployment is already installed with a different application identity. I've noticed that this happens when I run the Report Builder form a server that has CTP2 installed and then I run it from my local machine that doesn't have CTP2 installed. While I wasn't able to find what's causing ClickOnce to lose identity, the workaround I found was to nuke the Report Builder download folders as follows: Open Windows Explorer and navigate to C:\Documents and Settings\<your user name>\Local Settings\Apps\2.0 Delete all folders below the folder except the Data folder.
-
SSRS-SharePoint Integration in SP2 (the Good, the Bad, and the Ugly)
November 26, 2006 / 4 Comments »
As noted before, a major SSRS enhancement in the SQL Server 2005 Service Pack 2 is integration with SharePoint v3.0 and Microsoft Office SharePoint Server. After the RTM release of SQL Server 2005, the SSRS team has been hard at work to implement this feature. Starting with the newly released CTP2 build of SQL Server 2005 Service Pack 2, the SharePoint integration mode is available for public review and testing. Here are my initial high-level observations after testing the SSRS SharePoint integration in CTP2. The Good Integrating reports in dashboards and portals is an increasingly popular requirement. It is obvious that the major design goal that the RS team has set up from the get-go was a seamless integration between SSRS and SharePoint. Many changes were made to the SSRS architectural stack to materialize this goal. The final result speaks for itself (see attached screenshot ). Once the Report Server...
-
SharePoint Services 3.0 Released
November 22, 2006 / No Comments »
Download location: http://www.microsoft.com/technet/windowsserver/sharepoint/download.mspx Demo: http://office.microsoft.com/en-us/sharepointtechnology/HA102055631033.aspx
-
Report Snapshots and rsReportNotReady
November 13, 2006 / No Comments »
Two very useful features of Reporting Services (version 2000 and above) are snapshot execution and report history. Snapshot execution allows you to cache the report execution. Optionally, you can keep the cached reports in history, e.g. if the user wants to keep a copy of the report for historical analysis. Once a report is enabled for snapshot execution, you can generate the history snapshot by invoking the CreateReportHistorySnapshot API assuming you need to do so programmatically, e.g.: historyID = managementProxy.CreateReportHistorySnapshot(reportPath, out warnings); However, if your code just calls CreateReportHistorySnapshot and the end user requests the report by clicking on the report link in the Report Manager or SharePoint (if the server is configured for SPS integration with SQL Server 2005 SP2), the user will get: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady) This error is...
-
Visual Studio 2005 Team Edition for Database Professionals
November 11, 2006 / No Comments »
The newly released CTP7 of Visual Studio 2005 Team Edition for Database Professionals (aka DataDude) now supports bi-directional schema updates. Once you generate the scripts from your database schema, you can choose either the database or the scripts as a source of changes and commit the changes to the target. Visual Studio 2005 Team Edition for Database Professionals requires Visual Studio 2005 Team Edition.
-
SQL Server 2005 SP2 CTP 2 Build Released Today
November 8, 2006 / No Comments »
The second CTP (Community Technology Preview) build of the forthcoming SQL Server 2005 Service Pack 2 was released today. Besides bug fixes, SP2 includes major BI features and enhancements including: Reporting Services SharePoint 2007 integration – this one is a true enzilla (enhancement Godzilla) and deserves a separate post. Suffice to say that unlike the previous Explorer and Viewer webparts, SP2 will allow you to move the report catalog to SharePoint to enable publishing, viewing, and managing SSRS 2005 reports within SharePoint 2007. Report Builder support for Oracle 9.2.0.3 or above (previously only SQL Server and Analysis Services 2005 were supported for Report Builder models) New .NET Data Provider for Hyperion 9.3 BI+ Essbase Enterprise Analytics Select All option has been restored with multi-valued parameters (it was disabled in SP1 for performance reasons). Analysis Services Better Excel 2007 integration – advanced filtering, cube formulas, offline cubes. Data mining add-ins for...
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.
