A djutant G eneral B asic O fficers L eader C ourse Perform Datastore Functions April 2015 AHRS Datastore Training Checklist Users can no longer create and store queriesreports in the main Public Folder of the training database ID: 733099
Download Presentation The PPT/PDF document "Human Resources Systems Week" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Human Resources Systems Week
Adjutant General Basic Officers Leader Course
Perform
Datastore FunctionsApril 2015Slide2
AHRS Datastore Training Checklist
Users can no longer create and store queries/reports in the main Public Folder of the training database
When querying Soldier data, the user should begin with the column selection process by first choosing the (UIC / filter WK0101) from the SOLDIER CORE DATA table. Choosing other UIC tables’ columns may produce Erroneous/NULL (empty) results. Datastore
https://datastoretrng.ahrs.army.mil/default.htmUser ID: c01.s01 (Build queries using your eMILPO classroom and assign student numbers 01-50)NOTE: Use classroom 01 has your default classroomPassword: Trng@Class#1412 (the student password for eMILPO)
Slide3
ACTION:
Create an Ad Hoc Query CONDITIONS:
In a classroom environment, given a set of data elements; a computer with access to the internet; access to the Datastore training database, corresponding regulatory guidance and awareness of Operational Environment (OE) variables and actors.
STANDARDS: Create, View, and Modify Ad Hoc Queries Terminal Learning Objective
3Slide4
Create an Ad Hoc Query
4
1
23
4Slide5
View an Ad Hoc Query
5Slide6
Modify an Ad Hoc Query
6Slide7
Summary Human Resources Systems Week
DatastoreUsers can no longer create and store queries/reports in the main Public Folder
Ad Hoc Query allows the user to get information not available in the data cube or standard reports. The user can design simple to complex queries to produce the required data. • Users can modify queries to include additional elements later in the query design. Successful queries require an understanding of the basic query principles, familiarity within the data elements available, forethought in the query design, patience, and practice.