It is fairly well known that ever since SQL Server 2012, users have been able to install SQL Server Analysis Services (SSAS) in one of two modes – either “Multidimensional… Continue reading Analysis Services Power Pivot Mode in SQL Server 2016
Tag: SharePoint 2013
Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
Using Excel Services, SharePoint users have been able to share workbooks that are connected to back end data since SharePoint 2007. Typically, the connection is made to SQL Server, or… Continue reading Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
Calculate a Due Date Based on Business Hours With Nintex Workflow
More than a few times, I have come across the requirement to calculate a due date based on business hours. Recently I needed such a capability for a help desk… Continue reading Calculate a Due Date Based on Business Hours With Nintex Workflow
This Column Name is not What You Think – Be Careful With Column Names in SharePoint 2013 / Office 365
I’ve been involved with SharePoint for a very, very long time, since 2001 in fact. One of the basic truths that we old timers learned very early on was… Continue reading This Column Name is not What You Think – Be Careful With Column Names in SharePoint 2013 / Office 365
Reporting Services Web Part Error After SharePoint Upgrade
I recently completed an upgrade of SharePoint 2010 to 2013 for a customer that was using Reporting Services integrated mode fairly heavily. After the initial upgrade however, I was getting… Continue reading Reporting Services Web Part Error After SharePoint Upgrade