Category: BI Publisher

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 +

Developing Global and Local repositories in Informatica

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 +

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 +

How to view Element Entry Details in Oracle HCM

Prebuilt Oracle

DataTerrain’s prebuilt Oracle HCM report provides all element entry values for a given payroll relationship. Element Entries associated with an employee which is used to display a specific element of each employee.   This report can be run for the below parameters Start Date End Date This Prebuilt report is available as a BI Publisher Data model report. Output: The output data will have Employee record, Audit action, Field Name, Old and New value for each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it 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 +

Prebuilt HCM Report to audit employee’s 401K Contribution Limit

401K Saving Plan

401K is a popular retirement saving plan provided by the employer which helps employees to save for their retirement years. Every year, there is a contribution limit set for the 401K plan which will be deducted from the Employee’s payment. This deduction should be done as per the defined limit and any employee who has contributed over the limit should check these before their annual tax filing, failing which will invite penalties. ReportDescription: DataTerrain’s Prebuilt report helps the Employer and the Employee to get quickly the list of employees who have contributed more than the limit set for a year. Parameters: This report can be run for a date range so that Users can view the contributions that occurred in a particular date range, generally for a financial year. Parameters available in the report are listed below: • Effective Start Date/End Date • Person Number • Legal Employer • Payroll This report is available as a HCM Extract and BIP report. Based on User’s preference, it can be run from a Checklist or BI Publisher Catalog.Prebuilt HCM Report to audit employees 401K Contribution Limit Output: The output data will have details regarding the person number, latest assignment number and status, […]

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 connect@dataterrain.com for a […]

Read More +