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
QUERY CHECKLIST
EXIT
HELP
GRAPH
SQL
TABLES
HEADING
RUN
SAVE
OPEN
NEW
9
(No Transcript)
10
(No Transcript)
11
Users Guide
12
Click Close
13
STEP 1 New Query
14
STEP 2 Click Subsystem
15
Click Subsystem
16
4 Subsystems available
Click Maintenance
Click Ok
17
STEP 3 Click Items to Use
18
Possible items available
Highlight Act Taken click Show Detail
19
Click these items from possible items below
Click OK
20
Click Criteria (optional entry)
21
Click WC
Click criteria for this line of the query
22
Next you must Click an Operator for this item
Click Like
23
Accept saves this line of criteria in your query
Condition is what your Clicked criteria must meet
601
Enter 6 I.e. your Teminal ID and press Accept
Make Argument is used to enter different
Arguments such as different WCs. You will be
asked when you Click to Run Query. Do Not Click
Accept with this option.
You may specify upper or mixed case
24
Notice that Ad hoc converts and moves your
criteria to the query window
25
Your criteria is JS NOT LIKE JC
Accept saves this line of criteria in your query
26
Your query should look like this
27
To modify, delete, or change your
statement, highlight the line
Click OK
Notice the buttons are now highlighted.
28
Click sort
You have the option to group and/or sort
29
Click sort items of WUC and MCN
30
Sort ascending or descending order is shown by
extension
To change, highlight item and click Toggle button
31
STEP 4 Click GO to execute/Run Query.
32
Query results greater than 0 will provide data
Click OK
33
Click Stop only if sufficient rows have been
retrieved for report
34
If additional data is available view by scrolling
with the arrow
Columns can be narrowed by left clicking and
closing gap.
35
Change Format and Apply Format is used when
you have change the layout on the screen
Preview allows you to view in print format
Click pages to print
Search for a specific page
Saves the data
Print
36
Print options allows user to modify print output
Click Cancel
Compressed pages must be Clicked to get
continuous report
37
Click Close
38
Click Close
39
Click here to save your query
40
Enter file name
Click directory to save query in
Click save
41
To open a saved Ad hoc query click File
42
If another query is opened and you dont wish to
save existing query, click Yes
43
Click Open Button
Click query to open
44
View open file name in title bar
45
To delete a saved Adhoc, click file
Click Delete
46
Every new release of Optimized IMA Installed
will delete this directory
Double click file to Delete
47
Click Yes
48
Click Exit
49
Click Yes
50
Unless you need to save query, click No
51
Click NALCOMIS ICON
52
ADHOC NORMAL
Create and save an EXREP report using Normal Ad
hoc with the following criteria. If you have any
questions during the process, ask one of your
Instructors.
53
ADHOC NORMAL

• Table Supply
• Possible Items Org, DDSN, MCN, Cog, NIIN
  
  Ordered, BUNO/SERNO,
  WUC, Prj, Iss Priority
• Criteria LSC of Exrep
• Sort DDSN
• Run your query. Have Instructor check it.
• Save your query to IMA directory, File name
  will be Normal.

54
ADHOC PROGRAMS
ADHOC EXPERT
55
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.

56
Click REPORTS
57
CLICK ON Adhoc THENExpert
58
New Query
59
Click tables
60
Click the dm04_maf table
Click OK
61
Click Columns
62
Click the columns to print from the dm04_maf
table
Click OK
63
Click Criteria
64
Click on Show Selected columns only to narrow
down your selection to the columns selected
65
Transaction code starts with 3
Possible Criteria Items dm04_maf.maint_trans_cd
Operator Starts With Condition 3
Click Accept
66
Click OK
67
Click Sort
68
Click column sort of dm04_maf.mcn
Click OK
Click on Show Selected columns only to narrow
down your selection to the columns selected
69
Click Group
70
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
71
Click on Run or Go
72
Click OK
73
Click Analyze
74
Click the dm04_maf.tot_man_hrs, Then
dm04_maf.items_prc, a prompt screen will come
up to Click the type of calculation.
75
Click Divide
Click Done
76
Click Store
77
Choose Graph
Click on the check box
78
Click Settings
79
Label your graph
Click OK
80
Click Type
81
Select a Graph Type then Click OK
82
Click Close
83
Click View
84
Data Reflects Average Manhours per Items Processed
85
ADHOC EXPERT
Confused? Thats nothing, lets try another
query. This time we can Link tables together to
get the desired information.
86
ADHOC EXPERT
Since we already know how to get around well
start at the table selection option.
87
Choose the above database tables to do query
Click OK
88
Click on Accept
When multiple tables are Clicked you need to
link them together by a common data element.
89
Tables are linked by columns
90
Select dm09_removed and highlight MCN
Click on Accept
91
The dm07 and dm09 tables are linked to the dm04
table via the MCN key
Click OK
92
Click Columns
93
Click the below columns from the appropriate
tables
Click OK
94
Click Criteria
95
Click on Show Selected columns only to narrow
down your selection to the columns selected
96
Click maf.act_take_cd Like A
Possible Criteria Items dm04_maf.act_take_cd Ope
rator Like Condition A
Click Accept
97
Also mal_dscrptn_cd Like 799
Click Accept
98
Click OK
99
Click Sort
100
Sort by MCN in ascending order
Click OK
Click on Show Selected columns only to narrow
down your selection to the columns selected
101
Click Run Query
102
Click OK
103
Allows user to stop the retrieval process and
display at that point
104
Click Close
105
Click Close
106
Save Query
107
Select A Drive
108
Click on Save
Save as myadhoc
109
ADHOC EXPERT
SUPPLY ADHOC Almost Like the Outstanding
Material Requirements Report by Org Code
110
Click on Tables
111
Select dr09_requisition
Click on OK
112
Click on Columns
113
Select the FF
Click on OK
114
Click on Criteria
115
Select dr09_requisition.org_cd Like AJ6
Click on Accept
116
(No Transcript)
117
Select dr09_requisition.lsc Not Equal To COMPL
Click on Accept
118
Select dr09_requisition.lsc Not Equal To CANCL
Click on Accept
119
Select dr09_requisition.lsc Not Equal To RCANC
Click on Accept
120
Click on OK
121
Click on Run Query
122
Click on OK
123
Click on Close
124
Click on Close
125
Click on Criteria
126
Select dr09_requisition.ord_qty Greater Than 1
Click on Accept
127
Click on OK
128
Click on Run Query
129
Click on OK
130
Click on Close
131
Click on Group
Click on OK
132
Click on OK
133
Click on Close
134
Click on Close
135
Click on Exit
136
Click on No
137
ANY QUESTIONS ???
138
REVIEW AND SUMMARY

• DESCRIBED ADHOC NORMAL

• DESCRIBED ADHOC EXPERT

139
Click Analyze
140
What is the 1st button you would see when you
initiate an Normal ADHOC?
A. TABLE
B. ITEMS TO USE
C. SUBSYSTEM
C. SUBSYSTEM
50/50
D. CRITERIA
01
141
What is the 1st button you would see when you
initiate an Normal ADHOC?
B. ITEMS TO USE
C. SUBSYSTEM
C. SUBSYSTEM
01
142
What is the 1st button you would see when you
initiate an Expert ADHOC?
A. TABLES
A. TABLES
B. COLUMNS
C. SORT
50/50
D. CRITERIA
01
143
What is the 1st button you would see when you
initiate an Expert ADHOC?
A. TABLES
A. TABLES
C. SORT
01
144
Saved ADHOCs will be over written if SPAWAR
updates your release.
True or False
True
01
145
A broad understandingof the scheme of database
tables is necessary for user to successfully
attain the intended results of an Expert Adhoc.
True or False
True
01
146
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
C. SCHEDULE
50/50
D. DELETE
01
147
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
C. SCHEDULE
01