Skip to main content

Postings from the India IDEA data Analysis software users group

Description

This forum will contian tips from the India IDEA Data Analysis Software Users Group. If you are interested in joining them you can find them on google groups at http://groups.google.com/group/idea-data-analysis-software-users---india

Bribery and Anti-Corruption Analytics - Suspicious/Prohibited Word Transaction Search in IDEA

Hi,
 
One can use 'Search' within IDEA to look for suspicious Travel & Entertainment (T&E) claims or narrations in General Ledgers from a Bribery and Anti-Corruption Analytic view point.
 
In the 'Search' box you can enter the search string like -
 

Append & Append in IDEA

Hi,

A closer look at Data under the IDEA tool-bar will reveal a function 'Append' - Fields.

'Append' under Fields in Data allows you to append or add fields to the active database.

You may need to add fields to perform calculations or reassess values in the accounting system or derive values/strings or add comments - limitless possibilities.

On the other hand 'Append' under 'Relate' in Analysis allows you to merge databases into a single file for further analysis.