-
Report Builder and SSAS 2005 Known Issues
November 24, 2005 / No Comments »
The RS 2005 Report Builder can automatically create a semantic model from an SSAS 2005 cube so your end users can generate ad hoc reports. However, it turns out that some of the SSAS 2005 features are not supported by design. More information can be found in this KB article.
-
Configuration error with stylesheets and RS 2005
November 24, 2005 / 1 Comment »
If you install RS 2005 and the default web site has a web.config file that uses the new ASP.NET 2.0 themes feature, when you attempt to run the Report Manager, you will get: Theme <theme name> cannot be found in the application or global theme directories The reason for this error is that the styleSheetTheme element in the root web.config is automatically inherited by the nested web.config files. This error is not RS-specific. It happens with any nested web site because ASP.NET attempts to located that folder and apply it to the nested web site. To fix the error, break the inheritance chain by changing the styleSheeTheme in the nested Report Manager web.config file, as follows: <pages validateRequest="false" styleSheetTheme=""/>
-
Source code available
November 24, 2005 / No Comments »
The source code for my book "Applied Microsoft Analysis Services 2005" is available for download. It can also be downloaded by clicking on the Source code link found on the book resource page. To get the entire code, download the amas_all_code_in_one.zip fle. Alternatively, to get the code for a given chapter only, download the corresponding zip file. Happy holidays!
-
Reporting Services 2005 Tips and Tricks Web Seminar
November 20, 2005 / No Comments »
WindowsITPro invited me to deliver a web seminar about RS 2005. Instead of picking up a particular area and focusing solely on it, this time I will be going for a “tips and tricks” type of session which will cover new ways to do things that were difficult if not impossible to implement with RS 2000. The topics will cover the three phases of the report lifecycle – authoring, management, and delivery. Unfortunately, due to technology constraints, I won’t be able to share my desktop and do live demos. Anyway, I think it is going to be an exciting session. I hope you will be able to make it.
-
Reporting off ADO.NET datasets using the RS 2005 XML Extension
November 20, 2005 / 1 Comment »
In case you missed this little gem, RS 2005 comes with a brand new XML Extension which allows you to report off an XML data returned from an URL-addressable resource, such as an ASP.NET page or a web service. For example, suppose that you have a web method called GetOrders that return the customer orders as a typed dataset (table in my case) and has the following signature: [WebMethod] public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int customerID) You can create a report from the returned dataset by using the RS 2005 XML dataset extension: Create a data source that uses the XML extension by selecting XML as the data source type. Enter the URL address of the web service in the connection string, e.g. # Once the data source is ready, create a dataset with the following query: <Query> <Method Namespace="http://tempuri.org/" Name="GetOrders"/> <SoapAction>http://tempuri.org/GetOrders</SoapAction> <ElementPath IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath> </Query> Unfortunately, the documentation stays shy...
-
Feature Pack for Microsoft SQL Server 2005
November 9, 2005 / No Comments »
Microsoft has recently released the Feature Pack for Microsoft SQL Server 2005. The Feature Pack is a collection of standalone components that complement SQL Server 2005 offering. For example, the latest version of ADOMD.NET is included in the pack, as well as data mining control samples and Upgrade Advisor (a tool that assist you to ugprade Reporting Services, Analysis Services, and DTS to SQL Server 2005).
-
In search for scalability
November 9, 2005 / No Comments »
Just to let you know that I am aware that my website (prologika.com) is dog slo-o-o-w. I can hear my aging web server is praying for mercy from a mile. The good news is that I've just ordered a new Dell server. It sure will make a difference. It will take a few days to get and configure the server. I hope I will be able to scale before Thanksgiving. So please be patient!
-
My blog address has changed
November 7, 2005 / No Comments »
I have to apologize for the late news. I thought that I can get .Text and Community Server co-existing peacefully on the same machine, so I could post a notice of the blog address change through .Text once I am done installing and switching to the Community Server. Alas, .NET Framework 2.0 and .Text didn’t go along very well… Oops! If you read this, you already know my new blog address but for whatever it is worth, please update your readers accordingly. The next time I will be less excited with upgrades J
-
SQL Server 2005 LoadFest
November 2, 2005 / No Comments »
Atlanta.mdf is hosting a LoadFest event to celibrate the launch of SQL Server 2005. They asked me to stop by and answer tough Business Intelligence questions.. Time permitting, I may do a demo or two. You may also put in your calendar my next presentation for Atlanta.mdf on 9/1/2006 when I will talk about Analysis Services 2005. See ya there!
-
SQL Pass 2005 slides and code
October 5, 2005 / No Comments »
SQL Pass 2005 was a great show. It had about 2,000 attendees, which is great si nce you don’t feel disconnected in the TechEd crowd of 13,000 people. I did a “RS Tips, Tricks, and Gotchas” presentation with Bruce L-C whom I finally had a chance to meet. I think the presentation went very well. I’ve uploaded the slides and the sample code to my website. Among other things the code demonstrates: Excel export scenarios CSV export External images streamed from a web service Expression-based connection strings CLR stored procedures HTTP handler for intercepting the incoming traffic to the server And more… Happy reporting!
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!
