Author Archives: Jennifer Salvo

SSAS: Currency Conversion Using Measure Expressions

Posted on February 1, 2012 by Jennifer Salvo

Currency conversions can be implemented several ways as part of a business intelligence solution.  In some scenarios it may be preferable to implement the conversion in the ETL, while in other scenarios it might make more sense to implement the … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SQL Server 2012 Tabular Models vs. PowerPivot

Posted on January 15, 2012 by Jennifer Salvo

I recently installed SQL Server 2012 and began exploring the tabular models.  At first glance, they look very similar to PowerPivot and contain much of the same functionality.  In fact, both the tabular model and PowerPivot share the same engine … Continue reading →

Posted in Database and BI, Technology | Tagged , , | 1 Comment

SSIS: Using the Script Component to Obtain an Error Description

Posted on December 27, 2011 by Jennifer Salvo

In the SSIS data flow, many data flow components provide an ErrorOutput that allows you to route rows that generate errors or truncation to another component in the data flow.  The ErrorOutput path contains the following metadata: ErrorCode, ErrorColumn and … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SSIS: Handling Truncation and Data Errors

Posted on December 27, 2011 by Jennifer Salvo

SSIS provides functionality to handle unexpected data in the data flow.  Data flow errors are often due to invalid data values (e.g. string instead of number) and data truncation.  Many components in the data flow support error outputs that allow … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SSRS: Checking for Divide By Zero Using Custom Code

Posted on November 25, 2011 by Jennifer Salvo

I encountered a divide-by-zero error while working on an SSRS report and thought the issue could easily be resolved using IIF with code similar to the following: =IIF(Fields!Denominator.Value = 0, 0, Fields!Numerator.Value/Fields!Denominator.Value) I soon realized that this does not resolve … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment