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

How to compare data sets

Started by tommi, 05 Jun 2007 02:58:36 AM

Previous topic - Next topic

tommi

I am trying to create YTD column in my report.

I have created a time dimension, which I use when I prompt user for a current period. The YTD value should be calculated based on this value.

My time dimension looks like this:
-UTC DATES
-   YEAR
-   QUARTER
-   MONTH
-   DAY

I use periodstodate to get the members for YTD

periodstodate([Model].[UTC DATES].[UTC DATES].[YEAR];[CURRENT_PERIOD])

[CURRENT_PERIOD] is the value obtained from tree prompt (param_TimePeriod)

The periodstodate seems to work just fine. If I choose 2007/April, it returns 2007/Jan, 2007/Feb, 2007/March, 2007/April.

But when I try to create a YTD_EURO column with IF-structure, It all fails with error message "Invalid to compare Sets in expression for a dataItem="YTD_EURO"".

[YTD_EURO]: IF ([Model].[UTC DATES].[UTC DATES] IN ([YTD])) THEN ([EURO]) ELSE (0)

Is there any one who could so me the correct direction in this situation.




manojs

application: report studio v8.3

I would like to create a prompt to include as a selection some of the calculated members, but it will not allow me to select the calc mems upon trying to create the prompt, in fact you cannot even see the calc mems at this stage, help pls,thx