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 18 of 18 (176 total posts)
  • 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