Print Page - Linking Revenue data to other country in map

Title: Linking Revenue data to other country in map
Post by: saumil287 on 20 Jun 2011 05:18:13 AM

Hi All,
I am having arequirement where the revenue data of china country should be linked to India map. So I wrote the folowing code
CASE [Retailer country]
WHEN 'China' THEN ([Retailer country] = 'India')
END
but still giving an error.

Title: Re: Linking Revenue data to other country in map
Post by: Mpotla on 20 Jun 2011 07:35:34 AM

HI,

Create one data item with the expresion

CASE [Retailer country]
WHEN 'China' THEN ( 'India')
Else
([Retailer country] )
END

Hope this would help!

Regards,
McMohan

Title: Re: Linking Revenue data to other country in map
Post by: saumil287 on 23 Jun 2011 01:22:38 AM

Hi mcmohan,
I got it.
thanks

Title: Re: Linking Revenue data to other country in map
Post by: MFGF on 23 Jun 2011 02:50:42 AM

You could probably achieve this without coding an expression - just use the Dictionary property of the map to translate 'China' to 'India'. Given you already have a working solution, it's probably irrelevant this time, but if you come across the issue again in future it may save you a little coding. :)

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: saumil287 on 20 Jun 2011 05:18:13 AM