OBIEE - How to force a user to filter on a column A every time column B is in the request

Saw Object


How to not allow the execution of the request and show an appropriate error message to the user If request contains any of the following columns: (Sales Amount, Sales Amount With Tax, Ticket Count), and if request does not contain at least one of the columns (Date, Month, Year, Day of Week)


This is possible via the Blocking Requests Based on Formula functionality using a custom js file

The documentation does not state where to place the js file.

  • Using oc4j as the web server, you need to put the custom .js in "OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\b_mozilla" in order for the fmap: reference in the CustomMessages.xml file to find it (also need to bounce both OBIPS & oc4j).
  • Using IIS, you need to put the .js file in "OracleBI\web\app\res\b_mozilla", not "OracleBIData/web/res" as the doc states (and bounce OBIPS & WWW Pub Service).

Also, you can use a full network path reference for the src argument in the custom xml file - e.g.:

<script language="javascript" src="\\mylabmachine\OracleBIData\web\res\myblocking.js" />

That way, you can place the .js file anywhere - in this example in the "OracleBIData\web\res" folder, not "OracleBI\web\app\res\b_mozilla".

Documentation / Reference

Discover More
Column Formula
OBIEE - Criteria Tab

The criteria tab of an answer is a GUI that help you to create the logical SQL. In a column formula, you can add: comment a presentation column a presentation variable a bi server variable...
Bi Server Architecture With Client
OBIEE - Filter

get the Analysis XML, indent it and apply it again of you can try to suppress the

Share this page:
Follow us:
Task Runner