Meta
Archives
Categories
Tags
Architecture Biking BizTalk C# DataWarehousing DBA Denali IFR IIS IoC Learn To Fly Legacy log4net MadDotNet MadeInUSA MSTechEd MVC MVVM NHibernate ORM PDC PowerPivot PowerShell Racing RFID SharePoint SilverLight Sql SQL Server 2012 SSAS SSIS SSRS Tabular Models Team Build Team Foundation Server Testing Triathlon Virtualization Visual Studio WCF Windows Server WPF
Category Archives: Technology
SSAS: Currency Conversion in MDX Script
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
SSAS: Currency Conversion Using Measure Expressions
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
SQL Server 2012 Tabular Models vs. PowerPivot
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
SSIS: Using the Script Component to Obtain an Error Description
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
SSIS: Handling Truncation and Data Errors
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