Category: BI Publisher

Machine Learning Insights in Amazon Quicksight

Machine Learning

Amazon QuickSight enterprise edition has introduced decision making insights using machine learning techniques. These are the benefits: ● Manual analysis, customer development, or machine learning domain expertise is not required to perform this action.● These insights can be embedded into a dashboard which creates a shared understanding of the data within the organization and helps t you make decisions faster.● ML powered anomaly detection can continuously examine all your data to detect anomalies.● Auto narratives can build rich dashboards with embedded narratives to tell the story of your data in plain language.● Custom insights enable you to create your own computation using your own words and it can be added to the analysis. 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 +

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 +

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 +

How to view Element Entry Details in Oracle HCM

Prebuilt Oracle

DataTerrain’s prebuilt Oracle HCM report provides all element entry values for a given payroll relationship. Element Entries associated with an employee which is used to display a specific element of each employee.   This report can be run for the below parameters Start Date End Date This Prebuilt report is available as a BI Publisher Data model report. Output: The output data will have Employee record, Audit action, Field Name, Old and New value 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 +

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

401K Saving Plan

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 +

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 +

Hiring Challenges

Oracle HCM Analytics

There are many challenges in the hiring process, but it is the beginning of a successful company. Getting this right is an absolute necessity for all the companies. Identifying the challenges are going to help to prioritize current needs, trends, and tools to solve. Even for large scale companies with great HR teams a modern analysis can throw new insights and thoughts to find new gaps and guide to fine tune the process. For an example let’s take questions such as Lack of On-boarding – Why some of our hires are not showing keen interest in joining us? Lengthy Recruitment Process: Is lengthy recruitment process a good gate keeper or a damper? Data and trends at your fingertips! The answers to above questions to a large extent is in tracking HR metrics. That HR metrics to great depths can be found in your own HR software. DataTerrain analytics team can help companies to know themselves better and use data to improve their success in hiring. If you are already a user of Oracle HCM then you are one step ahead of the game. DataTerrain has an array of flexible pre-built analytical reports that are ready to install to perform the […]

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 +

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 +