Logical Sql in a GO Url

There are a lot of good posts on how to us the GO Url functionlity in Oracle BI EE. One thing which isn’t covered very often is the use of ‘OR’ in a prompted-GO Url.

If you want to filter sales <= 5000 or sales >= 15000 it seems not possible via the ‘standard’ GO Url structure. An alternative is using Logical Sql in the GO Url;

saw.dll?Go&SQL=select+Region,Dollars+from+SupplierSales

In this case ‘SupplierSales’ is the Subject Area.

It is possible to add a where-clause to the select statement. I created the following example:

The first link contains a Go URL with Logical Sql.

saw.dll?Go&SQL=SELECT+"Dim Time"."Calendar Month", "Fact Sales Amounts"."Sales Amount"+FROM+Sales

The result of this link;

The second link has a Go URL also, but this one includes Logical Sql with a where-clause.

saw.dll?Go&SQL=SELECT+"Dim Time"."Calendar Month", "Fact Sales Amounts"."Sales Amount"+FROM+Sales+WHERE+"Fact Sales Amounts"."Sales Amount"+<=+5000+OR+"Fact Sales Amounts"."Sales Amount"+>=+15000

The result of this second link;

Unfortunately these forms of the Go URL return tabular results only.

Author: Daan Bakboord

I am an Oracle Business Analytics Consultant with great interest in anything closely related to the Oracle Business Analytics (OBIEE, BICS, Big Data, Data Integration, Data Visualization) .

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s