Category: BI Publisher

Developing Global and Local repositories in Informatica


Informatica repository is used to store metadata information which will reside in a relational database. We can develop local and global repositories to share metadata information. Global Repository is the hub of the repository domain which is used to store common objects that multiple developers can use through shortcuts. A global repository cannot be converted to local repository and these objects may include operational or application source definitions, reusable transformations, mapplets and mappings. Informatica local repository is any repository within the domain that is not the global repository and it is used for development. These local repositories can create shortcuts to objects in shared folders in the global repository and can promote local repository to global repository. 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 +

An Overview of Jasper Reports Scriptlet Class

Scriplets in Jaspersoft

Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. A scriptlet is a java class, which must extend either of the following classes: • net.sf.jasperreports.engine.JRAbstractScriptlet − This class contains a few abstract methods that must be overridden in every implementation. These methods are called automatically by JasperReports at the appropriate moment. The developer must implement all the abstract methods. • net.sf.jasperreports.engine.JRDefaultScriptlet − This class contains default empty implementations of every method in JRAbstractScriptlet. A developer is only required to implement those methods depends upon the needs of their project. The following table lists some of the methods in the above class. These methods will be called by the report engine at the appropriate time, during the report filling phase. Method Description public void beforeReportInit() Called before report initialization public void afterReportInit() Called after report initialization. public void beforePageInit() Called before each page is initialized. public void afterPageInit() Called after each page is initialized. public void beforeColumnInit() Called before each column is initialized. Any number of scriptlets can be specified per report. If no scriptlet is specified for a report, the engine still creates a single […]

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 +

DataTerrain’s Datamasking tool protects sensitive data

401K Saving Plan

DataTerrain, a leader in Business Intelligence solutions, announced the launch of its Data masking tool for customers who are looking to protect their sensitive data. Using DataTerrain’s data masking tool, customers can mask sensitive data with ease and become compliant with various privacy laws. Data Terrain’s data masking tool masks sensitive data in Non-Production environment by an automated process and it reduces the risk of a data breach in Non- Production environments where data is more vulnerable. This masking activity is one-way and irreversible. Data Terrain’s data masking tool first discovers the sensitive columns available in the database by scanning the data dictionary to find where all sensitive data is located. Sensitive columns will be discovered based on the pre-defined entries in the config file. The tool also retains referential integrity, check constraints and unique constraints and uniqueness(if a unique index exists). DataTerrain is committed to being ahead of customer BI and data needs, delivering state-of-the-art solutions to increase business productivity while reducing costs. DataTerrin’s Datamasking tool is one of the products which will achieve these goals. Customers using Datamasking tool will typically benefit from 80% reduction in effort in masking and protecting their data. Please contact for a […]

Read More +

Hiring Challenges

Oracle HCM Analytics

There are many challenges in the hiring process, but it is the beginning of a successful company. Getting this right is an absolute necessity for all the companies. Identifying the challenges are going to help to prioritize current needs, trends, and tools to solve. Even for large scale companies with great HR teams a modern analysis can throw new insights and thoughts to find new gaps and guide to fine tune the process. For an example let’s take questions such as Lack of On-boarding – Why some of our hires are not showing keen interest in joining us? Lengthy Recruitment Process: Is lengthy recruitment process a good gate keeper or a damper? Data and trends at your fingertips! The answers to above questions to a large extent is in tracking HR metrics. That HR metrics to great depths can be found in your own HR software. DataTerrain analytics team can help companies to know themselves better and use data to improve their success in hiring. If you are already a user of Oracle HCM then you are one step ahead of the game. DataTerrain has an array of flexible pre-built analytical reports that are ready to install to perform the […]

Read More +

How to document a Tableau Dashboard

Tableau and dashboards

Clear and well-written documentation can be a map that makes troubleshooting or updating dashboards a less painful process. Creating Comments in Dimensions and MeasuresYour data source dimension or measure field names may often be unclear or have a specific meaning unique to the data source. A data dictionary or an individual with knowledge of the data source may not be immediately available. Adding a comment to the dimension or field clarifies those fields and serves as a reference for you or your client. Creating Comments in Calculated FieldsIn any given workbook, you can create numerous calculated fields. Knowing exactly why you made a calculated field or what it does at the time is easy, but recalling that reason at a later date can lead to frustration and eat up valuable time. Organizing Fields into FoldersIn workbooks that contain multiple dashboards and worksheets, looking for specific fields can be daunting. One way to make this easier is to group your fields into folders. By default, Tableau organizes workbook fields alphabetically by data source table. To organize fields into folders, follow this step View Data icon in the Data Pane and select Group by Folder. Leveraging Sheet DescriptionsThere are multiple locations where […]

Read More +

Machine Learning Insights in Amazon Quicksight

Machine Learning

Amazon QuickSight enterprise edition has introduced decision making insights using machine learning techniques. These are the benefits: ● Manual analysis, customer development, or machine learning domain expertise is not required to perform this action.● These insights can be embedded into a dashboard which creates a shared understanding of the data within the organization and helps t you make decisions faster.● ML powered anomaly detection can continuously examine all your data to detect anomalies.● Auto narratives can build rich dashboards with embedded narratives to tell the story of your data in plain language.● Custom insights enable you to create your own computation using your own words and it can be added to the analysis. 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 +

Jaspersoft Core Benefits Over Other BI Platforms

OBIEE migration

Jaspersoft has various benefits and features that are helpful in real-world reporting and analytics. The following are some of the Jaspersoft Core features: • Pixel-perfect reporting: Jaspersoft offers very advanced control of page size and typography for the users to generate pixel-perfect invoices, forms and receipts reports which are to be printed. • Native Barcode support: Barcode plays a vital role in Business intelligence reports in the retail and manufacturing sector globally and contains key information including manufacturer data, cost price, retail price and unique identifiers. Jaspersoft supports Barcode functionality by simple drag and drag approach of the Barcode component from the palette. It supports Barcode4J and Barbecue libraries. • Subreports with highly complex layouts: Subreports can be designed with complex layouts and mapped in the main report with parameters passed from the main report to the subreport. In complex scenarios where there is a requirement to return values from another layout, return values feature from the subreports can be used. • Style Template libraries: In BI Reporting, there is a common requirement for using the same style across a lot of reports that falls under the same category. For example, using Bold and Italics styles for all Invoice reports. […]

Read More +