Andrew Sadler's profileAndrew Sadler's BI blogPhotosBlogLists Tools Help

Andrew Sadler

Occupation
Location
Interests
Andrew Sadler is Microsoft BI Capability lead at Edenbrook. He has charted a varied course to get there - Psychology Academia >>> IRI >>> Fulcrum Solutions >>> marchFIRST >>> Adaytum/Cognos >>> ProClarity >>> Microsoft >>> Edenbrook, and has accrued 10+ years in all things BI during this process.

Andrew Sadler's BI blog

June 22

ProClarity/OBA Seminars

Two more ProClarity\Performance Point Server Seminars being run this month:

London:

26th AM - https://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=1032343731

26th PM - https://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=1032343732

Manchester:

28th AM - https://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=1032343733

28th PM - https://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=1032343735

I will be trying to cover as much as possible including some of the new bits and pieces from CTP 3 of Performance Point Server (monitoring and Analytics).

Look forward to seeing you there.

June 18

Oracle 10g OLE DB provider for x64

Here is a link to the oracle 10g OLEDB provider for the x64 platform - this may prove useful.
 
 
(again thanks to Steve Pontello for bringing this to my attention)
 
July 11

ProClarity Update Seminars

There are two ProClarity update sessions being run at the Microsoft offices in Chertsey.
 
The morning session is designed for existing customers and partners as an update of what the acquisition and a product overview. 
 
The afternoon session is for ProClarity novices - prospects and prospective partners
 
 
Any questions then let me know. 

Introduction to SQL Server 2005 Analysis Services - TechNet event

Tonight (11th July) there is an introduction to SQL 2005 MSAS Technet event.  The details are as follows:-
 

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=118770981&Culture=en-GB.

 

Introduction to SQL Server 2005 Analysis Services

 

11 July 2006 18:30 - 11 July 2006 21:00 GMT, London

Welcome Time: 18:00

Language: English



Microsoft Ltd

Chicago 1&2

Building 3

Microsoft Campus Thames Valley Park Reading Berkshire RG6 1WG

United Kingdom            

 

General Event Information

Products: SQL Server.

 

Recommended Audience: IT Professional.

 

 

 

SQL Server 2005 Analysis Services provides an integrated view of your business data for reporting, OLAP analysis, key performance indicator (KPI) scorecards, and data mining. . This session looks at the some of the key areas that concern IT professionals. We look at various features, first viewing data then look at integrating the data sources, we will then look at analysis service cubes including calculated members and key performance indicators. Finally looking at the reporting of the data.

Demonstrations in this Session

Report viewer web part

Fuzzy lookup component

Analysis cubes

Calculated Members/key performance indicators

Creating maintaining reports

Timings:

18:00-18:30 Registration

18:30-19:30 Event

19:30-20:00 Break

20:00-21:00 Event

21:00 Event Close

Speaker-Melville Thomson - IT Evangelist, Microsoft Corporation

Blog: http://blogs.technet.com/melville/default.aspx

I started my IT career while in the services, as a Cobol programmer on Unix systems, nearly 20 years ago,. I moved into designing and building database systems for the use in the Royal Engineers Depot where I worked, using various database products. After leaving the services I moved into training and consultancy. I am passionate about helping people to develop their full potential.

My home life is taken up by my family. I love to grow my own vegetables and roses. I also like to keep fit, and do a lot of problem solving while running. I enjoy various extreme sports and will always try new ones.

Cumulative hotfix package (build 2153) for SQL Server 2005 is available

 There is a new cumulative hotfix to the SP1 release of SQL 2005.  This hotfix has many interesting items in it that can be found here, although the most interesting for many Analysis Services customers can be seen in the analysis services hotfix:-
 

50000120

In SQL Server 2005 Analysis Services, calculated members that are defined in the cube MDX script are resolved before any session or query defined calculations. The only exceptions are certain scenarios with the Aggregate and VisualTotals functions. This behavior is a change from the SQL Server 2000 Analysis Services behavior. In SQL Server 2000 Analysis Services, the Solve Order could be used explicitly to insert a session or a query-defined calculation between two cube level calculations. This change in behavior may cause the query or session scope calculated members not to return the results that you want in SQL Server 2005 Analysis Services. Cumulative hotfix package for SQL Server 2005 (build 9.0.2153) introduces new syntax that allows for control over the scope in which a calculated member is evaluated.

 

Video

No content has been added yet.
Photo 1 of 6