performing a join across reports

building reports webintelligence
1

Hello,

I’m using Web Intelligence Rich Client for BO Enterprise XI. And I’m still somewhat new to the BO world. I’ve tried searching around the boards and asking some of my co-workers who know BO but I am unsure if this is possible. Right now, I have a report that pulls back a list of user id’s for work pending approvals. The way our system is designed, that data is stored in a seperate table then the actual user data. So, I can’t just do a reference back to the user data to grab the names.

If I try and pull in the user’s names and email address, BO tells me I can’t do it, because it will produce a Cartesian product. So, I’ve just been manually creating a seperate report of all the users and then using a VLOOKUP in Excel to pull in the user’s data that I need. I am now needing to send this data out 5-6 times a day, and it’s time consuming, so I’d like to just have it automatically send the email.

Is there a way to use ‘Column A’ from Query 1 as a constant for Query 2 or can someone think of a way that I’m just not thinking of here to simplify this…I’m pulling out my hair here… :hb:

spriguy21 (BOB member since 2009-11-18)

2

there needs to be an ID field that is common in both queries, and then if the type and name are the same, Web-I will merge them automatically, creating the reference needed to match up the data.

Then you’ll need to create variables which are details of the ID in order to show them in a block of data from the other query.

If creating the same criteria in both queries is not possible, then you can make the usernames query based on the results of the first one.

Good luck.

rdougherty :us: (BOB member since 2008-10-06)