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: 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...
Page 1 of 1 (3 items)