Blog

Know-how von Experten für Experten

BI & Big Data Blog

09.08.2009
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
05.08.2009
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
25.07.2009
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
11.07.2009
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
25.05.2009
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
23.05.2009
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
09.05.2009
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
21.04.2009
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
13.04.2009
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
12.04.2009
Technical Value
SQL Server 2008 Vidas Matelis posted an overview of the SSAS performance counters at ssas-info.com . You can find the complete list here: http://www.ssas-info.com/analysis-services-articles/58-ssas-2008/1113-analysis… Weiterlesen
21.03.2009
Technical Value
SQL Server 2005 | SQL Server 2008 In my last post I wrote about context sensitive formatting. The goal was to format values differently depending on their digits, so that for example. 532 formats to 532 but 143,134… Weiterlesen
17.03.2009
Technical Value
SQL Server 2005 | SQL Server 2008 It's commonly known that you can provide a format string for measures like in the following example: with MEMBER [Measures].[Sales Amount Fmt] AS  [Measures… 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