Blog

Know-how von Experten für Experten

BI & Big Data Blog

30.01.2010
Technical Value
SQL Server 2005 | SQL Server 2008 Some posts ago I wrote about the error message ‘A duplicate attribute key has been found when processing ’. At the end of the post I suggested not to set the error configuration for… Weiterlesen
10.01.2010
Technical Value
SQL Server 2005 | SQL Server 2008 Handling different granularity (for example actual and plan values) can get a little bit complicated. Of course there are standard methods, like splitting up the less granular data in… Weiterlesen
21.12.2009
Technical Value
SQL Server 2005 | SQL Server 2008 While units are a built-in functionality in some OLAP databases, we need to take care of them in SSAS on our own. Usually I model units as a dimension so that the facts are linked to… Weiterlesen
29.11.2009
Technical Value
SQL Server 2005 | SQL Server 2008 This post is about a common error message during dimension processing I’ve been asked about quite a few times so I thought it would be worth posting about it. The error message says… Weiterlesen
15.11.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Cube defined formats are not necessarily displayed properly in Excel 2007. Sometimes the format seems to be ignored completely although it is working fine in the cube browser. For a… Weiterlesen
02.11.2009
Technical Value
SQL Server 2008 Although the way of defining the KPI status and trend is very flexible it is also somehow circumstantial if you simply want to rate a KPI by its target value. In this case you would have to calculate… Weiterlesen
11.10.2009
Technical Value
SQL Server 2005 | SQL Server 2008 My last two posts have been about semi-additive measures, so this is part 3 of my semi-additive measures mini series. This post is about role-playing time dimensions together with… Weiterlesen
20.09.2009
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
23.08.2009
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
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

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