Frequently Asked Questions

Can you make Benford's Analysis in Sesam?

In version 7.2 of SESAM a macro language has been added to SESAM's functionality (as an option). Via the macro language most types of analysis tasks can be performed. One example of this is the ability to make Benford's analysis. A macro for this purpose is included when the macro option is selected.

Can Sesam import automatically?

Sesam can import the DBF format automatically (in Analysis). DBF is an industry standard format and many applications allows export to the DBF format. This means that the capability to import DBF's  covers other formats as well. Examples of applications which can export to DBF is Microsoft Access and Microsoft Excel.

In version 7.2 of SESAM a scripting interface can be provided (as an option). This interface makes it possible to automize import from specific standard accounting systems. In collaboration with the Swedish tax authority Intrasoft International Scandinavia has created import scripts for a number of Swedish standard packages. 

Using the scripting capability mentioned above SESAM's import capabilities can be extended to virtually any format.

Which formats can be imported into Sesam?

Sesam can import from (and export to) a wide range of database formats, e.g. dBase, Access, Excel, Lotus. dBase and Excel formats are covered directly in Sesam’s interface. Import from Access is covered via ODBC using the Dataguru module.

SESAM's import/export capability can be extended to virtually any format using SESAM's built-in macro language.

Can Sesam be used to analyze data from SAP?

SAP stores data in normal industry standard database format (such as Oracle, MS SQL Server). The difficulty analyzing SAP data is the complexity of a SAP database, which consists of thousands of different tables. However, users who have knowledge of which tables to use can order extracts from these tables, and such extracts can be imported into SESAM in a normal way.

In version 7.2 of SESAM a scripting interface can be provided (as an option). This interface makes it possible to automize import from specific standard accounting systems. In collaboration with the Swedish tax authority Intrasoft International Scandinavia has created import scripts for a number of Swedish standard packages.

How many transactions can Sesam handle?

Sesam uses a highly optimized Microsoft database, which gives the user tremendous benefits. In Sesam all analysis tasks are performed using a point-and-click interface, and the user never has to write functions or use commands. Grouping on character fields and stratifications on numerical fields are made “on-the-fly”. Drill-down is made using the point-and-click interface as well. All these extremely powerful, intuitive and easy-to-use functions are made possible because of Sesam’s highly optimized database format.

Sesam can read input data files irres­pective of size (measured in GB or in number of records). When imported Sesam stores the data in a database format in order to allow blazingly fast point-and-click analysis (mentioned above).

Sesam’s database engine allows huge tables, up to 2 GB in size. This limitation is mainly theo­retical and has little or no impact at all on practical work.

In extremely rare cases when accounting tables would exceed the 2 GB limit there are viable solutions as well. Experience has shown that in cases like that there are always ways to split the data tables into more than one table, e.g. split by department, group, accounting period or other logical dimensions. Experience has also shown that splitting the data in this way makes analysis easier and quicker.

Guidelines about how to work with large data sets will be provided as a part of the Sesam documentation.

What is the normal training time for a Sesam user?

SESAM is unique among computer audit tools in the sense that it is proven that it can be spread to all auditors - giving a complete audit community access to high-end analysis functionality. The short training time needed makes SESAM quick and easy to implement.

Experience from implementing SESAM for a number of user groups in Europe, USA and Africa tells that a normal training time for a user to use Sesam Analysis in the audit work is a few days. However, there are examples of users requiring some more time to get up to speed, as well as examples of users who have started to use SESAM completely without training. The need for training is depending on the user's interest for using IT tools and the experience of using such tools. 

Sesam Conversion is slightly more complicated to use than Analysis, and normally it is relevant to provide a training for 1-2 weeks for Conversion users.

The split into two applications (Analysis and Conversion) enables a customer to train all auditors in using Analysis and a few users for Conversion. The Conversion users would then serve the rest of the Sesam users witn conversion of data files.