THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Analysis Servic... » Excel 2007   (RSS)
  • DefaultMember, subcubes and non-aggregatable attributes

    Today I discovered that DefaultMember might result in a member other thant the default dimension member. Reading documentation, I got the idea that DefaultMember would be always the default member defined for a dimension into a cube. In reality, the default member could change into a subcube that excludes the original default member from a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 1, 2007
  • DateTool dimension: an alternative Time Intelligence implementation

    Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have a server-side feature doing that (so you don’t discriminate Excel users). ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 2, 2007
  • SSAS 2005 SP2 breaks Excel calculated member selection

    After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here, but today I found the way to reproduce the error. This is a scenario that works well: Analysis Services 2005 SP1 + hotfixes (build 2153) Excel 2007 RTM Cube ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2007
Privacy Statement