Know-how von Experten für Experten

BI & Big Data Blog

Technical Value
SQL Server 2005 | SQL Server 2008 My last post was about the effects of semi-additive measures on dimensions other than the time dimension. Now let's focus on the situation of having more than one dimension of type '… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 Semi-additive measures are measures that don't use the same aggregation method along all of the cube's dimensions. In SSAS the time dimension plays an important role here. For example… Weiterlesen
Technical Value
SQL Server 2008 There are some definitions for calendar weeks and T-SQL offers many of those calculations out of the box. When you're doing projects in Europe you will frequently find the ISO week definition for the… Weiterlesen
Technical Value
SQL Server 2008 So here is my first book recommendation in this blog. The authors (Chris Webb, Alberto Ferrari and Marco Russo) are all well known Analysis Services experts and they did a pretty good job in writing… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 Building your time attribute relationship you have to consider the following questions: How will I normally navigate the date hierarchies? What formatting options do you usually… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 Thanks to Google Analytics I saw that many page hits on my blog result from keyword searches for "create time attribute relationship". And in fact, it seems to be more complicated to… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 Last week I had the opportunity to talk with Peter Leweke from Liquiverse about their new data browser and their focus to turn data from lists into a meaning or as they say on their… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 In the last post we had an issue with multiple members sharing the same name but with different key attributes. Every approach of addressing such members with MDX like [Dimension… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 Usually working with historical values in an SSAS cube is not really complicated. Think of a customer whose ZIP code changed over time which is modeled as a slowly changing dimension… Weiterlesen
Technical Value
Hilmar Buchta
SQL Server 2005 | SQL Server 2008 Usually we're using load testing tools as a basis for performance tuning or in order to give reliable hardware recommendations. You can find two approaches for load testing at the… Weiterlesen
Technical Value
As most of you might have already heard, SQL Server 2008 SP1 is out and can be downloaded from the Microsoft site . The build number is 2531 (so the complete version number is now 10.0.2531.0). Among the bug fixes and… Weiterlesen
Technical Value
SQL Server 2008 Vidas Matelis posted an overview of the SSAS performance counters at . You can find the complete list here:… Weiterlesen

Newsletter Anmeldung

Abonnieren Sie unseren Newsletter!
Lassen Sie sich regelmäßig über alle Neuigkeiten rundum ORAYLIS und die BI- & Big-Data-Branche informieren.

Jetzt anmelden

Unsere Website benutzt Cookies, um bestmögliche Funktionalitäten bieten zu können. Durch die Nutzung unserer Website, erklären Sie sich mit der Verwendung von Cookies einverstanden. In unserer Datenschutzerklärung finden Sie unter §5 Informationen und Links, wie Sie diesen Maßnahmen jederzeit widersprechen können.