Our blog

Our expert thoughts
Growing your business with business intelligent reporting

How Business Intelligence Tools Help Agencies Grow

Benefits of business intelligence to any organization

Business intelligence is about using technology to manage specific data in an organization. Examples of business intelligence tools include applications such as spreadsheets and querying software. However, some tools are more complex than others, for instance, data mining. The workforce in an organization uses these business intelligence tools to ensure top performance. Read more

Pitfalls to avoid during ETL Testing of DecisionStream to Informatica migration


ETL testing  differs from conventional testing in which we need to validate the data at the completion of ETL process to ensure that there is no loss, duplication or incorrect data.


Some of the major challenges to look out for when migrating from CognosDecisionStream to Informatica are:


  • Lack of Business logic data across development and Production area. This leads to new defects being found in Production when migrated from development environment.
  • The volume of the data is very large in production environment hence testing requires more time and may lead to performance issues which are complex to debug
  • The CognosDecisionStream would generate NULL values where as in Informatica it would reflect as empty space in database.
  • The sequence generated surrogate Key in Informatica sort order would not match with the DecisionStreamgenerated surrogate Key.
  • The data generated from DecisionStream would have special characters, where as in Informatica special characters was not supported hence while testing, convert function need to be used in place where special characters were found.

How to Load the Stored Procedure data-set automatically during Report initialization and insert the data to a temp table in Actuate BIRT

There are several situations where the reports need to run periodically and retrieve data for a particular time period.


Actuate BIRT allows Stored Procedure data-set by which the data can be pushed to the temp tables, but the challenge here is to invoke a Stored Procedure data-set that does not perform select but an insert operation.


You can achieve the same by creating a Stored Procedure dataset that inserts the data to the temp table based on the current SESSION_ID and then Insert a dummy Data Component in BIRT report and bind the Stored Procedure dataset.


This will load the Stored Procedure data-set automatically during Report initialization and insert the data to a temp table

Dynasoft Synergy Human Capital Management

Human Capital Management in the World of Global Business

How Human Capital Management Directs Business Efficacy

Human capital management (HCM) refers to the planned and strategic approach to managing the workforce, which is one of the most valuable assets to any organization. It is a methodology to employee staffing that sees people as important assets, whose value at the present time can be measured and whose future value through investment can be enhanced.  In order for an organization to achieve its goals, the value and efficiency of its human capital has to be constructively assessed. Herein is a brief overview of some of the key aspects of HCM. Read more

Steps to save and reuse a set of filters in Taleo OBIEE Answers

In Taleo OBIEE Answers we have an option to save a set of filters and reuse it across a shared environment. This helps to reduce the efforts in re-creating frequently used filters.

  • Create a filter or a set of filters in OBIEE Answers as usual
  • In the filters section, on the header part you will find an arrow icon (>>) which provides the option to save the set of filters that you have created
  • The operators, operands and the conditions will remain the same and this set of filter gets saved into any preferred location on the OBIEE Server
  • You can have it in your personal folders or even in the shared filters to share it among other users
  • These saved filters can be added to any of the Taleo OBIEE Answers report, from the left side pane of the criteria tab

How to get the current data in Oracle Taleo OBIEE report

Oracle Taleo OBIEE report if run the first time, will get cached if the caching is enabled. The report will be fetched from the cache for subsequent executions. This will not reflect the changes that occur in the underlying database after the first report run, as the report is coming from cache.

Steps to disable cache at the report level

  1. Edit the analysis report
  2. Navigate to the advanced tab
  3. In the Prefix text area, add the command “SET VARIABLE DISABLE_CACHE_HIT = 1;
  4. Click on the “Apply SQL” button below the text area
  5. Save the report

If you execute the report after these changes, the report will fetch the results from the database and not from the cache.

To enable the caching, remove this command from the prefix and hit “Apply SQL” button, save the report and execute it.

Person Management data for employee assignments in Oracle Fusion HCM

Oracle Fusion HCM has a feature Person Management to track all the employee Assignments, employee details

For example, we can use the Person Number, Location, Name, Effective Date to get an employee detail.

Below are the list of major factors to use the Person Management data to track all your employee assignments in Oracle Fusion HCM reports

  • To identify an employee work relationship where he/she worked and used in HCM reports
  • Action Reason Code can be used to track all the details related to Assignment level and employer level in HCM Reports.
  • To check the employee Assignment Details and also whether the employee is eligible for payroll or not. This scenario can be used to get all historical data of employee for Audit purpose.
  • We can get the Person previous and current work Address, Home Address and personal details in reports
  • Assignment Action Date can be used as a filter in the extract and report level to get the required data for an employee.
  • We can use the History Assignment entity to get the Global Transfer Data of an employee in HCM Report.

We can use the Person Management concept to obtain all data related to employees which will help in periodic tracking and also for Audit purposes.

Why use Element Entries based reports in Oracle Fusion HCM during Payroll cycle.

Oracle Fusion HCM Element entries provide a good snapshot at the elements going to be processed on our employees next paychecks – compensation, benefit or taxation details for earnings and deductions.

It would be very difficult to go through every employee record to see if she/he is wrongly contributed to incorrect elements or if she/he needs refund on the tax deductions.

To make the validations simpler you can create an analysis report on your Oracle Fusion HCM system which makes your payroll process an easy one.

Below are the list of major scenarios that your organization might need HCM extract to pull data for

  • To identify if anyone has contributed to the incorrect elements and need a refund.
  • If there is particular range of amounts for certain elements that needs to be reviewed before processing.
  • If Deduction Contribution needs have been reviewed.
  • Check if any employee have contribution limit on particular element and see if it exceeds limit set IRS/Tax systems.
  • If an element has a negative value.
  • To identify if there are any employee is transferred and had benefit and/or compensation deductions that may need setup on their new company.
  • List of active contributions/deductions.

We can have multiple reports based out of extracts to pull the above information for the whole organization which can also help in Payroll Auditing Process apart from our periodic validation.

Simplify Extract scheduling in Oracle Fusion HCM

In Oracle Fusion HCM there are multiple options to view or extract the output. But to simplify the process of scheduling we can set up the extract to deliver the output directly to our Inbox.

We can use the BI server to schedule the report and deliver. But scheduling extract based BI reports is a tedious process since we have to wait for our payroll flows to complete and then the BI report has to be scheduled separately; it is 2 step process.

Oracle Fusion HCM provides an Extract option from which output can be delivered just by running the Payroll Flow, so there is no need to Schedule the BIP Reports every time you create a new flow. This can be achieved by configuring the Extract to deliver the output through various options like Email, Fax, FTP, or Print

Here are the steps to configure the Extract for delivering the output through Email.

  1. Select the extract that we need to configure delivery option and go to extract Delivery Options and Click on Add to create a new delivery option.
  1. Then Specify the Delivery Option Name, Output Type, Report Path, Template Name, Output Name and Delivery Type and click on Save.
  • Delivery Option Name –Report Name
  • Output Type – can be any of PDF, EXCEL, EXCEL 2007, etc..,
  • Report – The path of the BIP Template located (i.e. Report Layout)
  • Template Name – Name of the Template Uploaded BI server
  • Output Name – Can be given of our Own
  • Delivery Type–Select the Email option from dropdown, and mention the Subject, From and To address and other required columns.

The above steps completes the simplified scheduling configuration and the report is scheduled for delivery.

Streamline Payroll Using Oracle Fusion HCM

Payroll process is an important and highly complex business function. Oracle Fusion HCM Payroll solutions help to streamline the complex requirements needed to operate in today’s global economy.

The following features help in providing error-free and efficient payroll calculation to accurately process payroll and remain in compliance.

  • Localization– Predefined Legislative Data Groups that are delivered helps calculate payroll according to global and local taxation rules.
  • Payroll Integrations– Provide standard interface to third party payroll providers like US ADP Tax Filing.
  • Customisable – It allows business users to determine what should be included in their payroll processes like QuickPays, Balance Adjustments etc.
  • Fast Formulas– Complex business rules and other criteria can be set by creating fast formulas.
  • Checklists– Create checklists for actions that require the completion of standard tasks and Monitor the progress of each payroll process.
  • Predefined Templates – Seeded payroll reports and custom reports can be used to meet the complex reporting requirements and schedule the outputs for any frequency.
  • Secure User Interface– Navigation through the interface is simple and clear. The intuitive interface provides each user access based on their roles.