Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Hi All,

recently I came across a requirement to merge two Queries where the values of one of the merged dims had leading spaces.

Values from Query 1 dim was :

id            value   

"123"     1

"345"     2

"567"     3

and the values from Query 2 was

id               dim1

"   123"      a   

"345"         b

" 567"        c

Simply merging this dimensions will lead to the following values for the merged dim

merged id

"   123"

" 567"

"123"

"345"

"567".

How to get the merged values as

"123"

"345"

"567"

and use the other objects from the Queries like ?

merged id     val     dim_det

"123"           1           a

"345"           2           b

"567"           3           c

Steps :

1 - merge both queries on [id] onto [merged dim],

2 - create a dimension variable [final merged dim] = Trim([merged dim]),

3 - create a detail variable for [dim],  [dim det] = Trim([dim]) whit associated dimension = [final merged dim],

4 - use [final merged dim], [val] and [dim det] on your report.

Regards,

Rogerio

1 Comment
Labels in this area