Pentaho Analysis: Workflow

OLAP Analysis: Workflow   To prepare data for use with the Pentaho/Jaspersoft OLAP Analysis (and Reporting, to a certain extent) client tools, you should follow this basic workflow : Design a Star or Snowflake Schema The entire process starts with a data warehouse.The end result should be data model in the star or snowflake schema …Read More

Restrict Menu items by Role in Jasper Server

Restrict Menu items by Role in Jasper Server We can use role-based customizations to control access to menus. The example here shows how to control access to menu items. In this example scenario, we wish to hide Create Report, Dashboard, Domain & Data Source from roles other then ROLE_ADMINISTRATOR and ROLE_HRIS. So, these menu items …Read More

Failover and Load Balancing in Jasper Server

Failover and Load Balancing in Jasper Server Installing jasper instances For sample configuration I installed two Jasperserver instances: On two separate application server (2 tomcat servers running on different port), and with Single repository (OracleDB) For detailed installation steps refer http://helicaltech.com/installing-jasperreports-server-6-0-1-with-oracle-db-in-windows/ I installed jasper server instances on localhost. These jasper servers are running on: http://localhost:9080/jasperserver-pro …Read More

Installing JasperReports Server 6.0.1 with Oracle DB (in Windows)

Installing JasperReports Server 6.0.1 with Oracle DB (on Windows) Pre-requisite Java JDK 1.6 or 1.7 should be installed. Create and set the JAVA_HOME system environment variable to point to the Java JDK location. Apache Tomcat 5.5, 6, or 7 should be installed. Oracle should be installed. Download the WAR file distribution from http://support.jaspersoft.com. The WAR …Read More

Case Study Report On PCNI OpenHMIS Reports

Case Study Report On PCNI OpenHMIS Reports   Customer : Pathways Community Network institute (PCNI) Geographical Location : Atlanta, Georgia (USA) Tools Used : DB used    : MySQL, Postgres, Oracle BI Tool       : Jaspersoft Community Edition Company Overview : Pathways helps communities strengthen responses to poverty and homelessness through increased collaboration and …Read More

Jaspersoft Ad hoc reports: Quick performance measurement & optimization tips

Measuring Ad-hoc performance 1. Log on JasperReports server as system admin (superuser by default). 2. Navigate to Manage > Server Setting > Ad hoc cache. The Ad Hoc Cache page appears, displaying all the datasets that are in the cache, sorted by age. 3. Ad Hoc performance can be quickly measured by checking values of …Read More

BI for healthcare

BI for healthcare  Healthcare organizations are going through a technology and data revolution. Pressure from a wide range of sources are forcing both providers and health plans to look at their data and technology investments in new and innovative ways to gain competitive advantage. Healthcare business intelligence can provide organizations the ability to use their …Read More

Conditional Formatting in jaspersoft’s OLAP view (mondrian jPivot)

 Conditional Formatting in jaspersoft’s OLAP view (mondrian jPivot) Open {js-install}\apache-tomcat\webapps\jasperserver-pro\jpivot\table\mdxtable.css and {js-install}\apache-tomcat\webapps\jasperserver-pro\j\mdxtable.css. In these files find the following section /* data cells */ td.cell-even, td.cell-odd, td.cell-red, td.cell-yellow, td.cell-green, td.cell-rot, td.cell-gelb, td.cell-gruen, td.property-value, td.property-span { font-family: Arial, Helvetica, Tahoma, sans-serif; font-size: 80%; /*color : Black;*/ color : #033669; text-align: right; /*border-bottom: solid 1px #000033; border-right: solid …Read More

Business Intelligence Project Lifecycle

Business Intelligence Project Lifecycle Project Planning Project life cycle begins with project planning. Obviously, we must have a basic understanding of the business’s requirements to make appropriate scope decisions. Project planning then turns to resource staffing, coupled with project task identification, assignment, duration, and sequencing. The resulting integrated project plan identifies all tasks associated with …Read More

Domain Security in a Jasper Reports Server’s Multi-tenant Environment

Domain Security in a Jasper Reports Server’s Multi-tenant Environment Create two tenants/organizations CA & WA 1. Log on Jasper report’s server as superuser. 2. Navigate to Manage > Organizations. 3. Click on ‘Add Organization’ button. 4. Enter valid organization name and id CA as Organization Name (you can give ‘California’ as Organization Name) CA as …Read More