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 rename the dynamic column text

Started by ravindravoggu, 18 Nov 2009 09:20:31 AM

Previous topic - Next topic

ravindravoggu

Hi All,

I have a hierarchy column like Currency which is coming from dimensional data. When i run the report(Cross tab) it displays currencies like USD,EURO,GBP,Blank,etc.... as columns. My user wants to display USD instead of Blank in the column title. Is there any way to display?.  Any one have idea please let me know it is very urgent.

Thanks in Advance.

Ravi.

vinu

Try With

CASE
When  EURO THEN EURO
WHEN GBP THEN GBP
WHEN BLANK THEN USD
......
...
END.

Thanks,
Venu

ravindravoggu

I have tried with this but it's not working.Reason is these currency codes are coming form cube.

Thanks,
Ravindra.

Pradeep

HI Ravi ,

You can try with below

WITH
   MEMBER [currency codes ]
   AS
      CASE [currency codes ]
      When  EURO THEN 'EURO'
      WHEN GBP THEN 'GBP'
      WHEN BLANK THEN 'USD'
      Else ' ..'

END

Regards
Pradeep

ravindravoggu

Hi Oradeep,

It does not work in these report becoz it is dimensional data so it is comming from Cube directly.
Thanks..

Regards,
Ravinder.

CognosPaul

Try using a text source variable.

Set up a string variable. Add the string 'Blank' to it. Select 'Blank' from the Condition Explorer, and set the node member to whatever text you want.

Note that if you have multiple members with the caption 'Blank' this will not group them. This only effects the way the text for the labels is generated.