Category: Oracle Reports

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 +

Jaspersoft Community vs Professional Editions

Jaspersoft provides Community and Professional editions by which customers can choose one based on the requirement. The following are major feature differences of Jaspersoft Community and Professional editions, which will help to determine which software edition is right for you • Customers can take advantage of the Jaspersoft Community Support Forum with a discussion on various topics and with patches and software updates. Professional edition offers Commercial license and guaranteed support with issue troubleshooting. • Jaspersoft Community edition provides software updates as soon as they are available. Commercial edition can be upgraded based on the management release cycle. • Jaspersoft allows numerous ways for database connectivity through JDBC drivers. In Professional edition apart from connecting to direct database, a metadata layer called Domain is available. Domains can be created from Jaspersoft Professional edition server and reports can be generated on top of domains. • With respect to Charts, Community edition supports JFree Charting with support on the properties and rendering via the Community forum. In addition to the JFree Charts, Professional edition supports HTML5 charts, Maps Pro, Charts Pro, Widgets Pro and Tibco Maps. HTML5 charts are more attractive and can be used to create interactive reports. They are designed […]

Read More +

Jaspersoft Built-in System Parameters

Report parameters are used in many different ways inside a report. They can be used in the where condition of an SQL query, or to provide additional data to the report. Parameters are the best communication channel between the report engine and the execution environment. Jaspersoft Reports provides some built-in parameters that the user may read but cannot modify or delete. The following are some of the major built-in parameters of Jaspersoft: • REPORT_PARAMETERS_MAP – it contains the parameter values defined by the user. • REPORT_CONNECTION – holds the JDBC connection used to run the SQL query. • REPORT_MAX_COUNT – allows the users to limit the records from the data source. • REPORT_LOCALE – contains the resource bundle desired locale • REPORT_TIME_ZONE – Sets the time zone used to fill the report. • REPORT_TEMPLATES – This is an optional collection of styles (JRTemplate) that can be used in addition to those defined in the report. • IS_IGNORE_PAGINATION – User can switch the pagination system on and off with this parameter. 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 […]

Read More +