in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » ssas » olap (RSS)

Browse by Tags

  • SSAS Cube Deployment

    What I miss with SSAS cube deployment (regardless of MSSQL Server version) is all sorts of statistics where one could track and easily see how fast cube or partition is being processed. Besides talking to several MVP's (three in general) and reading piles (well, four of five) of books regarding this...
    Posted to Tomaz.tsql (Weblog) by Tomaz.tsql on Sun, Jul 18 2010
  • Books to read

    This post is mainly for fellow BI folks such as me who feel that they are only at the beginning of this road: First I show you what I've already read (or at least have learnt a lot from): The 70-445 Training Kit - it's a great book, teaches a lot even for beginners (I created my first reports...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Thu, Mar 19 2009
  • Star or Snowflake i.e., 1 or 2 Dim tables?

    Last week I had to design and sketch a more or less simple OLAP solution during which I had to face a certain dilemma. But before going into details I'd like to share some background. The OLTP source system is in Oracle: The first fact table row points to the "company size" question which...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Mon, Feb 9 2009
  • Pivot table connectivity to SQL Server Analysis Services - security gotchas

    Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database to fetch the data. As per the configuration when...
  • SSAS - AverageOfChildren only applies to the time dimension

    I've just spent a morning trying to figure out why my average measure doesn't average but sums. I guess I should have googled straight away. In doing so I found this forum post http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=548837&SiteID=17 Christian also mentions this behaviour...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, May 21 2007
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems