in

Adatis BI Blogs

Welcome to Adatis blogs

Browse by Tags

  • 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

  • PowerPivot CTP3 Released

    Following last week's release of the November CTP for SQL Server 2008 R2, the latest CTP for PowerPivot is now also released! The links for the downloads are: 32 Bit PowerPivot Download 64 Bit PowerPivot Download PowerPivot Main Download Page Included in the new CTP3 features are several new DAX...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-18-2009

  • Creating a Custom Gemini/PowerPivot Data Feed – Method 1 – ADO.NET Data Services

    There are already a few good Gemini/PowerPivot blogs that provide an introduction into what it is and does so there is no need for repetition.  What I haven’t seen are examples of how existing investments can be harnessed for Gemini/PowerPivot based self-service analytics. This series of posts focuses...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 10-20-2009

  • 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

  • RIP PerformancePoint Planning

    It's nearly a week since the announcement that shook the (PPS) world !  It's been a bit difficult to report on; generally the Adatis blogs try and offer solutions to problems we have encountered out in the real-world.  Now I could say something crass here about the real-world and the...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 01-29-2009

  • Entering Dates in PPS Planning Assignments

    In the recent PPS Planning projects that I've been involved in, the challenges have often been around subjects such as business rules, hence the often recurring theme of this blog. Recently the tables were turned though, as I was told by a user that they wanted to enter dates into a PPS assignment...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-27-2008

  • PerformancePoint Server Planning SP1 - Clear Changes After Workflow Action

    There's a new workbook property that was introduced in PPS Service Pack 1.  The 'Clear Changes After Workflow Action' effectively splats the change list for the workbook once the assignment has been submitted (either draft or final). The property can only be reached through the Report...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 07-29-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

  • PerformancePoint Suggestion box

    Inspired by Adrian 's post on the TechNet Planning Forum here's my list of 'I wants' for PPS-P.  I've cross posted this to the forum discussion too.  A few of these have been suggested before but there are some new ones in there too - In no particular order: Application...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 05-31-2008
Page 1 of 2 (11 items) 1 2 Next >