in

Adatis BI Blogs

Browse by Tags

  • MDX Stored Procedures (Part 2)

    What seems like a lifetime ago I posted about MDX Stored Procedures and how we've built a helper class that provides a wrapper to an MDX query. The helper class has been stable for quite sometime now and a few people have been asking me when I'm going to release it. Well, today is the day. You...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 11-20-2007

  • Basket Analysis using Analysis Services 2005

    My job is pretty varied these days :o) Today I've been looking at satisfying some basket analysis type requirements where, for example, we need to determine what other products customers have bought in addition to a known product. We could have used data mining for this but decided not to as, in...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-22-2007

  • Analysis Services XMLA to clear query cache

    To get a realistic measurement of how your query tuning improves query response time you should start from a common point. To help with this you should clear your query cache before running a queries after making improvements (Unless you are cache warming of course !). Here is some XMLA script to clear...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 03-14-2007
Page 1 of 1 (3 items)