in

Adatis BI Blogs

Browse by Tags

  • Adding a Calculated Field to an Excel Pivot Table With Analysis Services

    One question that I get asked from time to time is how to add a calculated field to an Excel Pivot Table that’s connected to an Analysis Services cube. I’ve been aware of a workaround to do this for a while, but a quick Bing :-) revealed that the common answer given to this question is that it’s not...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 07-01-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

  • DAX Closing Balances

    One of the often required calculations for users in reports is to be able to calculate a point-in-time closing balance, which is especially relevant when dealing with stock levels or financial data. In the Analysis Services world, at least in the Enterprise Edition, we're lucky that we have a variety...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-11-2010

  • XLCubed Version 5 Released

    Interesting to see yesterday that XLCubed have released version 5 of their popular OLAP reporting tool. As I've mentioned before , I've always found XLCubed to be very powerful and easy to use, and therefore, in my opinion, it's definitely one of the best Excel OLAP reporting tools out there...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 03-13-2009

  • 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
Page 1 of 1 (5 items)