Browse by Tags

• 2008
• 2008 R2
• Best Practices
• Business Intelligence
• Integration Services
• MDX
• OLAP
• PASS
• SSAS
• SSIS

• Reporting Services, MDX and the (unwanted) cascading parameters

  Reporting Services can be used in conjunction with Analysis Services, creating powerful reporting solution that can satisfy almost  any customer needs for “standard” reporting. For “standard” I mean solutions that has not be created using Excel and Read More... Posted Tuesday, August 10, 2010 10:21 PM by Davide Mauri | 13 Comments Filed under: Reporting Services, MDX, SSAS

• PASS Summit 2010 – BI Workshop

  PASS Summit 2010 Pre & Post conference are out ! This year I’ll deliver the “ Creating BI Solution from A to Z ” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional Read More... Posted Wednesday, June 30, 2010 3:01 PM by Davide Mauri | 1 Comments Filed under: SSIS, Integration Services, Reporting Services, Business Intelligence, 2008, PASS, MDX, OLAP, 2008 R2, Best Practices

• Custom Aggregations Values in SQL Reporting Services with Tablix Filters

  In these last days I’ve been working on a BI solution for a logistic company. One report I have to create has a particular behavior that can make life a little complex if you’re using Reporting Services: the value used in rows and column totals is not calculated in any way, but is just taken from the database (SSAS in this case), just like any other cell value. Read More... Posted Friday, July 24, 2009 4:20 PM by Davide Mauri | 0 Comments Filed under: Reporting Services