Combine/merge tables on variables

[former_member604308]

Can I combine/merge 2 tables on a variables.

Have a table of employee details per month and have salary payments per month. In both tables the key is combi of personal id and month. I had to create variables for the keys because they are not available as separate field

[denis_konovalov]

I have fixed your tag. Please select more careful.

[TammyPowlas]

What tool are you using? BW? Universe? Web Intelligence?

[former_member604308]

I use business objects web intelligence

[amitrathi239]

How many objects in each query and how many needs to display in the table?

You need to merge personal id and month with second query objects and if there is no match for some objects then create those as detail variable and associate with Personal ID object.

[former_member604308]

I have added a print screen of the query. I believe i did the merge, but maybe i don't understand exactly what you mean.

[amitrathi239]

It's possible with Merged dimension option in webi report.If you have some doubts then share the sample data.

Check attached link for merged dimension concept.

https://www.aits.uillinois.edu/UserFiles/Servers/Server_474/File/DS/Business%20Objects/Merge%20Dimen...

[former_member604308]

Thanks Amit. I have studied this method, but my problem is that i have multiple dimensions to join (ie personal id and month). When i create a variable i can only associate it with 1 dimension.

I hope below sketch makes it more clear what my problem is

schermafbeelding-2019-02-27-om-141948.png

I can make a report of personnel and salaries with a variable as index (personal Id and month) and save these to something i can query again. Then join on the index, i have a feeling that it can be simpler.