Musings on Data

A blog for data, apis, and all things Power BI by Lukasz Pawlowski.

April, 2007

  • Musings on Data

    Using Multi-Value Parameters Programmatically

    • 0 Comments
    It seems there is a ton on confusion about how to programmatically use multi-value parameters. Here's how to do it using the SOAP API for report execution: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1515942&SiteID=1 Here's how to do it in subscriptions: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1233857&SiteID=1 Here's how to do it using expressions inside a report: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=161179&SiteID=1 Now, just for your inner geek, here's a treatment of how NULLs work in multi-value parameters (they don't, but this post includes some work arounds): http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379668&SiteID=1 (Update 04/25)...
  • Musings on Data

    Reliability through isolation

    • 0 Comments
    Reporting Services is an example of a system that both handles interactive user load and schedule load. It is also allows interactive users to schedule reports. A poor scheduling decision on the part of one user can can have significant impact on the overall responsiveness and reliability of your Reporting Services deployment. As an administrator when you plan your load, you want to ensure interactive user request responsiveness does not diminish due to recurring scheduled load. The report server provides a neat way to ensure scheduled load does not impact interactive load at all. First, let me say you'll need two instances of report server running in a scale-out deployment. This means you'll need Enterprise edition. So obviously this solution...
Page 1 of 1 (2 items)