1 / 28

ACL Functions

ACL Functions. Corporate Audit Services Technology Solutions Team Charlene Vallandingham and Jack Hauschild September 29, 2008. Agenda. Introductions Objective of Training – ACL Functions Classify Cross-Tabulate Stratify Combinations of Functions Wrap Up & Questions.

toki
Download Presentation

ACL Functions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ACL Functions Corporate Audit Services Technology Solutions Team Charlene Vallandingham and Jack Hauschild September 29, 2008

  2. Agenda • Introductions • Objective of Training – ACL Functions • Classify • Cross-Tabulate • Stratify • Combinations of Functions • Wrap Up & Questions

  3. Perform ACL Functions Open New or Existing Project. Open Table for Testing.

  4. Running the Classify Command • Creates a profile of your table based on unique character field values • The Classify command allows you to: • Specify the character field upon which you want to base your analysis • Specify the fields to subtotal • Output to screen, graph, print or file Classify Command

  5. Classify Command - Variables Select “Analyze > Classify” – Click on “Classify On”

  6. Classify Command - Variables Use Drop Down List & Select Variables

  7. Classify Command - Variables Select Fields to Subtotal – Make Output Choice

  8. Classify Command - Results to Screen Review distributions by count or amount Drill down into details

  9. Classify Command - Results to Screen Drill down to details where Dept = “None”

  10. Classify Command - Help Screen Use Help Screens!!

  11. Running the Cross-Tabulate Command • Displays the distribution of two or more character fields in a matrix format • The Cross-Tabulate command allows you to: • Specify rows upon which the analysis of the columns is based. The row is usually a key field such as a unique account description • Specify a column that is cross-tabulated with the row you specified • Specify subtotal fields for each intersection of each row and column • Output to screen, graph, print or file NOTE: Rows and columns must be character fields while subtotals can only be numeric.

  12. Cross-Tabulate Command - Variables Select “Analyze > Cross-tabulate” Select Rows, Columns & Subtotals – Make Output Choice

  13. Cross-Tabulate Command – Results to Screen Examine results for inconsistencies Drill down into details

  14. Cross-Tabulate Command – Help Screen Use Help Screens!!

  15. Running the Stratify Command • Creates a profile of your table based on numeric field ranges • The Stratify command allows you to: • Specify the numeric field or expression that you want to stratify • Select the minimum and maximum values of the range upon which the command will be executed • Specify how many intervals into which you want to divide the data • Specify which fields to subtotal • Output to screen, graph, print or file • NOTE: Statistics command can generate the minimum and maximum values to populate fields within Stratify command.

  16. Stratify Command - Variables Open table for testing – Select “Analyze > Stratify”

  17. Stratify Command - Variables Stratify on Debit Amount Conditional “If” on Account Create User-Defined Intervals

  18. Stratify Command - Variables Select “More” Tab - Break out Results by Deptid

  19. Stratify Command – Results to Screen Click on range to view only the detailed data of that range Log File Shown on Left

  20. Stratify Command – Results to Screen Specific Range Displayed

  21. Stratify Command – Help Screen Use Help Screens!!

  22. Combine Functions Example – Needed Department ID Column dept_desc contains 5 character deptid at end of variable-length string

  23. Combine Functions SUBSTRING, LENGTH, and TRIM to extract a Department Number from a Description Literal. Use “Edit > Table Layout” to create combined function by adding a new expression.

  24. Combine Functions Example Column DeptID created using combined function from dept_desc above

  25. Combine Functions Example Column DeptID created using SUBSTR((dept_desc),length(trim(dept_desc)) -4, 5)

  26. Length function – Help Screen Combination of Length & Trim Functions – Use Help Screens!!

  27. Substring function – Help Screen Use Help Screens!!

  28. Wrap Up & Questions • With ACL, there are many ways to perform a task • Recommend ACL 303 – Functions & Scripts class • Questions??

More Related