ADHOC PROGRAMS

1. ADHOC PROGRAMS • UPON COMPLETION OF THIS TOPIC, YOU • WILL BE ABLE TO: • DESCRIBE ADHOC PROCESSING • PERFORM ADHOC NORMAL REPORT • PERFORM ADHOC EXPERT REPORT

2. ADHOC PROGRAMS ADHOC NORMAL

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

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

5. Click REPORTS

6. Click Ad hoc

7. Click Normal

8. ALL OTHERS ARE MANDATORY ENTRIES OPTIONAL ENTRIES QUERY CHECKLIST EXIT HELP GRAPH SQL TABLES HEADING RUN SAVE OPEN NEW

9. ADHOC PROGRAMS ADHOC EXPERT

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

11. Click REPORTS

12. CLICK ON “Adhoc” THEN“Expert”

13. New Query

14. Click tables

15. Click the dm04_maf table Click OK

16. Click Columns

17. Click the columns to print from the dm04_maf table Click OK

18. Click Criteria

19. Click on “Show Selected columns only” to narrow down your selection to the columns selected

20. Transaction code starts with 3 Possible Criteria Items = dm04_maf.maint_trans_cd Operator = Starts With Condition = 3 Click Accept

21. Click OK

22. Click Sort

23. Click column sort of dm04_maf.mcn Click OK Click on “Show Selected columns only” to narrow down your selection to the columns selected

24. Click Group

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

26. Click on Run or Go

27. Click OK

28. Click Analyze

29. Click the dm04_maf.tot_man_hrs, Then dm04_maf.items_prc, a prompt screen will come up to Click the type of calculation.

30. Click Divide Click Done

31. Click Store

32. Choose Graph Click on the check box

33. Click Settings

34. Label your graph Click OK

35. Click Type

36. Select a Graph Type then Click OK

37. Click Close

38. Click View

39. Data Reflects Average Manhours per Items Processed

40. ADHOC EXPERT Confused? That’s nothing, lets try another query. This time we can Link tables together to get the desired information.

41. ADHOC EXPERT Since we already know how to get around we’ll start at the table selection option.

42. Choose the above database tables to do query Click OK

43. Click on Accept When multiple tables are Clicked you need to link them together by a common data element.

44. Tables are linked by columns

45. Select dm09_removed and highlight “MCN” Click on Accept

46. The dm07 and dm09 tables are linked to the dm04 table via the MCN key Click OK

47. Click Columns

48. Click the below columns from the appropriate tables Click OK

49. Click Criteria

50. Click on “Show Selected columns only” to narrow down your selection to the columns selected