Category: Business Intelligence

Jaspersoft – Feature rich Open source BI tool

Jaspersoft is a leader among open source business intelligence (BI) and reporting tools. This is primarily due to the rich set of features which comes as part of the Jaspersoft platform. • Jaspersoft reports Server embeds the Jaspersoft Reports engine and provides a user-friendly, web-based interface for end-users to run and view reports. • Jaspersoft has an in-built report scheduler wizard through which we can set up a schedule and define the recurrence and frequency. • Different types of export options are available such as PDF, XLS, CSV, DOCX, RTF, ODT, ODS, etc. • Reports can be viewed seamlessly in desktop screen and mobile devices. • Jaspersoft server supports a variety of datastores including Oracle, PostgreSQL, and NoSQL. • Jaspersoft handles a large volume of data with ease. Jaspersoft displays the initial page of a large report quickly and then loads the subsequent pages in the background, hence the output appears to be rendered fast. • Charts, visual text rotation and graphs can be created perfectly with some in-build properties such as appearance, borders, hyperlink, chart and chart plot. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in […]

Read More +

Jaspersoft Report–Basic Element Properties and Palette

All elements have a set of common properties. Other properties are specific to the element type. An element’s properties determine its appearance and position on the page. Users can access the properties of a selected element in the Properties view (by default in the upper right area of the UI). In Jaspersoft Studio user place elements within bands (containers). Depending on the elements it contains, the user can change the vertical size of a band. The Palette: Elements appear in the Palette, located by default in the top right of the UI. The palette contains three sub-palettes: Basic Elements: It contains the elements and components available in all editions of Jaspersoft Studio Composite Elements: It contains elements created as combinations of other elements, such as Page Number and Time. Users can add their own composite elements to any palette. Components Pro: contains elements only available in commercial versions of Jaspersoft Studio. This subpalette is not visible in the community edition. 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 working hours and do not need […]

Read More +

How to create Alternate Row backgroundcolor in Jaspersoft reports

Conditional styles combined with some specific report built-in variables can be used to generate alternate row colors in the detail section of Jaspersoft reports. As known, the detail section is repetitive and contains common layout information for records in the dataset. For each record in the dataset, a detail section filling process is called at fill time. Being related to records, one of the most common layouts used for the detail section is the table row layout. And like in any other table, alternate row colors might be needed. To obtain alternate row colors, two things are necessary: 1. To know the current record number in order to determine if it’s odd or even. 2. A conditional style with specific style properties for odd or even rows. The first requirement is accomplished with the help of report built-in counting variables: • REPORT_COUNT – If the row color alternation does not depend on the page, column or group breaks. • PAGE_COUNT – If each new detail page should start with the same row color. • COLUMN_COUNT – If each new detail page column should start with the same row color • <group_name>_COUNT – If each new group of records should start […]

Read More +

DataTerrain provides customized Oracle HCM Payroll and Audit reports

DataTerrain, a leader in Business Intelligence migration solutions, announced that it has extended its Oracle HCM Payroll and Audit report creation for the latest version 19C. DataTerrain has over 10 years of experience in Planning, Design, Development, Tuning, supports a variety of Business Intelligence tools and specializes in reporting solutions. The DataTerrain team has in-depth real-world expertise in Oracle HCM application and specifically in reporting. The Payroll and Audit processes are highly complex and are not limited to providing accurate, efficient, and transparent processes in the face of massive differentiation, it also complies with local, national, and international rules in a rapidly changing, hyper regulatory environment. DataTerrain’s report creation framework starts with an analysis phase, which involves understanding the existing source report and creating a functional description document. This would be followed by the actual report development and validation. DataTerrain has customized the payroll reports by including additional details like Month-to-Date values in Employee Active Payroll Balance Report and has modified the design of report templates (like Sub Totals and Grand totals) The audit reports have been enhanced to capture Missing Employee Information like Bank Information and also identifies the changes occurred for Employee details in various Departments, Location, Manager, […]

Read More +

DataTerrain launches SAS BI to Japsersoft report conversion solution

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of a report conversion solution for customers who are migrating from SASBI to the Jaspersoft platform. Jaspersoft offers both community and professional edition which could result in significant savings in license costs. DataTerrain’s conversion solution enables customers with SAS BI reports migrating to the Jaspersoft Platform. The conversion framework includes the analysis phase, where all the source elements are examined, and the missing elements are identified, that can be used for pin-pointed analysis to narrow down to report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve. The conversion solution also includes the conversion of native functions and complex formula logics embedded in SAS BI reports and provides an equivalent solution to achieve the same in the Jaspersoft platform. Customers can take advantage of DataTerrain’s conversion solution to preserve years of effort in designing the reports while migrating to the Jaspersoft platform. DataTerrain’s conversion Services are offered under a Fixed-cost basis and for any type or number of reports basis. There are NO long-term contracts required and can be utilized for a specific project to a broader spectrum of support Please contact connect(at)dataterrain(dot)com for […]

Read More +

Suffixes help identify the purpose of Oracle HCM tables

You would see lot of tables in Oracle Fusion HCM Cloud, but you might wonder what is the purpose of the tables that end with the following suffixes such as _ALL, _TL, _VL, _V, _F, _VL, _A and so on. Below is a description provided for each of these tables: • _ALL table holds all the information about different operating units in Multi-Org environment. • _TL are tables corresponding to another table with the same name. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column. • _B tables are the BASE tables. Data is stored in the table with all validations. It is supposed that these table will always contain the perfect format data. • If anything happens to the BASE table data, then it is a data corruption issue. • _F tables are date tracked tables, which occur in HR and Payroll. These table will have the two date columns – EFFECTIVE_START_DATE and EFFECTIVE_END_DATE – which together with the primary key identifies a row uniquely. • _V tables are the views created based on the base […]

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 +