|
|
|
|
Browse by Tags
-
"Every new beginning comes from some other beginning's end" ( Seneca ) I spent big chunk of my professional career working on what we call today BI. From Panorama, coding some of the innovative cutting-edge (back then) algorithms, to Microsoft with mission Read More...
|
-
Integration of BI and Search became a popular subject couple of years ago. No doubt, it was heavily influenced by the “Google revolution”. Search is a hugely successful application. It features simple and natural UI - free form text, yet it is extremely Read More...
|
-
During SQL PASS 2008 summit , I gave full day preconference seminar “ Deep Dive to MDX ”. The evaluation forms now have arrived, and the scores for the content, relevance and depth portion of the seminar are very good. The scores are not as high, however, Read More...
|
-
There were not very many changes to MDX syntax in AS2008, and Vidas Matelis described most of them in his blog here (for his list of all changes in AS2008 check this blog entry ). I just noticed that there is at least one more change which Vidas didn’t Read More...
|
-
Omniture Discover is not general purpose OLAP client tool. Rather it is specialized application that lets users to explore data from the Omniture’s Web Analytics product. But it does look and feel like an OLAP browser – which is not surprising, since Read More...
|
-
Gross margin (also known as Gross profit margin or Gross profit rate) is defined as (Revenue – Cost of Sales)/Revenue. In terms of Adventure Works sample database we can write this in MDX as [Gross Margin] = ( [Measures] . [Internet Sales Amount] - [Measures] Read More...
|
-
For scalar values a*b is the same as b*a. (although we saw that performance of these two could be different in MDX in “ Performance of multiplication in MDX ” article). But if a and b are sets, then obviously results are different – since the order of Read More...
|
-
One of the most significant changes in Analysis Services 2008 was improving performance of MDX queries and calculations. In particular, query optimizer can choose block (a.k.a. subspace) computation mode in query plan more often than in AS2005, and usually Read More...
|
-
While some people are wondering whether ‘ XMLA is dead ’ and call to ‘ Resurrect the XMLA Council ’, the reality in the field is quite different. There are, of course, plenty of XMLA clients, and new ones being born – the server side, XMLA providers also Read More...
|
-
Setting partition slice has always been an important optimization technique in Analysis Services. Every presentation talked about it and every whitepaper mentioned it, for example the Microsoft SQL Server 2000 Analysis Services Performance Guide contains Read More...
|
-
During MS BI Conference 2008 I had a presentation called “Got MDX problems ? MDX Studio to the rescue !”. Given how the theme of self-service BI has been in the center of the conference, I decided to apply some self-service BI to analyze the performance Read More...
|
-
The conference is over, and I am back home. Of course unlike some other folks who will spend 11 hours flying over Atlantic to get home, I only spent 11 minutes driving over the Lake Washington. Well, it’s time to reflect on the conference, here are some Read More...
|
-
Hopefully last live blog post for today :) I keep getting constant stream of questions about both project Madison and Gemini. The Ted Kummert keynote where both announcements were made was recorded and can be viewed online – hopefully this will get many Read More...
|
-
In the couple of hours since the announcement here at MS BI conference, I talked with few people already and saw few threads and comments in the Web, and (as expected), there is plenty of confusion about what “Project Gemini” is and isn’t etc. Here are Read More...
|
-
So there were two sets of announcements just made during Ted Kummert keynote. 1. Project “Madison” – Share-nothing MPP scale-out version of SQL Server, powered by DATAllegro technology. We saw live demo of 24 instances running 150 TB data warehouse, returning Read More...
|
|
|
|
|
|