Print Page - cognos string function on olap data

Title: cognos string function on olap data
Post by: cognos05 on 30 Aug 2020 04:39:26 PM

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,

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 30 Aug 2020 04:39:26 PM