Do you know how to add JS code to your OBIEE site?
It all started with a bug in OBIEE (version 10.1.3.4) and ended with a wonderful solution that can help us in future problems. Look at the following report table:
|
Customer |
Day |
Shop |
| A |
1/1/2000 |
EBay |
| B |
15/2/2002 |
AdventureWorks |
| C |
28/5/2005 |
Office Depot |
Building the Business Model layer and the report correctly will take care that clicking on the EBay link will take us to the Ebay shop page (in OBIEE, not ebay.com) which is prompted on 1/1/2000 and customer A. This happens because the Shop report is also prompted on Customer and Day. The problem starts when we sort the table by the shop name:
|
Customer |
Day |
Shop |
| B |
15/2/2002 |
AdventureWorks |
| A |
1/1/2000 |
EBay |
| C |
28/5/2005 |
Office Depot |
I would expect that clicking on the EBay link will make the same thing as before, but actually it prompts the Shop page on Customer B and 15/2/2002. It seems that the report saves the original location of the record instead of prompting on the actual record! In order to solve that I written a small JS code that enables us to navigate based on previous fields in the report (See the attached file). In order to use it we need to change the link. Edit the column properties, go to the Data Format tab, check "Override Default Data Format", Pick Treat Text As Custom Text Format and in the editbox enter the new link. A link example can be found in the attached file. Note that the third parameter for every field is how much fields to go back.
The great thing about this solution is that it doesn't only solves this particular issue. It enables you to prompt on every logical column, no matter on which column the original value was shown.
BIPortalPageNav.js (1.04 KB)