Skip to Content
0
Former Member
Jul 29, 2008 at 12:02 AM

Concatenate multiple path entries in SAP BW 7.x

9 Views

Hi everyone

I'm trying to concatenate in a text web item a range of dates using Dynamic Parametrization entries. I want to do something like the following:

Fiscal years selected:

2006 - 2008

Actually i can get the first value date using this path entry:

path="VARIABLE_CONTAINER?/VARIABLES/VARIABLE[@name=&apos;<Variable name>&apos;]/SELECTIONS/SELECTION[1]/LOW_VALUE/MEMBER/@text"

And i know that i can get the other value using this path entry

path="VARIABLE_CONTAINER?/VARIABLES/VARIABLE[@name=&apos;<Variable name>&apos;]/SELECTIONS/SELECTION[1]/HIGH_VALUE/MEMBER/@text"

I want to do something like this:

path="VARIABLE_CONTAINER?/VARIABLES/VARIABLE[@name=&apos;<Variable name>&apos;]/SELECTIONS/SELECTION[1]/LOW_VALUE/MEMBER/@text" - path="VARIABLE_CONTAINER?/VARIABLES/VARIABLE[@name=&apos;<Variable name>&apos;]/SELECTIONS/SELECTION[1]/HIGH_VALUE/MEMBER/@text" 

to get the result:

Fiscal years selected:
         2003 - 2008

Does anybody know about some documentation or a clue of how to do this?

Thanks for your help

Martin