Archives: May 2013
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return a set of values. If you want to learn more about the SSRS lookup functions check out this blog post.
In some situations, we may want to sum the… Read more
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For example, we can define a ‘Year to Date’ calculation in a calculation dimension and it will work for any measure. Alternatively, we could define a new ‘Year to Date’ calculated… Read more