|
|
|
|
Browse by Tags
All Tags » mdx (RSS)
-
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...
|
-
How to get averages and other ratio based MDX calculations demonstrate great performance ? I thought I covered this subject in great depth before, but I probably wasn't concise enough. Last week I was asked to help with performance to very big and important Read More...
|
-
IIF is one of the most popular MDX functions, (this was proved by these surveys ). Yet, it can cause significant performance degradation, which is often blamed on other parts of the system. Many times it is simple to rewrite the MDX expression to get Read More...
|
-
MDX has some built-in aggregation functions - Sum, Count, Min and Max. There is also an ubiquitous Aggregate function, which will aggregate values according to the current measure aggregation function, which also adds Distinct Count and all of the semiadditive Read More...
|
-
Since I started a series of blogs about AS specific changes in SP2, few people asked me to explain in more details some of the things covered in the SP2 list of changes . The most popular request so far was to explain performance optimizations for running Read More...
|
-
One of the most talked about improvements in Analysis Services 2005 was support for Distinct Count measure over arbitrary set of members. I.e. the user can select subset of members over which he wants to get the value of Distinct Count measure, and it Read More...
|
|
|
|
|
|