in

Adatis Community

Welcome to Adatis blogs

Browse by Tags

  • SQL Server 2005 Cumulative Update 8 for Service Pack 2

    Microsoft have just released Cumulative Update 8 for SQL Server 2005 Service Pack 2. Amongst the changes are a few fixes for small problems in Analysis Services, such as: Infinite recursion occurs in the CalculationPassValue function in SQL Server 2005 Analysis Services; A data source view that connects...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 06-19-2008

  • XLCubed Version 4 Released

    XLCubed Version 4 was recently released, adding support for increased data visualisation via MicroCharts, as well as enhanced web publishing. I've been using XLCubed since version 1 and have always found it both powerful and easy to use. All the standard functionality that you'd expect from an...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 06-11-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

  • Setting up PerformancePoint Monitoring Design Role Security

    There's lot of info out there about setting up the application pool identity so that you can set up data sources for dashboards ( For example ). However there seems to be very little about the various roles that are used in the Dashboard Designer and how to set them up. If you try and connect to...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 11-01-2007

  • Multi-dimensional modeling (ADAPT)

    Everybody hates documentation but this is a really neat, free tool for modeling multi-dimensional databases and is particularly suited to MSAS 2005. ADAPT™ (Application Design for Analytical Processing Technologies) from Symmetry Corporation is a Visio stencil. Example of a time dimension is shown below...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 09-30-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

  • SQL User Group BI Evening

    Chris Webb has already mentioned this but looks like registration for the next UK SQL BI user group evening is now open (Look for events on the right). Edenbrook's Mark Hill (SQL 2008) and IMG's Suranjan Som (Data mining) are presenting. If that's not enough to get you there then free beer...
    Posted to Tim Kent's blog (Weblog) by Tim Kent on 08-17-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 2 (11 items) 1 2 Next >