THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | May 15, 2017

BIRT Reports: Restricting Users

The following approach will restrict users running reports to see only the records that belong to sites they have access to. The benefits of this approach are:

It’s dynamic

There’s no need to hardcode the SITEID into the query. The user can change their default insert site and re-run the report to see a different set of data:

It uses Maximo’s security model

The list of values in the “Default Insert Site” will only display the sites that the user has access to (based on the sites listed under “Sites” tab of the security groups that they are part of). This ensures that the user cannot run the report for a site they don’t have access to:

Implementation:

1. Add a new report parameter “userName” (case sensitive). This is an internal parameter used by the report and auto-populated by Maximo with the ID of the user that is running the report:
2. Use the parameter in your main query:

3. When you add the report to Maximo (via the “Report Administration” application and “Import Report” action), make sure you delete the “userName” parameter. The user must not see this parameter for two reasons:

  1. It is auto-populated by Maximo with the ID of the user that’s running the report
  2. We don’t want the user to run the report under a different user’s ID who has access to sites the current user doesn’t.

4. For reports that need to be run for multiple sites (whether it’s multiple sites at once or one different site at a time), we can do the following:

  1. Add SITEID as an optional parameter (multi-select)
  2. If SITEID parameter was left blank by the person running the report, we will default the site in the query to their default insert site as described above.
Adel Rustum

Adel Rustum

Adel has been providing consultancy services for Maximo since 2011, tackling everyday user reported issues, implementing solutions, developing new functionality, and making recommendations on using industry best practices. He has international experience in working with clients of different industries, and currently he is based out of BPD's office in Calgary, AB, Canada.

0 Comments

Custom servlet in Maximo

Custom servlet in Maximo

What is a servlet? Servlets are Java classes which service HTTP requests and implement the ‘javax. servlet. HttpServlet’, an abstract class that implements the servlet interface and is specially designed to handle HTTP requests. A  servlet accepts the request,...

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

Integration is often a key component for getting the most out of your critical IT applications. Modern Enterprise Asset Management systems such as IBM Maximo are designed for integration which can expand their capabilities and allow the flexibility that the industry...

How to call a Report directly from the Action Menu in IBM Maximo

How to call a Report directly from the Action Menu in IBM Maximo

In IBM Maximo, it’s possible to add a direct print option to a report. This adds a printer icon to the toolbar and allows you to run the report with just one click. But for reports where there are parameters required before running, this is not possible… Usually, a user will have to click the “Run Reports” action, then find their report in the list of all reports available for that application. They then click on the one they want before being taken to the IBM Maximo Reports Request page. In this blog I’ll show you how to get around that problem. in our example we use an Action launch point for an Automation Script and link it to a menu item in IBM Maximo Application Designer…

Helpful tips to remember when starting a Maximo Implementation

Helpful tips to remember when starting a Maximo Implementation

After nearly 20 years of implementing Maximo for various organisations across a myriad of industries, there are some basic design principles that I like to follow on a new (greenfield) Maximo installation. Please note that these are some of my personal preferences but...

Implementing Drill-through in a BIRT report

Implementing Drill-through in a BIRT report

More often than not, we may be working with a report which lacks all the necessary details about a particular Work Order or asset. In this instance, we need to access Maximo and retrieve the relevant record to obtain the information we are after. Wouldn’t it be so...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.