Tag

#ssas

4 blogs

  1. SSAS OLAP is returning wrong results

    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 ...

    Data Warehousing17 Sep 2014 · 6.4k reads
    6.4k

  2. How to implement Dimension Security in SSAS

    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 ...

    Data Warehousing1 comment1 Sep 2014 · 539.9k reads
    539.9k

  3. SSAS: How to format a dimension attribute?

    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 ...

    Data Warehousing30 Sep 2013 · 11.9k reads
    11.9k

  4. Hierarchies in Analysis Services 2005

    Everyone knows them: hierarchies in Analysis Services 2005. With a hierarchy you can show certain data to the end user at different levels. A well-known example is: Year -> Quarter -> ...

    Data Warehousing21 Jan 2008 · 3.9k reads
    3.9k
(4 rows affected)sqlblog.nl