Monthly Archives: July 2008

Some more samples for data aware images created in a stored procedure

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 chart using this technique. Now, I just want to add some other ideas … Continue reading

Posted in Allgemein | Leave a comment

Some more thoughts on quantiles…

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 calculation as stored procedures offer the full range of .Net programmability … Continue reading

Posted in Allgemein | Leave a comment

Win/Loss chart as dynamic image created in SSAS stored procedure

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 the bitmap for the chart dynamically on demand using ASP.NET. I … Continue reading

Posted in Allgemein | Leave a comment

Returning an image from an SSAS stored procedure

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). Our sample stored procedure looks like … Continue reading

Posted in Allgemein | Leave a comment

Online version of MDX studio available

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: http://mdx.mosha.com/. For more details see Mosha’s blog entry. If … Continue reading

Posted in Allgemein | Leave a comment