Category: BI Publisher

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 +

Properties of Jaspersoft Sub-Report Element

Subreport element is similar to a place holder defining the position of the top-left corner to which the subreport is aligned. The following properties are available in the Properties to view in the Subreport tab. • Run To Bottom: When true, the sub-report element will consume the entire vertical space available on the report page. • Expression: Expression that can be used to load the Jasper object to use when filling the sub-report portion of the document. Evaluated at run time to retrieve the Jasper object for the sub-report. • Using Cache: Specifies whether the sub-report’s report object is kept in memory or reloaded each time it’s used. It is common for a sub-report element to be printed more than once. • Connection Expression/Data source Expression: At the run time, returns a JDBC connection or a JRDataSource used to fill in the sub-report. Only one of these expression types can be used. If there is no connection or data source expression, no data is passed to the sub-report. • Parameters Map Expression: The expression must contain a set of coupled names/objects that are passed to the sub-report to set a value for its parameters. • Edit Return Values: It allows […]

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 +

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 launches SAS BI Automated Report Conversion Solution

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of Automated reports conversion solution for customers who are migrating from SASBI platforms to other BI platforms like Jasper, Cognos or OBIEE. DataTerrain’s Automated conversion solution enables customers with SAS BI reports migrating accurately to the target Platform. The Automated 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 the report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve them. The Automation conversion solution also includes conversion of native functions and complex formula logics embedded in SAS BI reports and provide an equivalent solution to achieve the same in the target platform. Customers can take advantage of DataTerrain’s Automated conversion solution to preserve years of efforts in designing the reports while migrating to new BI platform. DataTerrain’s Automation conversion services are offered under a Fixed-cost basis 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 more information. About DataTerrain DataTerrain […]

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 +

Creating Queries in Jaspersoft Reports

Jaspersoft Studio provides tools to help user define report fields and create a proper query if a query language is used to acquire the data for the report. These tools are presented in the Dataset and Query dialog. It also provides an easy way to build SQL queries by using a drag-and-drop query builder. This allows users who don’t know SQL or just are not sure about the syntax to quickly join tables and produce complex data filters and where conditions. SQL Builder also provides a way for skilled users to explore the database and list the metadata such as schemas and available tables. Using Dataset and Query Dialog: The dataset and query dialog allows a user to: • Select a data adapter with which to configure the dataset. Usually, a data adapter is selected, but it is possible to change it if necessary. • Select a query language for the dataset being edited (which can be the main dataset or a sub-dataset used to populate a chart or a table). • Specify the query by typing text or by using a tool, if available, designed for the selected language. A tool is available for several languages including SQL, XPath […]

Read More +

DataTerrain Launches Oracle BICS Support Service

DataTerrain, a leader in Business Intelligence migration solutions, launched its Oracle BICS Support services for customers who are looking to support their Oracle BICS and ODI environments. DataTerrain has over 9 years of experience in Planning, Designing, Development, Tuning, Support a variety of Business Intelligence tools and specializes in reporting solutions. The DataTerrain team has in-depth real-world expertise in Oracle BI and HCM applications. DataTerrain’s BICS support services include Health check, Development, Testing, Diagnostic and Integration services. The major activities covered are: • HCM extraction through BIACM to download the incremental changes • Customization of the existing codes and developing any new ETL plans for custom sources • Process HCM, People soft and Taleo sources files to transform and load using ODI into the data warehouse • Customize objects and security on top of the OBIA RPD file. • Support the implementation of new sources in the RPD • Build new dashboards/reports and also customize the delivered reports in BICS • Support the migrations between environments and maintain the codebase Customers can take advantage of DataTerrain’s BICS support services to provide state of the art reporting, capable of growing and adapting to changing organizational, legislative and regulatory requirements. Customer can […]

Read More +

An Overview of Jasper Reports Scriptlet Class

Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. A scriptlet is a java class, which must extend either of the following classes: • net.sf.jasperreports.engine.JRAbstractScriptlet − This class contains a few abstract methods that must be overridden in every implementation. These methods are called automatically by JasperReports at the appropriate moment. The developer must implement all the abstract methods. • net.sf.jasperreports.engine.JRDefaultScriptlet − This class contains default empty implementations of every method in JRAbstractScriptlet. A developer is only required to implement those methods depends upon the needs of their project. The following table lists some of the methods in the above class. These methods will be called by the report engine at the appropriate time, during the report filling phase. Method Description public void beforeReportInit() Called before report initialization public void afterReportInit() Called after report initialization. public void beforePageInit() Called before each page is initialized. public void afterPageInit() Called after each page is initialized. public void beforeColumnInit() Called before each column is initialized. Any number of scriptlets can be specified per report. If no scriptlet is specified for a report, the engine still creates a single […]

Read More +

DataTerrain’s Datamasking tool protects sensitive data

DataTerrain, a leader in Business Intelligence solutions, announced the launch of its Data masking tool for customers who are looking to protect their sensitive data. Using DataTerrain’s data masking tool, customers can mask sensitive data with ease and become compliant with various privacy laws. Data Terrain’s data masking tool masks sensitive data in Non-Production environment by an automated process and it reduces the risk of a data breach in Non- Production environments where data is more vulnerable. This masking activity is one-way and irreversible. Data Terrain’s data masking tool first discovers the sensitive columns available in the database by scanning the data dictionary to find where all sensitive data is located. Sensitive columns will be discovered based on the pre-defined entries in the config file. The tool also retains referential integrity, check constraints and unique constraints and uniqueness(if a unique index exists). DataTerrain is committed to being ahead of customer BI and data needs, delivering state-of-the-art solutions to increase business productivity while reducing costs. DataTerrin’s Datamasking tool is one of the products which will achieve these goals. Customers using Datamasking tool will typically benefit from 80% reduction in effort in masking and protecting their data. Please contact connect@dataterrain.com for a […]

Read More +