By Bill Anton on May 16th, 2012 // No Comments
The following information is the first of a two-part piece on the new Analysis Services Tabular option available in Microsoft SQL Server 2012.
Before we dig into the actual development process, I’d first like to provide some context to help promote a good understanding of how this new technology fits in with the Microsoft business intelligence analytics stack and why it’s going to be a big deal to companies interested in leveraging business intelligence going forward. In part two, we’...
Continue Reading
By Chuck Rivel on October 13th, 2011 // No Comments
Scenario I have been asked on numerous occasions to provide a data feed that provides data for a customer, or plant or some other entity with a catch, can you take a one to many relationship and make one column of data out of it. That answer, of course, is “Sure, I can do anything!” but then I get into the how and I start to build a stored procedure that uses temp tables, involves a WHILE loop of some kind and I have to manually code the correct answer. The process is nothing complicat...
Continue Reading
By Chris on October 3rd, 2011 // No Comments
Problem Requirements on a recent project called for a cloud-based solution and support for a lot of data. Microsoft Windows Azure was selected as the platform and Microsoft SQL Azure was selected for the database. How much is a lot of data? It was expected to be much greater than 50GB. Now we had a problem, since the maximum size of a SQL Azure database was 50GB and SQL Azure Federation has not yet been released. Solution An additional technical requirement for the solution was to ...
Continue Reading
By Ahmed Gadir on September 16th, 2011 // No Comments
Finding SharePoint performance point Dashboard designer tool was a little tricky. It’s a click once download that is not available anywhere in MSDN downloads or any other place. However you can download it from your Business Intelligence Center page in SharePoint.To make your life easier, if you ever need it and you already have PerformancePoint installed on your SharePoint sever then here is how you can get it:Open your browser as an admin userGo to this URL http:///sites//pages/ppssample.asp...
Continue Reading
By Aneel Ismaily on June 10th, 2011 // No Comments
Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.To enable scale breaks on the chart1. Right-click the vertical axis and then open "Axis Properties".2. Select the "Enable scale breaks" check box.To change the style of the scale break1. On the design...
Continue Reading
