Browse by Tags

Master Data Services Excel Add-in

Master Data Services in SQL Server Denali now includes an Excel add-in that allows MDS users to add and update data that exists within Master Data Services. For those of you that haven’t had a chance to download the latest CTP, this post gives an overview of what’s possible in the Excel Add-in. Excel...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-25-2011
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
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

Page 1 of 2 (13 items) 1 2 Next >