Deploying Ad Hoc Reports for NexJ CRM

Ad Hoc Reports are run-time configurable reports that users generate in NexJ CRM.

Ad Hoc Reports use a Business Intelligence (BI) model, rather than the operational business model, to optimize the performance of reports. The BI model contains the classes and attributes that you report on. Ad Hoc Reports also require JasperReports Server, which is a separate reporting environment containing a reporting database that reports are generated from. Data in the reporting database is updated by the NexJ synchronization engine, which synchronizes data from your operational databases to the reporting database.

Overview of deployment process

The deployment process involves both deployment and developer tasks. To deploy Ad Hoc Reports:

Enable BI and Ad Hoc Reports and functionality: In NexJ Studio, create a Business Intelligence (BI) model. Then create a reporting environment and a reporting database. After the BI model and reporting environment are created, use NexJ Admin Console to activate the Ad Hoc Reports workspace, assign privileges to users, and set up synchronization between the reporting and operational database.; Note: Creating the BI model is a developer task and must be performed in NexJ Studio by a person with access to the model.
Deploy Ad Hoc Reports: Deploy and configure JasperReports Server on your application server. You can deploy JasperReports Server on IBM WebSphere Application Server, NexJ Server, or Red Hat JBoss Application Server.
Configure Ad Hoc Reports: After deploying ad hoc reports, import the catalog.zip BI catalog, test the Business Intelligence (BI) data source connection, and change the default superuser password.