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.