Category Archives: Database and BI

SSAS: Currency Conversion in MDX Script

Posted on February 8, 2012 by Jennifer Salvo

In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS.    I recently attempted to implement currency conversion for some inventory measures and discovered a limitation with measure expressions – they do not work … Continue reading →

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

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 , , | Leave a 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