Radim.NETRadim Hampel : Microsoft business intelligence, performance management and data warehousingMS decided to ship SP3 for SQL Server 2005- April 16, 2008 After lot of demands from user community (https:connect.microsoft.comSQLServerfeedbackViewFeedback.aspxFeedbackID=326575) MS finally decided to create SP3 for SQL Server 2005. It will be shipped after official launch of SQL2008, but still we should see SP3 in 2008. That's a good news, because all Cumulative Updates (new CU7 was published two days ago http:support.microsoft.comkb949095en-us) were not recommended to install and SP2 brought a lot of problems with it. I really hope that SP3 will...http://blog.vyvojar.cz/radim/archive/2008/04/16/ms-decided-to-ship-sp3-for-sql-server-2005... Analysis Services partition slice- April 16, 2008 When you have more than one partition in your cube, you should consider using Slice property(highlight your partition and you will find Slice in its Properties window). Slice information is used at query time, when queried members are sequentially compared against all partition for possible inclusion. This helps to skip partitions which don't keep data for current query. Slice can be either set by developer or (in case of MOLAP storage) it is recognized by Analysis Services automatically,...http://blog.vyvojar.cz/radim/archive/2008/04/16/analysis-services-partition-slice.aspx Passing MDX parameters in Reporting Services reports- April 8, 2008 A common requirement in reporting applications is to drill down from parent report into details about selected part of the report. Reporting Services provides a handful of such navigation options, more specifically jump to report, jump to bookmark and jump to url. In my example I use jump to report option and from parent report (Top 10 products) I can drill down to sales details of selected product. Now, with relational data source I'd probably fetch ProductID and ProductName and I'd pass them..http://blog.vyvojar.cz/radim/archive/2008/04/08/Passing-MDX-parameters-in-Reporting-Servic... |