QuerySimon

Yet another blog about BI

Browse by Tags

Tagged Content List
  • Blog Post: Creating a BI test machine in the cloud and allowing anonymous access to it

    I got a question from a colleague that wanted to know how he could create and connect anonymously to a BI machine in the cloud. There are several whitepapers available but they can be hard to follow if you never have done it before so I thought that I would write a small simple instruction on how to...
  • Blog Post: Installing the BI features of SharePoint 2013

    Now that SharePoint 2013 and SQL Server 2012 SP1 have been released I thought about revisiting my post on how to install the BI features of SharePoint 2013. As in the previous post I am installing the bits on a fully updated Windows Server 2008 R2 machine, I have added the Web role as well as the Application...
  • Blog Post: Installing the BI features of SharePoint 2013 Preview

    I have now added a new post on how to install the BI features in the released version of SharePoint 2013 you can find it here http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx Since the release of SharePoint 2013 Preview I have tried to get a...
  • Blog Post: BI data on maps in SQL Server 2012 part 2

    In my previous post http://blogs.msdn.com/b/querysimon/archive/2012/06/17/bi-data-on-maps-in-sql-server-2012.aspx I described how to create a Reporting Services report that contains custom map data. One of the drawbacks with the mapping component in SSRS is that you cannot zoom interactively in your...
  • Blog Post: BI data on maps in SQL Server 2012 part 1

    I often get questions around how to show business intelligence data on maps in the Microsoft BI stack. Some people thinks that we do not support this for the entire world but only for US. I think that this misunderstanding comes from the fact that the map gallery in Reporting Services only shows data...
  • Blog Post: How to control allocations when using write-back in Excel 2010

    One of the first questions that I usually gets when showing write-back in Excel 2010 to Analysis Services cubes is how you can control the allocation of values between dimension members. By default you will get an equal allocation based on the number of dimension members. This setting will divide the...
  • Blog Post: Writeback to Analysis Services cubes from Excel 2010

    Analysis Services have had write back functionality for a long time; however there has been no client support for writeback in the most used BI client on the market (Excel). One of the new features in Excel 2010 is the ability to perform writeback to Analysis Services cubes. In order to write back...
Page 1 of 1 (7 items)