How to implement VLOOKUP function in OBIEE 11G - Filter Based on Results of Another Analysis

Most of users who are using OBIEE are basically trained to use Excel sheets and have come from using excel background and want to achieve all of the functionality in OBIEE as compared to Excel.

One of the function is VLOOKUP which is nothing but just is filter which in OBIEE can be used by using usual filters , but this topic talks about using VLOOKUP as in two separate excel workbooks.

How to lookup when we have two different reports.

E.g. We have a report having Purchase Order, Product Name and Price from Accounts Payable Subject Area , another report where we have details of Open Purchase Orders from Purchase Orders Subject Area. Requirement is to get only those Products whose Purchase Order is Open.

Assumption : These two reports are unrelated in OBIEE and this information cannot be obtained from single report from same subject area and there is no conformed dimension to combine these two Subject Areas.

We can create two separate reports and then use Filter Based on Results of Another Analysis to lookup Products which have Open Purchase Orders.

Step 1: Create Report with Open Purchase Orders and save

Step 2 : Report with Product Price and Purchase Orders , Contains all Purchase Orders irrespective of PO Status.

Step 3: To lookup Open Purchase Orders from Open Purchase Orders Report created at Step 1 , Add a filter and choose Operator as is based on Results of another Analysis

Step 4: choose the Report Name and relationship and then Column Name to filter the records.

Step 5: Click on OK and save this analysis. This report now will give you the results based on a filter from other report.



Note: In case of issues or further questions, you can reach me out and I will be happy to answer.