Registration is at 5.30, evening will commence at 6pm and finish 9pm.
"PEL vs MDX - what are the differences between the two languages?"
Tim Kent, 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
Using Excel Services with Analysis Services and MOSS 2007
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.