This article looks at the basics of storage design for cubes using Analysis services. A good starting point for those getting into the use of analysis services.
2004-09-29
2,390 reads
In this article, we will examine "rolling average" aggregations, a common business requirement. "Rolling," or "moving," averages, involve a measure, the average under consideration, that is aggregated over a progressively moving window of time periods.
2004-08-27
1,555 reads
In this article, we began with a discussion of general business needs as related to the concept of relative time. We then undertook a practical, multi-step exercise, based upon a hypothetical business need, to illustrate a potential solution for a stated requirement.
2004-08-26
992 reads
In this article and others subsequent to it, we will focus on time considerations in our MDX queries., and how we can successfully report change over time, as well as to accumulate those changes to present the precise snapshots, trends and other time-based metrics so dearly appreciated in business.
2004-08-25
1,221 reads
Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.
2004-02-11
1,221 reads
See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.
2002-02-08
1,215 reads
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Tlp/Wa_Cs:0817-866-887. Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota Singkawang, Kalimantan Barat...
Tlp/Wa_Cs:0817-866-887. Jl. Taman Sari Raya 47-47A, RT.11/RW.7, Taman Sari, Kec. Taman Sari, Kota Jakarta...
Comments posted to this topic are about the item How Do the Experts Become...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers