How to locate the reoccurring character in the string

Hello Here is an interesting requirement. Look at the below report: You notice that all of the PWE IDs have 3 '_'. Now I want to know the location of the last '_' in the string, what do I do? OBIEE has locate and LocateN function at our disposal. However, the locateN function doesn't work that well, but the Locate Function does work. So let's start with that: Create a new column and enter: LOCATE('_', Pseudowire."PWE ID", -1) the '-1'...

Read More

Working with Go URL and passing parameters to dashboards and reports

Hello It's been a while. Today, I am going to talk about GO URL and how to make it work. This can be very handy once you make it work.  The idea of GO URL is that, it will be able to navigate to other BI Contents, such as reports and dashboards while passing certain parameters along. This can be very useful if you are coming from external application navigating into OBIEE.  So let's look at a few URLs I wrote and we will break it down: 1....

Read More