ADHOC PROGRAMS

ADHOC PROGRAMS UPON COMPLETION OF THIS TOPIC, YOU WILL BE ABLE TO:  DESCRIBE ADHOC PROCESSING  PERFORM ADHOC NORMAL REPORT  PERFORM ADHOC EXPERT REPORT ADHOC PROGRAMS ADHOC NORMAL ADHOC NORMAL Purpose: In addition to the standard set of reports, NALCOMIS IMA provides access to the Ad hoc query utility, which allows you to produce ad hoc, or customized, reports from the application's database. ADHOC NORMAL • Adhoc Normal provides a user who is not familiar with the Database Structure the ability to create, view and print a user define report. • Provides real time information to the user. • Allows flexibility to print or save query which can be run again at a later time. • Can Click specific data elements within a subsystem. • Will replace several canned reports and inquiries. Click REPORTS Click Ad hoc Click Normal EXIT HELP GRAPH ALL OTHERS SQL TABLES HEADING RUN SAVE OPEN NEW OPTIONAL ENTRIES ARE MANDATORY ENTRIES QUERY CHECKLIST ADHOC PROGRAMS ADHOC EXPERT ADHOC EXPERT     Expert mode enables you to click from tables and columns in the database containing data elements. A broad understanding of the schema and SQL will help a user to successfully attain the intended results. Need a basic understanding of “Boolean Terms” Allows the user to determine and create table links. Provides real time information to the user. Click REPORTS CLICK ON “Adhoc” THEN “Expert” New Query Click tables Click the dm04_maf table Click OK Click Columns Click the columns to print from the dm04_maf table Click OK Click Criteria Click on “Show Selected columns only” to narrow down your selection to the columns selected Transaction code starts with 3 Possible Criteria Items = dm04_maf.maint_trans_cd Operator = Starts With Condition = 3 Click Accept Click OK Click Sort Click column sort of dm04_maf.mcn Click OK Click on “Show Selected columns only” to narrow down your selection to the columns selected Click Group Click group on dm04_maf.act_take_cd Click OK Click on “Show Selected columns only” to narrow down your selection to the columns selected Click on Run or Go Click OK Click Analyze Click the dm04_maf.tot_man_hrs, Then dm04_maf.items_prc, a prompt screen will come up to Click the type of calculation. Click Divide Click Done Click Store Choose Graph Click on the check box Click Settings Label your graph Click OK Click Type Select a Graph Type then Click OK Click Close Click View Data Reflects Average Manhours per Items Processed ADHOC EXPERT Confused? That’s nothing, lets try another query. This time we can Link tables together to get the desired information. ADHOC EXPERT Since we already know how to get around we’ll start at the table selection option. Choose the above database tables to do query Click OK Click on Accept When multiple tables are Clicked you need to link them together by a common data element. Tables are linked by columns Select dm09_removed and highlight “MCN” Click on Accept The dm07 and dm09 tables are linked to the dm04 table via the MCN key Click OK Click Columns Click the below columns from the appropriate tables Click OK Click Criteria Click on “Show Selected columns only” to narrow down your selection to the columns selected Click maf.act_take_cd Like “A” Possible Criteria Items = dm04_maf.act_take_cd Operator = Like Condition = A Click Accept Also mal_dscrptn_cd Like “799” Click Accept Click OK Click Sort Sort by MCN in ascending order Click OK Click on “Show Selected columns only” to narrow down your selection to the columns selected Click Run Query 16 Click OK Allows user to stop the retrieval process and display at that point Click Close Click Close Save Query Select A: Drive Click on “Save” Save as “myadhoc” ANY QUESTIONS ??? REVIEW AND SUMMARY  DESCRIBED ADHOC  DESCRIBED ADHOC NORMAL EXPERT Click Analyze What is the 1st button you would see when you initiate an Normal ADHOC? A. TABLE B. ITEMS TO USE C. SUBSYSTEM D. CRITERIA 01 50/50 What is the 1st button you would see when you initiate an Normal ADHOC? B. ITEMS TO USE C. SUBSYSTEM C. SUBSYSTEM 01 What is the 1st button you would see when you initiate an Expert ADHOC? A. TABLES B. COLUMNS C. SORT D. CRITERIA 01 50/50 What is the 1st button you would see when you initiate an Expert ADHOC? A. TABLES C. SORT 01 True or False Saved ADHOC’s will be over written if SPAWAR updates your release. True 01 True or False A broad understanding of the scheme of database tables is necessary for user to successfully attain the intended results of an Expert Adhoc. True 01 This task group button on the Detailed Info tab (SYS/RPTS/Que/Job Requests) allows the user to schedule print jobs for an entire month? A. APPLY B. PROCESSING C. SCHEDULE D. DELETE 01 50/50 This task group button on the Detailed Info tab (SYS/RPTS/Que/Job Requests) allows the user to schedule print jobs for an entire month? A. APPLY C. SCHEDULE 01