Category Archives: Customizing

LDAP how restrict the login to members of certain groups in OBIEE?

he question is – if you can mix LDAP and other type of authentication. In one word – yes and no.

Here’s what Oracle suggests:

1. You can have internal authentication and LDAP authentication. eg users in the rpd, and users in the LDAP.

For users not defined in the repository, the presence of a defined session system variable USER determines that external authentication is performed.
So using this method, you can have groups with internal users using the internal security, and groups with users that use the LDAP authentication.

But you cannot mix external table and LDAP authentication for example, as you cannot have different connection pools on same init block.

2. The best option would be to create your own authentication Dll (Custom authentication) so  you will have full control on what systems you will lookup for the user account.
You can write your own DLL in C++ , and have OBI Server invoke it. BI just pass the username/pwd received, and wait for an authenticated/no authenticated message from the dll.

This exists since 10.1.3.2.

We provide an example of such dll.
Location for the sample one: D:\OracleBI\server\SDK\CustomAuthenticatorSamples

I wonder if anyone tried it – I think that at this time, it’d be easier to work around the requirement by using standard methods. Let’s see what John Minkjan might say about it.

OBIEE version control

Mark Rittman has written a very thorough useful guide on using Subversion for version control in OBIEE. [ad#ad-1] I think this sort of strategy would be very appropriate for a large-scale project with many OBIEE developers. I’m personally using regular abundant backups of my project files, however, it might not be intuitive to someone else. I wonder how much effort does it take to maintain version notes?

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

Something interesting I found while browsing OBIEE docs. This should be incredibly useful to force users select enough columns for the report.

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

This is explained in Oracle Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Answers > Blocking Requests in Answers

To locate the documentation please navigate to OTN: http://www.oracle.com/technology/documentation/bi_doc.html
Then drill on “Oracle Business Intelligence Enterprise Edition Documentation”
> View Library (for the required version) > Documentation tab > Oracle Business Intelligence Presentation Services Administration Guide

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”.

OBIEE Customization

How many times have you had a client asking you to customize obiee’s look while developing their business intelligence system? I’m not talking about really advanced techniques (where you’d change the OBIEE’s look and feel completely), just about loosing the standard look. I believe that the easiest way of doing this is by changing default logos with your images with the same dimensions.  However, if you need more, then you should go and read John Minkjan’s blog that has an excellent series of OBIEE’s customization tips and tricks.

Change or remove the Powered by Oracle image

Would you like to change/remove the “Powered by Oracle” image link in OBIEE Answers/Dashboards. The file (“siebelbug.gif”) path is known, but which *.css file does it exist in?

1. Open OracleBI\web\msgdb\l_en\messages\productmessages.xml file.
2. Search for the fmap:siebelbug.gif line on this file
3. Replace it for fmap:empty.gif and save it.
4. Restart Oracle BI Server and Oracle BI Presentation Server Services in order to apply this changes. Or if you are already logged in the application, prior to stop and start both services, you can click on Settings > Administration. On the Administration window opened, click on Reload Files and Metadata. Wait a few seconds, then go back and access the Download Link. The changes will be applied there.