in

Adatis BI Blogs

Browse by Tags

  • Managing SSAS Named Sets with Master Data Services Collections

    Master Data Services Collections are probably not the first feature that come to mind when you think of the MDS product. The hierarchies and member grids tend to be the core functionality, but as this post will hopefully show, MDS Collections are useful also. Collections are essentially managed lists...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-07-2011

  • Master Data Services Training in the UK

    This is just a quick post to announce a range of SQL Server training courses, organised (and in some cases delivered) by Chris Webb . To start off there’s a SQL Server course delivered by Christian Bolton in December, followed by an Analysis Services course delivered by Chris in February. I’ll be delivering...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-01-2011

  • MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook - Book Review

    As you may have already seen, Packt have released a new MDX book, namely MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli. The book is written as cookbook, meaning that you can choose the individual ‘recipes’ that apply to whatever problem you’re trying to solve...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 10-13-2011

  • Allocations in PowerPivot Using DAX

    Although I didn't mention it, the inspiration for my last post was the excellent MDX Solutions 2nd Edition . Whilst flicking through the book a while back, I though it would be interesting to see how DAX and PowerPivot could handle the so called 'Common Calculations and Selections in MDX'...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-27-2010

  • 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 (10 items)