There’s going to be another one of the UK SQL Server Community’s BI Evening events happening at Microsoft UK’s offices at TVP in Reading on the evening of July 17th. It’s been far too long since the last one, I know – we’ve all been a bit distracted by SQLBits (and there’s going to be another one of those on September 13th – do you or our company want to sponsor it?).
You can sign up here:
Here’s what we’ve got lined up:
"PEL vs MDX – what are the differences between the two languages?"
Jeremy Kashel, Adatis
Jeremy Kashel from Adatis presents an introduction to the PerformancePoint Expression Language (PEL). The content will be geared towards MS BI developers, and will highlight the differences between PEL and MDX, with the aim that those with MDX experience will be able to make a fast start with PEL
"Using Excel Services with Analysis Services and MOSS"
Jeremy Kirkup, TAH
If you are just starting to explore delivering BI solutions with Excel Services and Sharepoint then there are some issues that it is wise to be aware of in advance. This session will describe some real world lessons gained while creating BI solutions which expose Analysis Services data through the Excel Web Access web part.
The Excel 2007 client has first class support for the some of the advanced features of Analysis services such as drill-through. However, when exposing pivot tables to a browser through the Excel Web Access web part this feature is not available. The session will discuss a couple of approaches to implementing drill-through functionality for EWA based pivot tables using the MOSS SmartPart, AJAX and the Excel Web Services.