Granting Users Access to TFS Analysis Cube

I was asked to take over a TFS installation.  Apparently, there was no one, previously, knowledgeable in administering Team Foundation Server because there were many installation and configuration issues - it was a mess.

tfs-administrators-consoleOne such issue was misassignment of user permissions.  For instance, the business needed multiple users to have access to the TFS analysis cube in order to generate reports and pivot tables in Excel. The business's solution to granting users "read" access to the cube was to grant them TFS Administrator privileges. In fact, there were over 20 users who were authorized as Team Foundation Administration Console Users.

By doing this, not only does the user have incredibly insane permissions around TFS, but they have administrative privileges (Read/Write) to the analysis cube - they would be added as a member of theTfsWarehouseAdministrator role group on the analysis server.
Read more


Atalasoft Image Viewer with Silverlight in SharePoint

I was working on a Silverlight-based BI Dashboard in SharePoint for Pfizer.  Pfizer allows the consumers of its animal products to upload receipts and Proof of Purchases in order to qualify for rebates.  The business required the ability for Silverlight to process an array of image types, including PDFs, that the consumer may upload.  Processing included not only viewing the image, but also zoom, crop and rotate.

Since Silverlight can only process JPGs or PNGs natively, I needed a third-party provider to satisfy the business requirements.  There are many libraries that render different image formats and PDFs, but I needed a single solution to handle as many formats, again, including PDFs, as possible and accomplish the image manipulation requirements.  Therefore, we decided on Atalasoft DotImage.

Read more