Skip to Content
0
Former Member
Apr 15, 2010 at 02:57 PM

Merging queries with not exact matching data

36 Views

Hi fellow Webi and OLAP bods

Does anyone know how I can merge data from 2 different queries where the data is not an exact match?

I have one query where the key is

001

002

003

004

etc

and another where the key is

AAA001

AAA002

AAA003

BBB004

etc

basically they are the same thing but the second has this prefix in the data that I am not interested in.

If it were on oracle or some other relationanl data source I could clearly create a new object in the universe that used substr(mykey,4,3) and they'd match fine but both queries are on SAP BW datasources and I wanted to know if I can do this anyway without having to wait for our BW team to create me a new object in BW. I'm guessing my only options are with some neat MDX in the universe (I'm on xi 3.1) or with some clever stuff in the report......

Maybe I'll just do it in excel with vlookup......(again!)

Thanks

Nick