Jaspersoft 6.2 Features and Upgrades

Dear Jaspersoft Users, In this blog we would be talking about the latest version of Jaspersoft i.e. Jaspersoft 6.2 new features. a. Advanced multi-tenant server administration capabilities Jaspersoft in its latest release is providing more options to for administration of a multi-tenant envrionment. There is an option through which administrator can export resources for a …Read More

Is your Business Intelligence tool really Intelligent?

According to Forrester blog a typical BI tool costs $1,50,000/- and ETL costs about the same. Services, hardware and implementation generally scale up to 5 times the software cost. It is after investing so much  that most businesses realize that the solution they have purchased is not really future ready. As the business expands, number of …Read More

KPIs Staffing & Recruitment companies should track

KPIs Staffing & Recruitment companies should track   Key Performance indicators (KPIs) are business metrics which are used to evaluate factors that are crucial to the success of the organization. This article talks about most commonly used metrics and KPI’s which staffing companies needs to track in order to grow their business. Not only we …Read More

Staffing Recruitment Analytics Solution

  Staffing Analytical Solution   Recruitment is a process through which a suitable candidate is hired for the job. The process is being conducted by HR of the company itself or company hires third party HR firm for the process. HR firm manages the initial processes of recruitment like resume selection, approaching these candidates via …Read More

JDBC Connection Pooling in jaspersoft

How JDBC Resources and Connection Pools Work Together in Jasper Report’s server   JasperReports Server can access any database using the JDBC (Java DataBase Connectivity) API. We can configure two types of data sources in the repository: JDBC data source – Establishes a direct connection to the database server using its JDBC driver. JasperReports Server …Read More

Understanding and Usage of Mondrian

This blog will be talking about the different layers of Mondrian engine, its components, introduction to ROLAP etc.   Layers of a Mondrian system A Mondrian OLAP System consists of four layers; these are as follows: Presentation layer The presentation layer determines what the end-user sees on his or her monitor, and how he or …Read More

BI Solution For Property and Casualty Insurance Domain

A BI solution will help an insurance company to get a holistic 360 degree view of customers, issues faced. Helical has got immense experience in developing BI solution in Property and casulaty insurance domain. Having built more than 50 reports, 20 dashboards, geographical dashboard, adhoc reports and OLAP cubes, these BI solution can be used …Read More

Steps to migrate oracle with pentaho

Step 1:- Run script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate-settings.xml Location:- pentaho-solutions\system\hibernate\hibernate-settings.xml. Original code <config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file> Modified code:- <config-file>system/hibernate/oracle10g.hibernate.cfg.xml</config-file> oracle10g.hibernate.cfg.xml:- Location:- pentaho-solutions\system\hibernate\ oracle10g.hibernate.cfg.xml Do not need to change any code in this …Read More

Using MDX Query in Pentaho CDE

This blog will talk about Using MDX Query in Pentaho CDE In Layout Section: Design the layout of your Dashboard, from scratch or from a template – while defining the layout you can apply styles and add HTML elements as text or images. In Component Section: In side Component layout we are using different types …Read More

KPI used by Ecommerce Companies in Business Intelligence

Keeping a tab of KPI is a very good exercise and can help entrepreneurs in understanding the current state of business and the way forward.The general KPI used by Ecommerce companies are listed below (ofcourse there could be variations and a lot will also depend on the companies business goal as well). These KPI, in …Read More