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 » SSAS   (RSS)
Showing page 17 of 17 (169 total posts)
  • What are the natural hierarchies and why they are a good thing

    Analysis Services 2005 Service Pack 2 is just around the corner. Microsoft released the list of improvements made in SP2. While many of them are self-explanatory, others could benefit from more explanations. I already wrote about two very important improvements - interaction between WHERE and axes, and Visual Totals changes. Today, this thread ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on November 9, 2006
  • Inside OLAP Engine: SE cache sharing

    After publishing the excerpt from my upcoming whitepaper on AS caching, I received a lot of feedback, both in blog comments and in email. I want to thank everybody who took time to read and assess that piece. Honestly, I was a little bit afraid, because I know that I have tendency to overcomplicate and confuse people when I explain something, but ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on January 12, 2006
  • Inside OLAP Engine: Cache Prefetching

    I am writing a whitepaper about Analysis Services 2005 Cache Manager, and it gets longer and longer. I already spent few days on it, and I am still not even halfway done. So I decided to publish an excerpt from this whitepaper (chapter 2.1.5) and gauge whether I am getting it at the right technical level or whether I am going too deep or too ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on January 5, 2006
  • Default members, MDX Scripts, Security, KPIs and Perspectives

    What happens to the cube after the processing is complete but before cube is ready for the querying ? There are actually quite a few steps that should be taken in order to prepare the cube, like create calculated members and named sets, apply security, factor in actions and KPIs etc. In this article we will provide an overview of the most ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on December 31, 2005
  • Understanding changes in Yukon MDX Part I

    When I did a review of “Analysis Services 2000 vs 2005” presentation, I mentioned, that changes to MDX were not covered at all in it, and I also noted, that changes to MDX in Yukon could easily fill several presentations by themselves. And they do. In July, Rob Zare has delivered Webcast called “Understanding changes in Yukon MDX Part I”. This ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on February 16, 2005
  • Analysis Services 2000 vs. 2005

    I have run across a presentation called “Analysis Services 2000 vs. 2005” prepared by Jaimie Basilico and Mark Frawley (Jamie works in Microsoft as Senior Technology Specialist in the East Cost, and he is one of the best field people in Analysis Services that we have). This presentation is targeted towards people who are familiar with Analysis ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on January 31, 2005
  • Kerberos Authentication and Delegation in Analysis Services 2005

    Anybody who implemented multi-tier application which needs to access Analysis Services and tried to use Windows integrated security from end to end, has run into the issue of enabling delegation, which also meant forcing Analysis Services to use Kerberos (since this is only supported SSPI provider which implements delegation). One classic example ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on January 25, 2005
  • Loading Aggregate Data with MDX Script in Analysis Services 2005

    Richard Tkachuk has just posted a new whitepaper on the site called “Loading Aggregate Data in Yukon”. It discusses several scenarios when the data is already precomputed at the non-leaf cells and needs to be loaded there instead of being aggregated from the leaves. The modeling approach Richard took is similar to ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on January 13, 2005
  • Analysis Services 2005: many-to-many dimension, killer feature!

    SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are ''marginal'', in the sense that bring us better productivity (= less development time) or better performance. Aside administrative and development ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 4, 2004
Privacy Statement