Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Dec
26
awarded  Popular Question
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