Sacha Tomey's blog

Molding the Microsoft BI Stack

Browse by Tags

All Tags » Business Intelligence (RSS)
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...
HACK: Exposing Foreign Keys as Properties through the ADO.NET Entity Framework
First post for months; the PerformancePoint Planning announcement forced some redirection and rebuilding.  We’ve grieved, we’ve moaned, but at some point, you just have to move on. ----------------- I’m not a fan of hacks – it normally means you...
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...
PerformancePoint SP2 - Planning Fixes and a mini-feature
Jeremy has already announced the release of PerformancePoint Server SP2 and it's great to see that the PPS dev team hit their target release date !  I've spent a little commute time this morning checking out the documentation, admittedly...
PerformancePoint Server SP2 - Target Release Date 8th December 2008
Word on the street is that next Monday, 8th December 2008, the second Service Pack for PerformancePoint Server 2007 will be released.  Less than a week !
PerformancePoint Planning: Deleting a Custom Member Property - A Solution
I had a bit of a rant yesterday about the fact I have had to compromise naming member properties when I've inadvertently created them with the wrong data type.  As I mentioned, I found a Dimension attribute collection method in the Planning client...
PerformancePoint Planning: Deleting a Custom Member Property..
Update:  I've posted a solution to Deleting a Custom Member Property here I've done this countless times; I've created my perfectly named Custom Member Property when it suddenly dawns on me that I've forgotten to give it the right...
New PerformancePoint Contoso Demo - Released
Amidst my write up of the first day of the Microsoft BI Conference , I mentioned a new planning demo suite was imminent, and I would post more information about the demos soon.  Well, as it has now been officially released (27th October) I can spill...
Microsoft BI Conference - Day 3 - 8th October 2008
The last day of the conference came round quickly and due to my relatively early flight I only attended a couple of sessions and spent most of the day meeting more people in and around the BI community.  Shout out to Peter Eberhardy (PeterEb), a...
Microsoft BI Conference - Day 2 - 7th October 2008
Day 2 kicked off with some good key notes and still full of steak from day 1 I hauled myself to TK Anand and Akshai Mirchandani's session on Optimising Query Performance in AS 2008.  For me this was one of the best sessions of the conference...
Microsoft BI Conference - Day 1 - 6th October 2008
So, although later than the trail blazers , I thought I'd write up a brief note about day one of the Microsoft BI Conference.  The 'Kilimanjaro' announcements have been done to death although I've noticed a couple of crossed wires...
Dynamic Range, Time Property Filter = Empty Matrix - A bug?
I think I've found a bug in the way the Excel Add-In generates MDX under certain 'rolling' conditions.  The requirement I have is to be able to forecast at the day level for a rolling 6 months; starting from the current period (which...
The Second Annual Microsoft BI Conference, 6th-8th October 2008 - Seattle
I was unable to make the first Microsoft BI Conference in Seattle last year but Tim made it, and reported that it was a great excuse for an extended weekend of partying and snowboarding in Whistler way to meet like minded people, learn the latest buzz...
PerformancePoint Planning - Loading the account dimension members from CSV
More for my benefit this post; I can never remember the format for the CSV file to load the Account dimension.  Below is an example csv file in it's simplest form that should help get me started faster the next time I need it ! Label,Name,Description...
An unknown server error occurred when submitting User
We recently had to turn a couple of demo boxes into a 2 client development environment for an overly aggressive PPS-P deadline.  Both demo boxes were connected to the network and both were PPS-P Servers.  We wanted to nominate a specific box...
More Posts Next page »