Category: Business Intelligence

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 +

Multi-tenancy in Jaspersoft

Jaspersoft supports Multi-tenancy configuration in Server level. The following are some major features and benefits of Jaspersoft Multi-tenancy. • Multi-tenancy in Business Intelligence offers various advantages to a customer like easy updates and upgrades, Shared infrastructure, lower cost and maintenance, optimized performance efficiency, development and deployment cost reduction, etc. • Jaspersoft allows achieving Multi-tenancy in Professional Server edition. • Customers can create multiple organization, assign roles, row level and column level security (in the meta-data layer called Domain) in order to achieve a multi-tenant environment. • In Jaspersoft Multi-tenant mode which comprises of users using the application from multiple organizations, information from one organization cannot be viewed by other organization users. • Multi-tenancy offers users from multiple organization with mechanisms to protect data privacy. • Jaspersoft helps users to design a Multi-tenant environment from Jaspersoft server to provide better security and data privacy in a few configuration steps. 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 contracts.

Read More +

Pluggable Custom Visualizations in Jaspersoft

Jaspersoft provides a remarkable feature for users to Create and deploy their own Custom Visualization component. The following are some of the Jaspersoft Custom Visualization component features and usage. • Jaspersoft offers an extensive feature allowing users to create their own Custom Visualization component. Users can take advantage of creating Custom Visualization component provided they have coding knowledge in Javascript, CSS and HTML. • Basically, Custom Visualization Component renders a SVG (Scalable Vector Graphics) image file. Once the component is created and deployed, it will be available in the element palette from where it can be drag and dropped in to the report. • Custom Visualization Component requires few configuration steps. Once these steps are done, users can develop their own visualization component to enrich their reports and to make the reports more flexible depending on the requirements. • Custom Visualization component in Jaspersoft can also be created using JSON that allows users to add their own Component UI (Property name , type and data items) , thumb nail image (image that appear in the design view when the component is drag and dropped from the palette) and location of the script and reference files used for the creation of […]

Read More +

Find Out Drill down in Cognos Powerplay

Drill up & down operations allows moving up and down the hierarchy of categories in a dimension. To drill down means to go from a higher summary level into more details. Drilling up expands the focus of a report and moves into a lower detail level. In Cognos Powerplay you can Drill up and down the hierarchy tree in the following ways: • Hover the mouse pointer over a category you want to explore in more details and if the cursor changes to a plus sign, it means that the drill-down is available, and you can double click the category to drill down. • Alternatively, instead of double-clicking you can right-click on a selected category and select Drill Down. • Drill down by clicking the plus sign. • To drill back up go to the cube summary row or summary column and once the cursor changes to the plus sign with an up arrow, double-click it to go one level up. • Alternatively, instead of double click you can right-click on a selected category and select Drill Up. • Drill up by clicking the summary row. • It is also possible to drill up and down in a dimension viewer […]

Read More +

Extensible Flex-Fields in Oracle HCM Fusion Application

Extensible flex-fields enables implementers to configure additional attributes or information to the Fusion Application without having to write tedious code. Unlike descriptive flex-fields where each segment or attribute is stored in the database as a single column, Extensible flex-fields stores the context values and context-sensitive segments in a separate extension table. Customers can display a group of segments together on a single page in the Application as per their needs using Extensible Flex-fields. Benefits of using extensible flex-fields are listed below: • Extensible flex-fields allow to group segments into contexts and each context is displayed in its own region. • We can decide whether to display a group of attributes in a single or multiple pages. Based on preference, we can have multiple logical pages to display a group of extensible flex-fields. • Extensible flex-fields can be configured to enable categories that dynamically displays different sets of logical pages and contexts based upon a runtime selection. The categories can be structured in a hierarchical manner and the children categories inherit all the contexts and logical pages that are configured for their parent categories. • Attribute groups created once can be re-used if multiple business object instances share common attributes. We […]

Read More +

Prebuilt HCM Report to view New Hires or Terminations

One of the crucial tasks of HR Team is to maintain a clear track of the new hires and terminations of an Organization. It is necessary for the HR Team to have reports which provide an answer to important questions such as: 1. How many employees are newly hired in the last quarter? 2. How many are terminated within a particular period? 3. In which Business Unit/Location/Department, the most or least hires/terminations occurred? 4. Newly hired/terminated employee count in a particular Payroll DataTerrain’s Prebuilt report provides details related to the new hired/terminated employees. This prebuilt report can be run for the below parameters 1. Start Date/End Date (To get employees in a date range/Quarter) 2. Payroll Name (To filter hire/terminations in a payroll) 3. Organization (Display hire/terminations in an Organization) 4. State/Location/Department (To list hire/termination by State/Loc/Dept) This report can also be run for a default period such as for capturing the hire/terminations in the past 30 days/15 days instead of passing any parameter. This report is built both as an HCM Extract and a BIP report, hence it can be run from the ‘CheckList’ section or from the BI Publisher Catalog, Users can use either Extracts or BIP report […]

Read More +