Hi,
I have this query : Query1 (yearEnd, YearStart, StartMeasure, EndMeasure)
Ok, then with this data for a filter (YearEnd = NNNN) or (YearStart = NNNN)
Figure NNNN is 2009, then you could have this rows :
Row YearStart YearEnd StartMeasure EndMeasure
1. 2009 2010 1 1
2. 2009 1 0
3. 2009 2011 1 1
4. 2009 2009 1 1
5. 2008 2009 1 1
Ok, with this data displayed, I need urgently create a Calculated Measure for each one, Start/End Measures, in order to calc a 1 value when YearStar is same value than NNNN, in this case 2009, and a 0 if this one if not equal. Same for YearEnd.
So my results should looks like this :
NNNN = 2009
Row YearStart YearEnd StartMeasure EndMeasure CalcStart CalcEnd
1. 2009 2010 1 1 1 0
2. 2009 1 0 1 0
3. 2009 2011 1 1 1 0
4. 2009 2009 1 1 1 1
5. 2008 2009 1 1 0 1
In this way, i mean, when do a Calculated item with a Total() for each calculated measure, I will get 4 for Start calculated measure and 2 to the end calculated measure.
And calculated measure formula should looks like this, and please correct me if i am wrong :
case [MyPack].[DateDim].[AllDatesHyr].[Years].[LongName property] WHEN ?NNNN? THEN 1 ELSE 0 END
It does not shut any error, but at run time, no value is displayed. What's wrong?
Thanks in advance!
Please, Help me!
Dalsom.