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

cognos string function on olap data

Started by cognos05, 30 Aug 2020 04:39:26 PM

Previous topic - Next topic

cognos05

Hi,

I have a level in customer haiving this value.

MASKILL TERRITORY - 001 - ABC - MICHIGAN DISTRICT - MICHIGAN AREA - ABCD188

I want to show this as  MASKILL TERRITORY - MICHIGAN DISTRICT

Meaning always gets the data before first '-' and the one between 3 and 4 '-'

Thanks,