Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface design, so this pretty useful feature stayed hidden from me until version 2008. Even in SSRS 2008, I did not pay much attent...

Your observation about the composite key causing the empty result is correct. I'd suggest two ways to fix the problem. First way: continue to the CompanyID as report parameter, but take two key values as parameters now 1) you will need to modif...

Almost every tool we learned has some sort of “Hello World!” tutorial lesson. So here comes the “Hello World!” lesson in MDX. Putting “Hello World!” directly on the X axis doesn’t work You would think this query would work, by putting “Hello World!” dir...

I often think that I am lucky to work in a profession that I enjoy very much. It makes everything I do a fun thing to do. Majority of the fun comes from the fact that I have my hands in almost every aspect of building a data warehouse. From business ana...

I often think that I am lucky to work in a profession that I enjoy very much. It makes everything I do a fun thing to do. Majority of the fun comes from the fact that I have my hands in almost every aspect of building a data warehouse. From business ana...

I am not aware of any out-of-box capability in SSRS for the data-driven subscription query to be dynamic. Sherry...

ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods ParallelPeriod() function is often used when we need to present data side-by-side for two parallel periods, such as in the example below where d...

Need to check the last time when our ETL processes ran successfully Data warehouse developers routinely query the last data date (the last date when we have fact data) to check the last time when our ETL processes ran successfully. It’s not hard to d...

Need to check the last time when our ETL processes ran successfully Data warehouse developers routinely query the last data date (the last date when we have fact data) to check the last time when our ETL processes ran successfully. It’s not hard to do ...

ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods ParallelPeriod() function is often used when we need to present data side-by-side for two parallel periods, such as in the example below where da...