Microsoft BI PFE

Business Intelligence Premier Field Engineers Blog

Browse by Tags

Tagged Content List
  • Blog Post: Identifying Cell by Cell Computation Mode in MDX queries

    Some weeks ago I was asked to help with a performance issue with some MDX Queries. I was shown what the customer wanted to achieve, they needed to calculate some metrics including sampling errors using the method of “Conglomerados Últimos” (This can be translated to “Conglomerates...
  • Blog Post: OOPS, I got an error. Ensuring The Correct Bitness Provider is Installed

    The field of Business Intelligence involves consolidating and aggregating data from a number of different and often highly disparate data sources. The cool part is that working in the field of BI means that we get to play with a bunch of really neet toys like SSRS, SSIS, and SSAS. Since those neet toys...
  • Blog Post: When should I use Analysis Services Tabular mode or Multi Dimensional mode?

      After talking with several customers, I have got this question asked several times? Since Analysis Services has different modes, customers seems confused about when to use which mode. I will give short answer and guideline for initial start and I will discuss this topic in later posts. When should...
  • Blog Post: Analysis Services: Removing Instance Level Admin Rights from Developers….

    One of popular questions in these days: Is it possible to remove admin rights from developers but they can still run backup/restore operations as well as profiler trace? I know, from developer’s perspective, this is like removing their freedom for things they developed but on the other hand, from...
  • Blog Post: Managing Server Side Analysis Services Profiler Trace

    I have been asked how to run Analysis Services Profiler Trace as Server side Trace. There are few ways of running trace on server like astrace tool. In this post, I am going to show you how you can create server side trace using xmla and stop trace. First Step is to create XMLA for your profiler...
  • Blog Post: Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

    Hello everyone, This month we released a new document about hardware sizing in SQL Server 2012 Analysis Services Tabular mode. This document provides guidance for estimating the hardware requirements needed to support processing and query workloads for an Analysis Services tabular solution. Check...
  • Blog Post: MDX Fundamentals & DAX Fundamentals Sessions

    I am pleased to announce, our new two courses are available in January.  Here are course details:   MDX Fundamentals: In this course, we will be covering MDX Fundamentals. You will learn how to multi dimension query language works and how to think to write MDX to query data. As you may imagine...
Page 1 of 1 (7 items)