in

Adatis Community

Welcome to Adatis blogs

Browse by Tags

  • Analysis Services Properties for PerformancePoint MDX Rules

    One of the great features of PEL is that you can choose either a SQL or MDX implementation for your rules, depending on what you want to achieve. Whilst the MDX rules are much less restrictive than the SQL rules, they can sometimes run slower, depending of course on how your environment is set up. When...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 09-07-2008

  • MDX - 12 Months to Date

    Analysis Services 2005 comes with the useful Add Business Intelligence wizard, which will assist you with numerous calculations, including 12 Months to Date. However, I tend to write such calculations myself, especially having found out that the 12 Months to Date MDX generated by the Business Intelligence...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 03-06-2008

  • 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 Stored Procedures\Views

    Whilst not changing nappies and singing lullabies, Sacha is developing a .Net mdx helper class that behaves very much like an ADOMD command and runs an mdx query that returns a data table. "Why not just use ADOMD?" I hear you ask - as Sacha mentions there are a number of reasons such as the...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 08-02-2007

  • Best BI Blogs

    These days if you want to keep up with all the latest news and developments (especially in our small little BI world) you need to follow the blogs of those who are in the know. Here are some of our favourites: An idea or two... SSIS expert Colin Kirkby (and top guy) Cutting edge! Chris Webb's BI...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 06-14-2007
Page 1 of 1 (6 items)