The service interface for our example is very simple, consisting of one method that can be called by the sample portlet to retrieve the location information, based on a zip code.

In this sample, only one database is used, but in a multiple database solution, the derived business object classes can override this method, returning their appropriate home Notes database instance.

Now we will explain the method of how to create dynamic reporting based on Role based security by using one of our sample packages, "Great Outdoors Warehouse". (Figure 2).