Print Page - Can we get a Substring in Report Studio for a Cube source Package

Title: Can we get a Substring in Report Studio for a Cube source Package
Post by: Venu_Gollapudi on 24 Jul 2008 11:25:10 AM

Hi,

I have requirement, in which I have to retrieve a substring for a column, the values of the columns will be like this

SCHWARTZBERG, MORI - 10 NEPTUNE BLVD NEPTUNE , NJ 07753|40.22|-74

end of that values few numbers have been separated with Pipe symbol [|] those I need to pull them in to two separate columns, for example in the above value I need to pull 40.22 into one columns and -74 into another column, can we do like this in report studio..

Also let me know if we can do by using any MDX function.

Thanks in advance,
Venu.

Title: Re: Can we get a Substring in Report Studio for a Cube source Package
Post by: Venu_Gollapudi on 25 Jul 2008 01:43:43 AM

Hey Guys, I only did it man, we can achieve this by using the functions
'position','char_length' and 'substring'

Cheers,
Venu Gollapudi.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Venu_Gollapudi on 24 Jul 2008 11:25:10 AM