Category: BI Publisher

Prebuilt HCM report to reconcile PayCheck Details

HCM paycheck

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 +

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 +

Developing Global and Local repositories in Informatica

informatica

Informatica repository is used to store metadata information which will reside in a relational database. We can develop local and global repositories to share metadata information. Global Repository is the hub of the repository domain which is used to store common objects that multiple developers can use through shortcuts. A global repository cannot be converted to local repository and these objects may include operational or application source definitions, reusable transformations, mapplets and mappings. Informatica local repository is any repository within the domain that is not the global repository and it is used for development. These local repositories can create shortcuts to objects in shared folders in the global repository and can promote local repository to global repository. 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 +

An Overview of Jasper Reports Scriptlet Class

Scriplets in Jaspersoft

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

401K Saving Plan

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 +

How to view W2 Report Details in Oracle HCM?

W2 Report Details in Oracle HCM

Report Description: DataTerrain’s Oracle HCM prebuilt report file is a Form W-2 for each employee who pays remuneration, including non-cash payments of $600 or more for the year (all amounts if any income, social security, or Medicare tax was withheld) for services. This Prebuilt report is available as a BI Publisher data model report.Output: The output data will have W2 Box element details for each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it 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 +

How to create Alternate Row backgroundcolor in Jaspersoft reports

Scriplets in Jaspersoft

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 +

Creating Queries in Jaspersoft Reports

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 +

Quest Webinar – PeopleSoft HR and Oracle HCM reports

Quest Webinar

Quest Webinar – PeopleSoft HR and Oracle HCM reports No images? Click here Quest Forum Digital Event July 14 | 1 PM ET PeopleSoft HR and Oracle HCM reports Webinar by DataTerrain Inc.     PeopleSoft HR reports upgrade   PeopleSoft HR reports to Oracle HCM   Advantages of Oracle HCM Pre-Built reports   Join DataTerrain @ Quest Oracle Community   REGISTER NOW Dataterrain Inc 228 Hamilton Ave, Palo Alto, CA 94301, USA Preferences  |  Unsubscribe  

Read More +