Category: Oracle Reports

Jaspersoft Community vs Professional Editions

Jaspersoft provides Community and Professional editions by which customers can choose one based on the requirement. The following are major feature differences of Jaspersoft Community and Professional editions, which will help to determine which software edition is right for you • Customers can take advantage of the Jaspersoft Community Support Forum with a discussion on various topics and with patches and software updates. Professional edition offers Commercial license and guaranteed support with issue troubleshooting. • Jaspersoft Community edition provides software updates as soon as they are available. Commercial edition can be upgraded based on the management release cycle. • Jaspersoft allows numerous ways for database connectivity through JDBC drivers. In Professional edition apart from connecting to direct database, a metadata layer called Domain is available. Domains can be created from Jaspersoft Professional edition server and reports can be generated on top of domains. • With respect to Charts, Community edition supports JFree Charting with support on the properties and rendering via the Community forum. In addition to the JFree Charts, Professional edition supports HTML5 charts, Maps Pro, Charts Pro, Widgets Pro and Tibco Maps. HTML5 charts are more attractive and can be used to create interactive reports. They are designed […]

Read More +

Jaspersoft Built-in System Parameters

Report parameters are used in many different ways inside a report. They can be used in the where condition of an SQL query, or to provide additional data to the report. Parameters are the best communication channel between the report engine and the execution environment. Jaspersoft Reports provides some built-in parameters that the user may read but cannot modify or delete. The following are some of the major built-in parameters of Jaspersoft: • REPORT_PARAMETERS_MAP – it contains the parameter values defined by the user. • REPORT_CONNECTION – holds the JDBC connection used to run the SQL query. • REPORT_MAX_COUNT – allows the users to limit the records from the data source. • REPORT_LOCALE – contains the resource bundle desired locale • REPORT_TIME_ZONE – Sets the time zone used to fill the report. • REPORT_TEMPLATES – This is an optional collection of styles (JRTemplate) that can be used in addition to those defined in the report. • IS_IGNORE_PAGINATION – User can switch the pagination system on and off with this parameter. 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 […]

Read More +

Auditing & Monitoring in Jaspersoft

In the world of Business Intelligence, that deals with a huge amount of data, Auditing and Monitoring are necessary in order to analyze who is using the data, how much data is used and frequency of usage. Jaspersoft Server licensed edition provides Auditing and Monitoring features in the built-in form of domains, views and reports. Users can turn on and off auditing and monitoring from Config level. The following are some of the Jaspersoft Auditing and Monitoring features and usage. • Auditing and monitoring settings can be configured from the file,applicationContext-audit.xmllocated in the WEB-INF. By default, the auditing and monitoring subsystem is off. • The audit data can be moved to separate database tables through a mechanism called “Archiving”. • Adhoc views can be created using Audit Domain and Audit Reports, Audit Archive Domain and Archived Audit Reports that are available in the Jaspersoft Server. • Audit reports contain information about general and repository events, user events, role events, as well as report events. • Monitoring reports only contain information about report events. Monitoring can be done using the Domain, views and reports available in Jaspersoft server under /Public/Monitoring folder. Views and reports can be created on top of Monitoring […]

Read More +

4 Ways Advanced Onboarding Can Increase Productivity

Advanced Onboarding and Productivity: Why You Need to Rethink Your Current HCM Approach There is a plethora of information regarding onboarding and its consequent benefits. In fact, most companies thrive through onboarding. According to reports, companies that do not apply onboarding process in their business strategy end up using up 150 percent of their revenue to retain unproductive employees.

Read More +

How to view Annual FSA non-Discrimination Testing Details in Oracle HCM

Oracle HCM FSA

DataTerrain’s prebuilt report performs various tests on the plan annually at the end of each plan year. This is to determine the number of non-highly compensated individuals who are eligible to participate in the Flexible Spending Account limits. And also designed to ensure that the plan does not discriminate in favor of Highly Compensated Employees. This report can be run for different Years and is available as a BI Publisher Data model report.Output: The output data will have Assignment and Personal Information, and Eligibility Status of each employee for a given period.The output format of this report is Excel and can also be rendered as PDF/CSV.Schedule: Payroll Team can also schedule the report to be delivered weekly/bi-weekly and used for a regular audit.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Guidelines to create Key Ranges in Informatica


The key range partitioning in Informatica distributes rows of data based on a port or set of ports that you define as the partition key. Guidelines to create key ranges are mentioned below. ● The partition key must contain at least one port. ● The range for each port in the partition key should be specified. ● The Informatica PowerCenter standard date format can be used to enter dates in key ranges. ● The workflow manager does not validate overlapping string, numeric ranges, the gaps, or missing ranges. When you define key range partitioning at a source qualifier transformation, the Informatica Integration Service defaults to pass-through partitioning if you change the SQL statement in the Source Qualifier transformation. If a row contains a null value in any column or falls outside of the key ranges then the integration service sends that row to the first partition. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +