Category: Oracle Reports

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 +

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 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 +

Time-series and predictive analysis using Tableau

Tableau Time series

Tableau natively supports rich time-series analysis, meaning you can explore seasonality, trends, sample your data, run predictive analyses like forecasting, and perform other common time-series operations within a robust UI. Easy predictive analytics adds tremendous value to almost any data project. By supporting both complex configuration and simple interactive modeling, Tableau serves both the data scientist and the end user.The feature resources for time-series and predictive analysis:Time-series Analysis (In Action) : Tableau is a tool that lets you leverage Time Series Analysis to analyze important trends. Tableau Time Series Analysis lets you utilize its drag-and-drop feature to evaluate times by day of the week, drill down with a click and perform time comparisons like Moving Averages and Year-Over-Year growth easily.Forecasting : Forecasting in Tableau uses a technique known as exponential smoothing. Forecast algorithms try to find a regular pattern in measures that can be continued into the future. Add a forecast to a view that contains a date field and at least one measure. However, in the absence of a date, Tableau can create a forecast for a view that contains a dimension with integer values in addition to at least one measure. DataTerrain, with years of experience and reliable […]

Read More +