If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Total() Urgently please help needed.

Started by DALSOM, 28 Jul 2011 01:19:38 PM

Previous topic - Next topic

DALSOM

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.