cancel
Showing results for 
Search instead for 
Did you mean: 

How to use joins in Webi Query Builder

kirankumar440
Participant
0 Kudos
272

Hi All,

I need to get the below details like : SAP BW Bex Query , Webi Report name which is using that Bex Query , Folder path in the entire system

For that I probably need to apply joins right to get the above details.

But, when I use joins , the query builder is not working . Could you please confirm joins are not supported there ? If yes how can I get my required details ?

Any inputs will really help us.

Br

Kiran K

View Entire Topic
DellSC
Active Contributor
0 Kudos

You are correct, joins are not supported.  However, you might be able to use the "BI on BI" universe to get it.  If that doesn't work, you'll have to either look at a third-party tool - APOS and Wiisdom have good ones - or write code using either the Java or .NET SDK to get this info.

-Dell

kirankumar440
Participant
0 Kudos
Thanks @DellSC for the response . we will explore further on that.
kirankumar440
Participant
0 Kudos
Hi @DellSC , I am able to find that Universe , In my case could you please help me with the filter criteria & list of the Columns name which I need to bring into output ?
kirankumar440
Participant
0 Kudos

Hi @DellSC , I am able to find that Universe , In my case could you please help me with the filter criteria & list of the Columns name which I need to bring into output ?

I need list of Webi Report names Vs BEX Query name 

kirankumar440_0-1728920325614.png

 

DellSC
Active Contributor
0 Kudos
Unfortunately, I don't have access to an active BOBJ system as I'm not consulting on BOBJ any more. So, I can't try to work through this to give you instructions. Sorry!
kirankumar440
Participant
0 Kudos
Ok Thanks @DellSC for the inputs