By Chuck Rivel on September 27th, 2012 // No Comments
Scenario
A while back, we posted about how to set up the default action within a multidimensional cube in Microsoft SQL Server Analysis Services (SSAS). The action allows for specific data to be returned when a user right-clicks on a cell within a pivot table and then selects "Show Details" from the menu. Here's the post.
The key point of the development is that, when building your cube, you would click on the Actions tab in the designer and then create a new DrillThrough Action and then con...
Continue Reading
By Chuck Rivel on July 12th, 2012 // 2 Comments
Introduction
With the recent release of SQL Server 2012, a new SSAS instance has become available to develop business intelligence solutions against - the Tabular instance. The Tabular instance is different in how the cube is developed and designed in that it does not have traditional dimensions and measure groups like a Dimensional SSAS instance. Also, the Tabular instance is an in-memory data storage cube as opposed to a MOLAP or ROLAP dimensional cube. Lastly, creating calculations within th...
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 Chuck Rivel on April 22nd, 2011 // No Comments
Several members from the RDA BI team have put together an Unleashed Series book covering Business Intelligence with SharePoint 2010 and can be found online at the following link: http://www.informit.com/store/product.aspx?isbn=0132660113. The release date for the book is May 9th, 2011 and was written by: Chuck Rivel, Ray Barley, Jim Pletscher, Aneel Ismaily and Steve Mann (who was the original editor of the RDA Blog site and former team lead for the RDA BI Team) The book covers working wi...
Continue Reading
By Chuck Rivel on April 12th, 2010 // No Comments
While attending the Philly .NET Code Camp this past Saturday, one of the presentations was around an overview of the SQL 2008 R2 features. From the presentation, I learned that Microsoft is making the new R2 features available through a download that you can configure locally onto a VPC. The training kit will assist you in learning the product as it provides demonstrations, hands on labs, and videos in the kit itself. The Training Kit can be found on the Microsoft Download Center at the SQL Serv...
Continue Reading
Subscribe to our RSS feed
