Subscribe to this blog
Sherry Li's BI Corner
Archives: January 2013
MDX #24 – Leave out a dimension member using Except() Function
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression
Many of the MDX functions, such as NonEmpty(), Filter() and Exists(), seem to be easy enough to use, but they present quite a challenge for people with T-SQL background. The common theme among them is that they all… Read more
0 comments, 90 reads
Posted in Sherry Li's BI Corner on 17 January 2013
SSRS #73 – Use Calculated Field to Dynamically Set Default for Parameters
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 attention to it until I started to write… Read more
0 comments, 263 reads
Posted in Sherry Li's BI Corner on 4 January 2013