Tag Archives: ssas

Like the title says; my SSAS OLAP cube (SQL 2008R2) was giving me wrong results when selecting a combination of a measure and a fact. I was struggling for days with this issue. I called old colleagues, reading a lot of articles online but no solution yet.

I know it was not difficult to implement dimension security in Analysis Services.  While it’s not difficult, why did it cost me a lot of days to get this to work? Well, its because you have to do a lot of little settings and it’s easy to make a small mistake …

 I was looking for a method of formatting a dimension attrbibute in SSAS2008R2 to, for example a currency symbol €. In search of this question, I found out this is not possible within the default SSAS settings (format column). I thougt this was possible just like the measures settings with …

Iedere kent ze wel, hierarchieën in Analysis Services 2005. Met een hierarchy kun je bepaalde data op verschillende niveau’s aan de eindgebruiker tonen. Een bekend voorbeeld is: Jaar -> Kwartaal -> Maand -> Dag Omdat ik het nogal onduidelijk vind hoe je dit precies moet configureren leek het mij handig …