Microsoft BI PFE
Business Intelligence Premier Field Engineers Blog
Translate This Page
Translate this page
Compare Tabular and Multi Dimensional
Data Quality Services
Master Data Services
Microsoft Business Intelligence at a Glance Poster
Premier Field Engineering
Remove Admin Eights
Server Side Trace
SharePoint Integrated Mode
SQL 2012 Service Pack 1 Cumulative Update 4
Sql Server Agent
SQL Server Service Pack 1
SQL Server SP1
SSAS Multi Dimensional
Browse by Tags
Microsoft BI PFE
Tagged Content List
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...
4 Sep 2013
OOPS, I got an error. Ensuring The Correct Bitness Provider is Installed
John Desch MSFT
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...
30 Jul 2013
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...
20 Jun 2013
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...
15 Feb 2013
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...
12 Feb 2013
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...
20 Jan 2013
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...
5 Dec 2012
Page 1 of 1 (7 items)
© 2015 Microsoft Corporation.
Privacy & Cookies