acl functions
Download
Skip this Video
Download Presentation
ACL Functions

Loading in 2 Seconds...

play fullscreen
1 / 28

ACL Functions - PowerPoint PPT Presentation


  • 194 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ACL Functions' - toki


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
acl functions

ACL Functions

Corporate Audit Services

Technology Solutions Team

Charlene Vallandingham and Jack Hauschild

September 29, 2008

agenda
Agenda
  • Introductions
  • Objective of Training – ACL Functions
    • Classify
    • Cross-Tabulate
    • Stratify
    • Combinations of Functions
  • Wrap Up & Questions
perform acl functions
Perform ACL Functions

Open New or Existing Project.

Open Table for Testing.

running the classify command
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

classify command variables
Classify Command - Variables

Select “Analyze > Classify” – Click on “Classify On”

classify command variables6
Classify Command - Variables

Use Drop Down List & Select Variables

classify command variables7
Classify Command - Variables

Select Fields to Subtotal – Make Output Choice

classify command results to screen
Classify Command - Results to Screen

Review distributions by count or amount

Drill down into details

classify command results to screen9
Classify Command - Results to Screen

Drill down to details where Dept = “None”

running the cross tabulate command
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.

cross tabulate command variables
Cross-Tabulate Command - Variables

Select “Analyze > Cross-tabulate”

Select Rows, Columns & Subtotals – Make Output Choice

cross tabulate command results to screen
Cross-Tabulate Command – Results to Screen

Examine results for inconsistencies

Drill down into details

running the stratify command
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.
stratify command variables
Stratify Command - Variables

Open table for testing – Select “Analyze > Stratify”

stratify command variables17
Stratify Command - Variables

Stratify on Debit Amount

Conditional “If” on Account

Create User-Defined Intervals

stratify command variables18
Stratify Command - Variables

Select “More” Tab - Break out Results by Deptid

stratify command results to screen
Stratify Command – Results to Screen

Click on range to view only the detailed data of that range

Log File Shown on Left

combine functions example needed department id
Combine Functions Example – Needed Department ID

Column dept_desc contains 5 character deptid at end of variable-length string

slide23
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.

combine functions example
Combine Functions Example

Column DeptID created using combined function from dept_desc above

combine functions example25
Combine Functions Example

Column DeptID created using SUBSTR((dept_desc),length(trim(dept_desc)) -4, 5)

length function help screen
Length function – Help Screen

Combination of Length & Trim Functions – Use Help Screens!!

wrap up questions
Wrap Up & Questions
  • With ACL, there are many ways to perform a task
  • Recommend ACL 303 – Functions & Scripts class
  • Questions??
ad