Category: BI Publisher

Jaspersoft Core Benefits Over Other BI Platforms

OBIEE migration

Jaspersoft has various benefits and features that are helpful in real-world reporting and analytics. The following are some of the Jaspersoft Core features: • Pixel-perfect reporting: Jaspersoft offers very advanced control of page size and typography for the users to generate pixel-perfect invoices, forms and receipts reports which are to be printed. • Native Barcode support: Barcode plays a vital role in Business intelligence reports in the retail and manufacturing sector globally and contains key information including manufacturer data, cost price, retail price and unique identifiers. Jaspersoft supports Barcode functionality by simple drag and drag approach of the Barcode component from the palette. It supports Barcode4J and Barbecue libraries. • Subreports with highly complex layouts: Subreports can be designed with complex layouts and mapped in the main report with parameters passed from the main report to the subreport. In complex scenarios where there is a requirement to return values from another layout, return values feature from the subreports can be used. • Style Template libraries: In BI Reporting, there is a common requirement for using the same style across a lot of reports that falls under the same category. For example, using Bold and Italics styles for all Invoice reports. […]

Read More +

Prebuilt HCM Report to audit employee’s 401K Contribution Limit

401K is a popular retirement saving plan provided by the employer which helps employees to save for their retirement years. Every year, there is a contribution limit set for the 401K plan which will be deducted from the Employee’s payment. This deduction should be done as per the defined limit and any employee who has contributed over the limit should check these before their annual tax filing, failing which will invite penalties. ReportDescription: DataTerrain’s Prebuilt report helps the Employer and the Employee to get quickly the list of employees who have contributed more than the limit set for a year. Parameters: This report can be run for a date range so that Users can view the contributions that occurred in a particular date range, generally for a financial year. Parameters available in the report are listed below: • Effective Start Date/End Date • Person Number • Legal Employer • Payroll This report is available as a HCM Extract and BIP report. Based on User’s preference, it can be run from a Checklist or BI Publisher Catalog.Prebuilt HCM Report to audit employees 401K Contribution Limit Output: The output data will have details regarding the person number, latest assignment number and status, […]

Read More +

Pre-built – HCM Report to Track Payroll and TRUs

The Prebuilt Multi-Org Transfer Report has excellent functionalities to tracks all changes that occurred in an employee that has transferred between TRUs (Tax Reporting Unit) and/or Payrolls. This Prebuilt report can be run for an effective date or organization name or employee number which could be scheduled and delivered to an FTP Server/Email as per the user’s requirement. Enhancements such as adding new parameters or conditions to this report are simple. The output type, by default, is Excel which is also customizable to any other format. DataTerrain’s Prebuilt reports usually are built in the below 3 reporting formats: 1. HCM Extract 2. BI Publisher Data model reports 3. OTBI Some users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP/OTBI. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. The Pre-built Multi Org Transfer Report captures the following major functionalities and it is customizable: The existing seeded Payroll Activity Report or Employee Active Balance Report do not list out employees […]

Read More +

Salient Features of Jaspersoft Server

Jaspersoft Server (also called JasperReports server), is the core of the Jaspersoft BI Suite. It builds on the JasperReports Library to provide a fully functional and stand-alone report server. Jaspersoft Server provides many important features such as security, a repository, and scheduling. • Jaspersoft server can be downloaded and installed separately. Once installed it can be accessed via the URL andfrom Jaspersoft studio. • Jaspersoft Server commercial edition offers a complete user-friendly web-based drag and drop Adhoc reporting feature. Users can build interactive charts, tables and cross tab analytics. • Jaspersoft server supports all datasource connectors that are available in Jaspersoft library. • Jaspersoft server provides flexible, modern and embeddable server architecture such as data caching and storage architecture, REST and SOAP based web services for simplified integration, mobile application and multi touch capability and so on. • Report scheduling based on a calendar can be performed for the deployed reports from the Jaspersoft server. • Security setup can be done by Administrators from Jaspersoft server by providing user based and role-based access to reports, dashboards, resources and folders. • Jaspersoft server Commercial edition also has the capability to design a metadata layer called Domain with business logic and joins. […]

Read More +

Prebuilt HCM report to reconcile PayCheck Details

Oracle has seeded reports such as Payslip and Paycheck but at times Users would like to have a report which will have a summarized information of the data that is available on the Payslip/Paycheck so that they can reconcile this report’s data with Oracle’s report in order to confirm the amounts produced are correct in all these reports. Users can run this pre-built report when they would want to see, 1. The total amount processed for a particular paycheck date 2. To confirm if the amounts produced for a paycheck date is correct in the Oracle’s seeded reports. 3. To check the total amounts processed for each paycheck date separately in a huge check date range that they run. DataTerrain’s Prebuilt report: The Prebuilt report Paycheck Detail will provide the Users with data such as employee number, employee name, pay period start/end date, element name, element description, the sum of earnings and sum of earnings hours. Users can run this report with the below parameters, 1. For a single Check Date/For a range as Start Check Date and End Check Date 2. For a single Person 3. For a Payroll This report is built as an HCM Extract in order […]

Read More +

How Increased Productivity in the Cloud Pays Off

HCM in the cloud can help your organization increase productivity. Our BI support team shows you how to use report conversion software to create and manage business analytics within your organization. Peoplesoft reports play a large part in BI; Here’s how.

Read More +

Charting Functionality in Jaspersoft

JasperReports support many built-in charts created using the popular open source library JFreeChart. These charts help to create visually compelling reports and dashboards. • Chart components of the Jaspersoft reports simplify the way to insert the charts into the reports and also the process of gathering chart data becomes easier. • When compared to other reporting tools many varieties of charts can be created in Jasper such as Pie, Pie 3D, Scatter, Bubble, High-Low-Open-Close, Candlestick, Gantt, xyBarChart, linechart etc. • Pixel perfect report designer includes layouts containing charts and images are being supported in all types of editions. • Characteristics such as orientation and background color can be defined in jasper reports. For instance, the label rotation attribute allows the text labels on the x-axis to rotate clockwise or anti-clockwise. • Configuration can be done for all charts such as a border around all sides, title font, show/hide legend, plot area background color, subtitle font etc. • Commercial editions provide advanced HTML5 charts which are interactive DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in […]

Read More +