|
|
|
|
Browse by Tags
All Tags » mdx (RSS)
-
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...
|
-
NextAnalytics is a young BI company founded by Ward Yaternick of OLAP@Work fame. He has a blog dedicated to his new product, and while I was reading it, I ran across the post named “ Can a business intelligence product be used to answer analytic questions? Read More...
|
-
Partitions have been a built-in feature of Analysis Services ever since the first version. Naturally, all the engine subsystems, including the MDX query optimizer, work well with partitions. There are rare cases, however, when over-aggressive prefetching Read More...
|
-
As the readers of my blog know, bulk evaluation mode (called "block computation mode" in Katmai) delivers much better performance in MDX than the cell-by-cell evaluation mode. Therefore the most important optimization technique with MDX in Analysis Services Read More...
|
-
The subject of multiselect friendly calculations is a popular one in forums. I have written about it before here , here and here . In February 2008 I will write a blog which will give a definite answer on how AS2008 will deal with it (which is follow Read More...
|
-
Redmond, WA September 18, 2007 - Mosha Pasumansky today announced the immediate availability of MDX Studio Community Technology Preview (CTP) 1, version 0.1 Alpha. MDX Studio is tool which helps users of Microsoft Analysis Services to analyze complex Read More...
|
-
Moving averages is an important statistical technique for analyzing time series data. It is often used to do forecasting or trend estimations , and it is especially popular for analyzing financial data. There are many different types of moving averages, Read More...
|
-
After writing my previous blog post about dynamic named sets , I received feedback from multiple people saying the same thing: "How come nobody knew about this great new feature for the last 3 months". Now, one of the constant complains about AS2005 was Read More...
|
-
The September CTP of Katmai (speculated to be released during PASS) is expected to be the first Katmai CTP to contain significant improvements in the OLAP engine. The most important one (which is, in my opinion, is also the most important AS Katmai feature) Read More...
|
-
It is time to publish the solution to the MDX puzzle from the " MDX is like chess " blog. I wrote it before going to my summer vacation. Since then I received several answers. While nobody answered correctly all 3 questions, there are still winners. In Read More...
|
-
I was reading the blog post " My notes from Microsoft BI Conference " by Vidas Matelis. It is a collection of notes recorded at different presentations, chalk talks etc. I felt that I agree with some of them, disagree with some, and have no opinion about Read More...
|
-
Time dimension has special meaning in OLAP and DW. The classic problems involve looking at previous period, parallel period, computing moving averages and running sums. Today we will look into less common, but nevertheless interesting problem of 'in-flight' Read More...
|
-
Time dimension is special in OLAP. Many MDX functions usually only make sense when applied to Time dimension (PrevMember, Lag, ParallelPeriod, PeriodsToDate, ClosingPeriod etc); semiadditive measures work differently with Time etc. Today, however, we Read More...
|
-
The question in the title of this post is a popular one. There are many scenarios, where it is desirable to navigate to the member of the Time hierarchy which corresponds to the current day, month or year. Sometimes, there is a desire to set the default Read More...
|
-
In this article we will discuss some of the best practices around writing efficient Analysis Services stored procedures using server ADOMD.NET. These days there is plenty of information about writing efficient MDX - in books, whitepapers, blogs, forums Read More...
|
|
|
|
|
|