MS SQL Server 2016 promises some key updates for Master Data Services including sharing entities between models, publishing multiple versions of data in the same subscription view, and increased functionality in the Excel add-in. Among other things there is a plethora…
MS SQL Server 2012 Master Data Services – list all user / group permissions using TSQL
While implementing Master Data for a company in the finance industry, some limitations around the Web permissions interface became an issue. How could I get a list of all users / Active Directory Groups and their permissions per master data…
PowerPivot – “Data overflow converting to the data type for table ‘68868d91-787b-49fa-bb65-fa1cc475c3c8’ column ‘Tape_Date’.”
If you’re trying to open a workbook from the SharePoint 2010 PowerPivot Gallery and you get this error: Data overflow converting to the data type for table ‘xxxxxxxxxxxxx’ column ‘Tape_Date’.” This is Excel Services saying that the PowerPivot Workbook is…
Getting started with Master Data Services in SQL Server 2012
Setting up MDS in a 2012 environment isn’t the most straight forward process. 2 issues I encountered while configuring on a standalone Hyper-V VM were IIS related, plus sample MDS package deployment. The following links will help to make the…
More BI videos – Ad-hoc reports, Data Mining
Data Mining: http://youtu.be/YrnD46xMFNk Ad-hoc reports : http://youtu.be/RWjUYpwOx70
SQL Server Business Intelligence – PowerPivot
MS SQL Server 2008 R2 Business Intelligence: PowerPivot http://youtu.be/hDCTr0AsGOg another vid
SQL Server Business Intelligence – Maps Integration
MS SQL Server 2008 R2 Business Intelligence: Maps Integration http://youtu.be/7Ukl6h06YDc A video I put together regarding Maps integration and MS SQL Server.
PowerPivot…
…is only supported by Excel 2010. While the Data mining add in will work with Excel 2007, Powerpivot will not.