Blog

Know-how von Experten für Experten

BI & Big Data Blog

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
23.02.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Many of us are not aware of the BI functionality in the other office programs like in Visio. And although I prefer the pivot functions of Excel you should take a look at these… Weiterlesen
15.02.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Deploying an OLAP application using deployment scripts is a common scenario in larger development environments. Of course we can use XMLA scripts to do the deployment but running the… Weiterlesen
25.01.2009
Technical Value
SQL Server 2005 | SQL Server 2008 Stored procedures offer a really powerful extensibility for Microsoft OLAP. But the more complex the functions get, the more you need debugging capabilities. Of course you will want… 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