10 3 Field Stats Field stats is used

10. 3 לפני גרסה Field Stats Field stats is used to get statistics on Numeric, Time and Date fields in database For example, find 1. Earliest and latest date in a Date field 2. Average of a Numeric field 3. Transactions on days when business is closed 2 © כל הזכויות שמורות IACS 16: 48 11/09/2021

10. 3 לפני גרסה Field Stats 3 Abs. Value Absolute value for a Numeric field Avg. Value Average for a Numeric field Earliest. Date Earliest date in a Date field Items. In. Day Number of records for each day of the week Items. In. Month Number of records for specified month Max. Value Maximum value for a Numeric field Min. Value Minimum value for a Numeric field Most. Common. Day Most common day of the week in a Date field Net. Value Net value for the Numeric field Num. Data. Errors Number of invalid dates Num. Valid. Values Number of records with valid values in a field Num. Zero. Items Number of records that have zero values Pop. Var Population variance © כל הזכויות שמורות IACS 44 להלן דוגמאות לחלק מ הסטטיסטים שהיו קיימים IDEA 10. 3 לפני נוספו שני IDEA 10. 3 ב סטטיסטים 16: 48 11/09/2021

סטטיסטיקה על שדות טקסט - 10. 3 חידוש בגרסה In IDEA 10. 3, added the ability to generate field stats on Character fields Character Field Stats allows users to find potential Number of Blanks (Num. Blanks): Number of • records that contain blank (empty) values in the specified Character field Incomplete records • Number of Categories (Num. Categories): • Number of unique categories for the specified Character field 4 Anomalies (e. g. , more categories than what is • listed in product catalogue) Deficiencies (e. g. , transactions where there is • no authorizer) © כל הזכויות שמורות IACS 16: 48 11/09/2021

סטטיסטיקה על שדות טקסט - 10. 3 חידוש בגרסה Clicking on the count, drills-down into the data and results can be saved as their own databases to be used as audit findings. Summarizing on character fields can be labor intensive - now using Field Stats it's simple in IDEA 10. 3. 5 © כל הזכויות שמורות IACS 16: 48 11/09/2021

@Functions - ו IDEAScript פקודות - 10. 3 חידוש בגרסה • Run. Python. Ex • Stratify. On. Band. Wit h. Percent • Num. Categories. Out put. DB • Num. Blanks • @Python • @Field. Statistics • Belonging to the Client object, this command lets IDEAScript call the Python script of your choice, after which it resumes processing in IDEAScript. • Similar to Run. Python, this command lets IDEAScript call the Python script of your choice with multiple parameters. It then resumes processing in IDEAScript. • Similar to Stratify. On. Band, this command lets IDEAScript specify the percentage of records to extract for each stratum. • This is a new way for the Field. Stats object to report the number of unique categories for a given Character field. • This command acts as a new way for the Database object to create an instant summarization database from the Character Field Stats of a database with field statistics. • This new command lets the Field. Stats object report the number of cells with blanks for a given Character field. • A new @Function, @Python lets auditors extend IDEA’s existing library of @Functions with their own creations written in Python. It is ideal for Virtual fields. • New Field. Statistics indices have been created: “ 110” for # of Blanks, “ 111” for # of Categories. 13 © כל הזכויות שמורות IACS 16: 48 11/09/2021

– שיפורים אחרים 10. 3 חידוש בגרסה • Citrix Xen. App: 7. 6 and 7. 12 now supported for IDEA. • UTF-8: IDEA 10. 3 automatically detects files with international characters encoded in UTF-8 format, and imports data correctly without the need to change the encoding of the source files before importing into IDEA. This simplifies the review of international data for users with operations around the world. • Report Reader: We now support imports of PDF formats listed as PDF/A (objects within PDF). Users also now have the option to preserve as a text file when importing a PDF file to IDEA to save time in subsequent imports. • Improved Indexing Performance: IDEA’s processing engine has been upgraded, reducing processing time in many cases, depending on file size, data structure, the nature of data and the hardware being used. • Send to Excel: Now save Results outputs to the Results Library group. It will also support any locally installed spreadsheet software associated with the. XLS extension, not just Microsoft Office. • Smart. Analyzer Enhancements: Many enhancements included in IDEA 10. 3 (see What’s New document). Also with IDEA 10. 3 and Smart. Analyzer App SDK 3. 2, apps can be generated that are FIPS compliant. 15 © כל הזכויות שמורות IACS 16: 49 11/09/2021