Category: Business Intelligence

Jaspersoft Report Built-in Charts

Jaspersoft report has a built-in support for charts using the new chart component. Using a new chart component, user needs to apply only the visual settings and define expressions that will help build the chart dataset. JasperReports uses JFreeChart as the underlying charting library. When configuring a new chart component, following three components are involved – • The overall chart component • The chart dataset (which groups chart data-related settings). • The chart plot (which groups visual settings related to the way the chart items are rendered). Jaspersoft Reports offers built-in support for a variety of chart types as listed below: • pieChart: A combination of a Pie dataset and a Pie plot. • pie3DChart: Groups a Pie dataset and a Pie 3D plot. • barChart: A basic combination of a Category dataset and a Bar plot. • bar3DChart: Wraps a Category dataset and a Bar 3D plot. • xyBarChart: Supports Time Period datasets, Time Series datasets, and XY datasets, and uses a Bar plot to render the axis and the items. • stackedBarChart: Uses data from a Category dataset and renders its content using a Bar plot. • stackedBar3DChart: Uses data from a Category dataset and renders its content […]

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 reporting with JSON (JavaScript Object Notation) Datasource

Jaspersoft business intelligence reporting can be done using a JSON data source. The following are some features and benefits of Jaspersoft with JSON data source. • In the BI world, time is taken for data retrieval and memory consumption are the key factors in determining efficiency and performance. With JSON data source, Jaspersoft offers to transport data between a server and a client (web) application provided with increased efficiency and performance. • A JSON file with the actual report data can be passed to the report either from a file location or from a remote location. Once a data-adapter is created using a JSON file, the fields from the JSON can be used in the report layout. • The data-adapter from the Jaspersoft studio can be downloaded and uploaded to the Jaspersoft Server and the same report can be run from the server also. • The JSON data source can also be passed as a parameter from the main report to the sub-report in the sub-report connection expression properties. • JSON data-source offers a lightweight syntax and ease of use. Reports can be created quickly once the data are populated in the JSON file. • JSON data-source has wide advantages […]

Read More +

Balance Groups in Oracle Fusion HCM

Balances in HCM are amounts or hours that are aggregated based on Month, Quarter or Year. Balance Group and Balance Group Usages for the specific Balances can be created from the Payroll Calculation work area in the Oracle Fusion HCM environment. Oracle HCM Fusion provides us the option of using either Pre-defined balance groups or User-defined custom balance groups for our reports. Pre-defined Balance groups in HCM contain information about all the earnings and deductions but if we would like to see only the amounts or hours of a list of earnings. User-defined custom balance group can be created with the list of earnings that we require and use it in our custom extract to view only the values for those earnings. Data Terrain 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 +

HCM in the Cloud Drives Customer Success

Data driven tasks such as BI support and automated reporting are driven by advancements in OBIEE and HCM Cloud applications. Utilizing these resources has become a large part of business intelligence. See how BI report support in the cloud helps businesses to succeed.

Read More +

Jasper Reports Global Scriptlets

When complex functionality cannot be achieved easily using report expressions or variables, JasperReports provides us with a simple and powerful means of doing this with Scriptlets. Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. User can associate scriptlets by declaring the scriptlets globally. The global scriptlets apply to all reports being filled in the given JasperReports deployment. This is made easy by the fact that scriptlets can be added to JasperReports as extensions. The scriptlet extension point is represented by thenet.sf.jasperreports.engine.scriptlets.ScriptletFactory interface. Jasper Reports will load all scriptlet factories available through extensions at runtime. Then, it will ask each one of them for the list of scriptlets instances that they want to apply to the current report that is being run. When asking for the list of scriptlet instances, the engine gives some context information that the factory could use in order to decide, which scriptlets actually applied to the current report. Data Terrain 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 […]

Read More +

Jaspersoft Report creation phases

The main purpose of Jasper-Reports is to create page-oriented, ready to print documents in a simple and flexible manner. The creation life cycle has the following distinct phases: • Designing the report: User creates the JRXML file, which is an XML document that contains the definition of the report layout. • Compiling the report: JRXML is compiled in a binary object called a Jasper file (*. jasper). This compilation is done for performance reasons. Jasper files are what user need to ship with their application in order to run the reports. • Executing the report: Data from the application is filled in the compiled report. The specified Jasper class provide necessary functions to fill the data in the reports. A Jasper print file (*. jrprint) is created, which can be used either to print or export the report. • Exporting the report to the desired format: User can export the Jasper print file created in the previous step to any format using JasperExportManager. As Jasper provides various forms of exports, hence with the same input, we can create multiple representations of the data. Data Terrain with years of experience and reliable experts is ready to assist. We have served more […]

Read More +

Steps to integrate Jaspersoft Studio with Server

Jaspersoft studio and Jaspersoft server are separate applications which can be installed separately and integrated together. Jaspersoft Studio can be integrated with Jaspersoft server and allows to access and modify the resources. The following are steps to integrate Jaspersoft studio with Jaspersoft server: • In the Repository Explorer section of Jaspersoft Studio Server can be added by clicking on “Create JasperReports Server Connection” which displays the “Server Profile Wizard”. • Server name, URL, username and password can be entered, and the connection can be tested and created. • The server setup from the Jaspersoft studio is a onetime process and once done reports, subreports and other resources like images can be published from the Jaspersoft studio. Integrating Jaspersoft studio and Jaspersoft server provides the following benefits: • The same data source used in the Jaspersoft studio can be created in the server also and can be mapped when publishing the report. • For LOV parameters, corresponding Input controls with respect to the parameters can be created in the server and can be mapped to the reports once published. Similarly, all the resource files like images, fonts, JAR files, Style sheet templates, Resource bundle files and input controls can be created […]

Read More +

Steps to Deploy an RPD in BICS

The RPD deployment process in BICS is different from that of a on-premise OBIEE environment. In the BICS you do not have a separate service to deploy the RPD, instead you have an option within the BICS URL to upload the RPD • Click the console icon from the BICS URL • Click the icon “Snapshots and Models” from the list of options. This will navigate to the snapshot system state page • From the available options, choose “Replace Data Model” and from the file chooser menu, select the RPD file to be uploaded to the BICS • Provide the RPD password and click OK to upload the RPD. This process might take a few minutes and after a successful RPD upload, you will see a message “Data Model was successfully replaced with [repository file name]” • The RPD upload to the BICS does not require any server downtime and the users might have to use the refresh metadata option to have the latest RPD in their active session 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 […]

Read More +