Welcome to Salvo(z)

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. 

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.

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.

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. 

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here.