Earlier this year, while building an SSRS report against a Cube data source, I got stuck trying to parameterize the dimension attribute on the rows axis of the dataset query. What I wanted was to … Continue reading SSRS + MDX: Dynamic Dimension Attribute on Row Axis
Earlier this week, one of the client’s routine SQL agent jobs failed during an Analysis Services processing task with the following error message: Error: 2013-07-18 10:27:36.18 Code: 0xC1020041 Source: Process Dimensions Analysis Services Execute DDL … Continue reading Why You Need to Routinely ProcessFull
As a self-proclaimed lover of data, it should be no surprise that I’m a huge fan of Big Data. But, like many other data professionals, I am sometimes frustrated by the misconceptions and misrepresentations that come … Continue reading What Does Big Data Mean to You?
A lot of times, when creating SSRS reports, I find myself wanting to copy/paste existing objects from the report data window (ex. parameters, data sources, and datasets) either to create duplicates in the same report … Continue reading How to Create a Copy of an SSRS Dataset
This weekend, on the way home from a nice few days at the beach with family, I was listening to a SQLBitsX session (A Lap Around the SSIS Catalog) by Jamie Thomson (b | t) and … Continue reading Reporting Against the SSIS 2012 Catalog
Earlier this month, I spent an entire week evaluating WhereScape RED with a new client. If you’ve never heard of it, RED is a platform for rapid data warehouse development. Admittedly, I’ve always been skeptical … Continue reading Rapid DW Development with WhereScape RED