

- #CASEWARE IDEA WHERE IS CROSS TABULATION SOFTWARE#
- #CASEWARE IDEA WHERE IS CROSS TABULATION PROFESSIONAL#
The extraction criteria areentered using the Equation Editor. Thanks to IDEA's ease-of-use, accountants, auditors,systems and financial professionals can easily create their own analysis.Įxtract specific recordsExtractions, or exception testing, are the most frequently used functions to identify items which satisfy a specificcharacteristic, such as payments more than $10,000 or transactions before a given date. Perform powerful tasks designed especially for audits and analysis. Age a database froma specified date for up to six user-defined intervals.For example, the outstanding accounts could be agedat the year-end in order to determine provisionsrequired against bad debts.Ĭreate multi-dimensional, multi-variableanalysis of large databasesYou can drag and drop required data fields onto apivot table to create powerful analysis.
#CASEWARE IDEA WHERE IS CROSS TABULATION PROFESSIONAL#
Summarize your dataand total numeric values for each unique key you cansummarize your data, calculate the sum or average,and then turn your results in to professional lookingcharts in seconds (see Figure 1). Profile your dataStratify on a Numeric, Character, or Date field tocategorize records into bands. Click on any statistic to view theassociated records. Statistics can also be used inequations to compare individual records to the statistics for the whole database. Have a quick look at millions of transactions and view your data in a comprehensive and summarized representation.ĭisplay statisticsStatistics can be generated for all Numeric, Date and Time fields within a database. Action fields can also be used to run IDEAScript macros (see below) or other applications. For example, create an action field on Customer Number in a customer database to link torelated invoices. This field type allows you to set up relationshipsacross multiple databases. Link related fieldsClick on a value in a field and assign an action based on this value. Use your Custom Functions in the Equation Editor just like and share them with your team. Create your own custom equation functions using Visual Basic in a rich interface. Perform complex calculations and conversionsIDEA provides almost 100 which can be used to convert formats, manipulate text or to compute numeric,financial and statistical data.

View your results in graphical formatGraph values in a database or test results in line, bar, stacking bar, curve, scatter, pie or area charts.Īdd, delete or change field propertiesChange the type, the name, the description or add tags for IDEA Smart Analyzer.Ĭreate virtual calculated fieldsCreate Virtual fields based on calculations or create Editable fields that allow you to enter your own information, such asinserting your audit findings directly in the database. Group matching records togetherUse the Group Records task to organize matching records in indexed fields (keys) into expandable/collapsible groups. You can also simply display your data in any orderwithout creating a new database by clicking on a column or using the Indices task. Sort your records in a specified orderCreate a new database physically sorted in the specified order. Organize your DataExplore your data by adding additional fields and grouping and ordering your data before starting deeper analysis. To back up your project, simply back upyour Working Folder. All results,macros, databases and definitions are automatically stored in this central folder. IDEA allows you to easily manage your files and results by grouping all of them in a single Working Folder. This functionality, in conjunction with the automatic audit trail creation, allows you to easilydocument and review your work. IDEA protects the source data by allowing read-only access to your clients' data to avoid any unwanted changes andmaintain data integrity. Define the reports by using simple "point and click" tools to identify the data you need.Įxport your data and results out of IDEA in multiple formats like Excel, Access, HTML, XML, Text, RTF (Microsoft Word), PDFand more.

Report ReaderCreate reports using system tools, save the reports to files (PRN or PDF), then use Report Reader to describe and capturethe data in IDEA. ODBCConnect, using ODBC, to all major relational databases such as Oracle, DB2, SQL, Sybase, SAP or AS-400. Text (Fixed and variable length) and Delimited (CSV, DEL) files AS-400, Microsoft Access or Excel files XML, dBASE, or SAP AIS databases and more
#CASEWARE IDEA WHERE IS CROSS TABULATION SOFTWARE#
Import varioustypes of data coming from legacy mainframes, mid-range accounting software and big ERP systems. Import AssistantImport easily almost any file type from almost any source, using IDEAs Import Assistant to guide you. IDEA allows you to import your data from a multitude of formats, including files originating from large mainframe computersand accounting software.
