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

Problem with the intersect function

Started by Tobias, 12 Mar 2010 04:37:47 AM

Previous topic - Next topic

Tobias

Hi,

I built a simple crosstab report. I put a simple measure in the row area of the crosstab. In the column area I put a data item with the following expression:

IF (intersect(set(#promptmany('Parameter1';'token')#);set([Accessoires];[Campingausrüstung])) is not null) THEN
    ( [Bergsteigerausrüstung] )
ELSE
    ( [Produkte] )

In the case that the input parameter doesn't contain the elements Accessoires and Campingausrüstung the expression works as expected.The ELSE part is used and the correct measure value is displayed in the crosstab.
If the input parameter contains Accessoires or Campingausrüstung but not both elements the THEN part is used and the correct measure value is displayed in the crosstab.
But in the case that the parameter contains the both elements Accessoires and Campingausrüstung, no measure value is displayed in the crosstab cell. Instead -- is displayed in the cell.

Any idea please

Thanks!


Tobias