CTS – Your Technology Partner

PowerPivot for SharePoint 2010

Written by Craig Butler on December 6, 2012

By Tim Rooks PowerPivot is the self-checkout aisle of business intelligence. Install the free PowerPivot add-in for Excel 2010 and you can import, tabulate, summarize, and otherwise slice and dice data from multiple external sources, and you don’t need a separate BI engine like SQL Server Analysis Services. Develop data models, complex calculations, and create…

Continue Reading


Reading Informatica Developer Client File Sources

Written by Craig Butler on December 6, 2012

By: Kaiesha Ford In the Informatica Developer client, there are two ways to read a file in a data object: direct and indirect. 1) Direct is used for loading one single file. 2) Indirect is used for wanting to load multiple files. For example, in the screenshot below, I have 7 files that I want…

Continue Reading


Retrieving MAX or MIN from SharePoint Lists in Reporting Services

Written by Craig Butler on December 6, 2012

I recently needed to retrieve the most recent date from a MOSS List using SSRS. SSRS has its own MOSS List connection type that uses XML to query the data, rather than SQL. The XML query does not allow for MAX or MIN functions but I was able to retrieve the most recent date as…

Continue Reading


Using SQL Server Analysis Services Dimensions and Measures

Written by Craig Butler on December 6, 2012

An OLAP Cube is composed of two different types of attributes: Dimensions and Measures. A Measure is just that – a measure of something. It can be anything numeric: hours worked, injuries reported, and workdays missed are all good examples of possible Measures. A Dimension describes the measures. For instance, Employee could be a dimension…

Continue Reading


Cognos Reporting Gotchas

Written by Craig Butler on December 6, 2012

If you are familiar with Reporting Services, or the Visual Studio IDE, then you can discover a lot of the functionality of Cognos Reporting simply by pulling up samples in the IDE, and exploring properties of the objects on the screen to see what you are allowed to change. However, a lot of things are…

Continue Reading


SSIS Package: Moving XML source from inline schema to external definition

Written by Craig Butler on December 6, 2012

Microsoft’s SQL Server Integration Services (SSIS) is an extremely useful tool for extracting, transforming and loading data from one data source to another. SSIS can support many different data sources: database, Excel, XML, etc. XML in particular is a very popular methods for transmitting data between organizations that may have different database architectures. I was…

Continue Reading


Parameter Sniffing using SQL Server 2008 R2

Written by Craig Butler on December 5, 2012

Parmeter Sniffing There was an interesting error that I had experienced recently while executing a stored procedure in SQL Server. I kept getting incorrect results when running the stored procedure, even though the statements in my stored procedure were correct. The set of results I got when running the stored procedure with parameters passed to…

Continue Reading