Friday, May 23, 2014
Retrieving data from a list in SharePoint Online requires a slightly different implementation than SharePoint on-prem. The following example uses C# and CSOM to retrieve data from a SharePoint Online list in an SSIS dataflow script component.
Tuesday, May 13, 2014
If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may want to group specific measures into display sub-folders. Display sub-folders help keep a cube more organized and reduce the amount of scrolling end-users need to do to locate the measures they want to add to a pivot table in Excel. As far as I am aware, there is no option to create a sub-folder from the SQL Server Data Tools GUI (without installing a 3rd party tool such as BIDS Helper). Fortunately, you can create display sub-folders without the need to install a 3rd party tool by following the steps listed below. Thanks to OpenSourceSQL.com for the original blog post on this topic.
Sunday, January 26, 2014
I bought my first power meter, a Power Tap at the start of the 2010 Tri season, which also happened to be the year I trained for my first Iron Man. Four years later and I’m getting ready to start training for my second Iron Man and figured why not upgrade Last week I got my Garmin Vector and wanted to give some first impressions and thoughts. For a complete in-depth review head over to DCRainmaker.com.
Tuesday, January 7, 2014
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge for Business Intelligence developers. Fortunately, SharePoint 2010 provides some nice features that make accessing this data a bit less onerous.
Sunday, January 5, 2014