I tried to answer your question in this blog: http://bisherryli.wordpress.com/2012/01/06/ssrs-65-add-row-or-column-totals-to-matrix/...

I tried to answer your question in this blog: http://bisherryli.wordpress.com/2012/01/06/ssrs-65-add-row-or-column-totals-to-matrix/...

In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries, I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your re...

In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries, I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your report server. B...

In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers, I complained about how bad the integration between Reporting Services and Analysis Services is....

In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers, I complained about how bad the integration between Reporting Services and Analysis Services is. ...

The team I recently moved into had never had a data source created on their report server for an Analysis Services source. A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data S...

The team I recently moved into had never had a data source created on their report server for an Analysis Services source. A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type. For credent...

In SSIS package design, however, I have used the Foreach Loop Container very often. I would not say that I have broken my vows though for the following reasons:...

I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop through rows record by record. In SSIS package design, however, I have used the Foreach Loop Container very often. I would not say that I have brok...