|
|
|
|
Browse by Tags
-
This thread on MSDN forums asks seemingly easy question – given a multiple selection of elements in the parent-child hierarchy – how to find lowest common ancestor among them ? While it is fairly easy to do using stored procedure, it turned out to be Read More...
|
-
Drillthrough is a great feature of Analysis Services, but it has a limitation – only cells without calculations covering them can be drilled through. This automatically rules out drillthrough for calculated members in general and calculated measures in Read More...
|
-
Parent-Child dimensions is an important feature of Analysis Services. Parent-Child dimension allow flexibility in the dimension modeling for scenarios such as Bill Of Materials, Chart of Accounts, Employee Organization Structure and others. However, this Read More...
|
-
With Visual Studio and other modern IDEs, Intellisense became a must have tool in the developer’s toolset, boosting productivity. MDX developers have asked for it, but full, context-dependant intellisense wasn’t available. Until now. MDX Studio now features Read More...
|
-
SQL PASS Summit 2008 and Microsoft Business Intelligence Conference 2008 are two major conferences targeting very similar audiences. And this year both conferences are happening in the same location very close to each other (there is just one month separating Read More...
|
-
In this article we will show how to take typical, everyday MDX and optimize it by simply following advices of MDX Studio Analyzer. As a starting point, I will take “ Product Volatility ” example as published by Thomas Ivarson in his blog. It is a perfect Read More...
|
-
Official pressrelease: http://www.datallegro.com/pr/7_24_08_microsoft_acquisition.asp Curt Monash coverage: http://www.dbms2.com/category/products-and-vendors/datallegro/ This is a huge win for Microsoft Data Warehousing (and therefore BI) strategy ! Read More...
|
-
Always adhering to the MDX best practices could be a difficult quest to follow. While there is plenty of information out there, it is scattered across book, whitepapers, blogs, BOL, forum posts etc. And this information could be difficult to digest, and Read More...
|
-
Whenever I am asked “What is the single most important advice to write efficient MDX”, I always give same answer: The simpler MDX you write – typically the better performance you will get. The reasoning behind this is straightforward: If MDX is simple, Read More...
|
-
MDX Formatting functionality debuted in MDX Studio 0.2.8, and judging by the amount of feedback I got on it – it became the most popular feature of MDX Studio ever ! Couple of people mentioned that for SQL formatting/beautifying needs, they would go online Read More...
|
-
One of my most popular blog posts was “ Analysis Services 2005 protocol - XMLA over TCP/IP ”. Previously this information wasn’t available from anywhere else. But things changed today. Microsoft now has engaged in the “ Open Specification program ”. Citing Read More...
|
-
Darren Gosbell put up a blog post about MDX Formatting, where he describes how he prefers to format MDX to look nice on the screen. So I thought – why to leave to a human something that machine can do. I decided to implement these rules (with some modifications) Read More...
|
-
Every year around March or April I am looking forward the OLAP Report site to see the OLAP market share numbers. Computing these numbers is not a simple task as Nigel Pendse explains on http://www.olapreport.com/market.htm , and this kind of analysis Read More...
|
-
How many elements in the set have distinct values ? This sounds like a simple question. Apparently, this is well known problem in Excel, and there is a classic solution for it. There are plenty of sites in Internet (for example here and here ) which give Read More...
|
-
BI Survey 8 is up and ready to accept participants. It’s hard to believe that we are at version 8 of what started as OLAP Survey 1 back in 2000. (On the other hand, my daughter also recently turned 8, she was born in 2000 too, and I still cannot believe Read More...
|
|
|
|
|
|