185 reputation
7
bio website omicron-llama.com
location Nottingham, United Kingdom
age 29
visits member for 2 years, 6 months
seen Oct 19 '12 at 14:18

Senior SharePoint and Business Intelligence Consultant for Intelligent Decisioning Ltd, a Microsoft Gold Certified Partner based in Nottingham UK specialising in SharePoint, CRM and Workflow.

I'm experienced with WSS 3.0, MOSS 2007, SharePoint Foundation 2010, SharePoint Server 2010, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MDX Scripting, Workflow & WCF.

I'm certified to MCPD SharePoint 2010 Dev, and MCTS WSS & MOSS Config

I spend way too much time online.


Jun
26
asked MDX Block Calculation Optimisation
Jun
6
accepted Need to filter dimension where two attributes are the same
Jun
4
awarded  Self-Learner
Jun
2
awarded  Teacher
Jun
2
answered Need to filter dimension where two attributes are the same
Jun
2
asked Need to filter dimension where two attributes are the same
Apr
12
accepted SQL Calculation based on 'similar' rows within table
Apr
12
comment SQL Calculation based on 'similar' rows within table
Ah, understood. Agreed the EXISTS should be faster. Thanks again.
Apr
12
comment SQL Calculation based on 'similar' rows within table
? I thought that was a self join inside the EXISTS... what else did you have in mind otherwise?
Apr
12
comment SQL Calculation based on 'similar' rows within table
Missing a closing bracket round the subquery in that code snippet, (also I think you mean c2.date instead of cd.date but that self-join seems to be the way forward I think... Cheers!
Apr
12
awarded  Student
Apr
12
asked SQL Calculation based on 'similar' rows within table
Apr
12
awarded  Scholar
Apr
12
accepted SSAS Modelling - many to many with one dimension
Apr
12
comment SSAS Modelling - many to many with one dimension
In absence of better answers, I'll mark this as correct, as its the closest to what we got to a working solution.
Apr
12
awarded  Supporter
Feb
8
awarded  Tumbleweed
Feb
1
asked SSAS Modelling - many to many with one dimension
Feb
1
awarded  Autobiographer