Category: Report Conversion

Guidelines to create Key Ranges in Informatica

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 +

How to view Employee Roster Register in Oracle HCM

Oracle HCM

DataTerrain’s prebuilt report provides the list of roster employees along with position and demographic data and assignment information. This report can be run for the below parameters • Person Type • Segment • Organization • Division • Department • Region • Country • Assignment StatusThis Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have department classifications, Job details, Annual Salary, Work Schedule of each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: HR Team can also schedule the report and use it for a regular audit.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 any long-term binding contr

Read More +

PreBuilt HCM Report to view HCM Privileged Roles Audit Report

BIP Reports

Report Description:DataTerrain’s Prebuilt report is designed to display the details of the function and data security privileges granted to specific users or roles. This information is equivalent to the information that you can see for a user or role on the Security Console. This Prebuilt report is available as a BIP report.Output: The output data will have Roles of each employee.The output format of this report is Excel.Schedule: HR Team can also schedule the report 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 +

SaaS connectors in Amazon Quicksight

Amazon Quicksight

SaaS connectors can be used to access data directly from Amazon QuickSight for analysing and reporting. ● The SaaS connectors simplify accessing third-party application sources using OAuth, without any need to export the data to an intermediate data store.● SaaS applications can be used on either cloud-based or server-based instances.● If Amazon QuickSight can’t access the application, it will generate an unknown host error.● Organizations can integrate with Adobe Analytics to build consolidated dashboards to visualize their online and web marketing data.● The SaaS source must support REST API operations for Amazon QuickSight to connect to it. `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 +

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 +

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 +

Properties view in Jaspersoft Report

The Properties view in Jaspersoft Report helps the user to configure a selected element. If more than one element is selected, only the properties of those elements have in common are shown. If the Properties view is not visible, open the context menu for the selected elements and find the Show Properties menu item, which shows and brings to the front the Properties view. Properties are organized into tabs and sections for a better organization and usability. Tabs can include the following: Appearance tab, which contains all the properties responsible for element size, position, colors, style and flags when the element is shown in the runtime. Borders tab, where user can configure how borders of the element are painted. An element tab allows the user to set evaluation time along with properties specific to the element type. For example: The Static Text tab allows the user to define unchangeable text for a field and control its appearance. The Text Field tab allows the user to format and position a text field element. The Image tab allows the user to set image alignment, fill, and scale properties. Advanced tab, which contains all the properties for the report element in the form […]

Read More +