Category: Oracle Reports

Auditing & Monitoring in Jaspersoft

In the world of Business Intelligence, that deals with a huge amount of data, Auditing and Monitoring are necessary in order to analyze who is using the data, how much data is used and frequency of usage. Jaspersoft Server licensed edition provides Auditing and Monitoring features in the built-in form of domains, views and reports. Users can turn on and off auditing and monitoring from Config level. The following are some of the Jaspersoft Auditing and Monitoring features and usage. • Auditing and monitoring settings can be configured from the file,applicationContext-audit.xmllocated in the WEB-INF. By default, the auditing and monitoring subsystem is off. • The audit data can be moved to separate database tables through a mechanism called “Archiving”. • Adhoc views can be created using Audit Domain and Audit Reports, Audit Archive Domain and Archived Audit Reports that are available in the Jaspersoft Server. • Audit reports contain information about general and repository events, user events, role events, as well as report events. • Monitoring reports only contain information about report events. Monitoring can be done using the Domain, views and reports available in Jaspersoft server under /Public/Monitoring folder. Views and reports can be created on top of Monitoring […]

Read More +

Frames in Jaspersoft Reports

Jaspersoft reports

A frame is an element that can contain other elements and optionally draw a border around them. Since a frame is a container of other elements, in the document outline view the frame is represented as a node containing other elements. A frame can contain other frames, and so on recursively. To add an element to a frame, just drag the new element from the palette inside the frame. Alternatively, the user can use the outline view and drag elements from a band into the frame and so on. The position of an element is always relative to the container position. If the container is a band, the element position is relative to the top of the band and to the left margin. If the container is a frame, the element coordinates are relative to the top left corner of the frame. Since an element dragged from a container to another does not change its top/left properties, when moving an element from a container to another its position is recalculated based on the new container location. Advantages of using a frame: • When the user moves a frame, all the elements contained in the frame move. • While using a […]

Read More +

Classic and Interactive reports in Oracle Apex

Oracle Apex

Interactive reports: Interactive reports is a formatted result of a SQL query. Interactive reports can be created with both Create Application Wizard and Create Page Wizard. It supports only Desktop applications. Users can customize the report layout and data displayed. Multiple interactive reports per page can be included and developers can restrict the capabilities available to end users. In the application Report functionality, is the same across all reports. End users can customize how and what data displays while viewing an interactive report. By default, in the first column of each row, interactive reports include a search bar, an Actions menu, column heading menus, and edit icons. Classic Reports: A classic report is a formatted result of a SQL query. Classic report creation is supported by both the Create Application Wizard and Create Page Wizard. End users cannot customize a classic report except for sorting and simple filtering. To create a classic report, developers either select a table or provide a SQL statement. Classic reports support general keyword search capability, the ability to specify the number of rows that display, and basic column sorting. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more […]

Read More +

Oracle HCM Fast Formulas

OBIEE

Oracle Fast Formula is a tool to write formulas using English words and basic mathematical functions to perform calculations or comparisons. You can use information from your database in formulas without learning the database structure or a programming language. • Fast Formula is an easy way to customize the existing functionality in Fusion Benefits and it hides the complexity of accessing the database tables and columns. • Formulas can take input from a Global window, a database, or a process, such as a payroll run and they return values or messages. • Different formula types are used across various parts of Fusion HCM applications such as Payroll, Benefits Human Resources HCM Extracts, Compensation Management, Absence Management and Oracle Time and Labor. • Formulas are made up of several different components. These can include assignment statements, different types of input including database items, functions, nested expressions, and conditions. • Fast formulas can be used across various Fusion HCM products to perform payroll calculations, define rules for paid time off (PTO) accruals, calculate absence duration, edit rules for object group population for elements or people and so on. • There are predefined formulas for some specific purpose such as accrual plans, tax […]

Read More +

What Is “HCM” And How Can It Help Your Business?

Oracle Fusion HCM helps aid your business in and increase ROI, but what is Human Capital Management? Read our blog to find out more about the latest Oracle Business Intelligence Tools that help global and small businesses.

Read More +