Blog

Know-how von Experten für Experten

BI & Big Data Blog

15.08.2008
Technical Value

SQL Server 2005 | SQL Server 2008

There had been quite some posts about rounding values in MDX or on a report. For most cases we want to do the rounding in the…

Weiterlesen
26.07.2008
Technical Value

SQL Server 2005 | SQL Server 2008

In a previous post I showed an example of how to return a dynamic bitmap graphic from a SSAS stored procedure and we also displayed a Win/Loss…

Weiterlesen
19.07.2008
Technical Value

SQL Server 2005

In a previous post some weeks ago I wrote about calculating a quantile in MDX. Of course you could also think of using a SSAS stored procedure for the…

Weiterlesen
12.07.2008
Technical Value

SQL Server 2005

Sascha Lorenz posted the source code for creating win/loss charts in his blog . I really like this kind of charts as it is especially useful for sparklines. Sascha created…

Weiterlesen
05.07.2008
Technical Value

SQL Server 2005

I just played with a simple way to return an image from a stored procedure by returning a base 64 encoded string of the image in a certain image format (e.g. PNG or JPEG).…

Weiterlesen
01.07.2008
Technical Value

One of the great features in the current release of Mosha's MDX studio is the ability to format MDX queries. Now this feature is available online as well using this URL:…

Weiterlesen
29.06.2008
Technical Value

SQL Server 2005

In the last post we discussed some background on statistics. Now let's turn this into a KPI target. If the parameters of the test are well known in advance the…

Weiterlesen
28.06.2008
Technical Value

Rafal Lukawieki did a great presentation about data mining. The video is available at the Microsoft homepage and it's actually a level 400 session (although named "Introduction into Data…

Weiterlesen
21.06.2008
Technical Value

SQL Server 2005

This entry is not much about OLAP or MDX but gives some background on statistical tests that may be very useful in designing meaningful KPIs based on…

Weiterlesen
16.06.2008
Technical Value

Mosha wrote a nice tool for testing and debugging MDX queries. It can be downloaded via Skydrive:

Weiterlesen
16.06.2008
Technical Value

SQL Server 2005

Microsoft MDX offers a huge set of mathematical function, which can be further enhanced by using Excel-functions. Excel-…

Weiterlesen
13.06.2008
Technical Value

Fortunately, Microsoft offers the whole starter kit for SQL Server Analysis Services in its SQL Server 2005/2008 Developer Edition. The Developer Edition also includes samples and…

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