Download
adhoc programs n.
Skip this Video
Loading SlideShow in 5 Seconds..
ADHOC PROGRAMS PowerPoint Presentation
Download Presentation
ADHOC PROGRAMS

ADHOC PROGRAMS

237 Views Download Presentation
Download Presentation

ADHOC PROGRAMS

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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