Browse by Tags

• BI
• BIDS Helper
• Business Intelligence
• Expressions
• Iif()
• InScope()
• Layout
• Lookup Transformation
• Matrix
• MDX
• Rendering reports
• Row height
• SQL Server 2005
• SQL Server 2008
• SQL Server Analysis Services
• SQL Server Integration Services
• SQL Server Reporting Services
• SSAS
• SSIS
• SSIS Caching
• SSRS
• Subtotal

• SSIS – Lookup Transformation is case sensitive

  How can you safely use the lookup component…?... Posted Feb 12 2008, 04:34 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, Business Intelligence, BIDS, SSIS, BI, Lookup Transformation, SSIS Caching

• SSRS – Static column headers in a Matrix

  If you create a matrix with dynamic columns you can create one static heading column over top of your dynamic columns…... Posted Dec 12 2007, 04:36 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, BI

• SSRS - Custom expressions for subtotals in a matrix

  If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the default sum, you need to use the InScope() and Iif() functions in your data field…... Posted Dec 06 2007, 03:14 PM by jorg with | with 5 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, InScope(), Iif(), Subtotal

• SSRS – Matrix that adds a new column each time 5 rows are filled with data

  What if you want a dynamic list of values in a matrix but with a maximum of 5 rows. How do you create a matrix like this? I thought this should be an easy job but I found out it was not really simple…... Posted Nov 23 2007, 05:26 PM by jorg with | with no comments Filed under: SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, MDX

• SSRS – Invalid row heights, BUG?

  It seems that SSRS renders row heights of matrices wrong when a row contains one or more empty cells. This can be solved by changing the padding property…... Posted Nov 19 2007, 10:56 PM by jorg with | with no comments Filed under: SQL Server 2005, SQL Server Reporting Services, BIDS, Rendering reports, Layout, Row height, SSRS

• SSAS 2005 - Visualize Attribute Relationships

  SQL Server 2008 has a new feature that visualizes your attribute relationships in SSIS. This feature is also available for SQL Server 2005 with BIDS Helper…... Posted Nov 16 2007, 01:03 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server 2008, SQL Server Analysis Services, BIDS, BIDS Helper, SSAS