880 likes | 1.03k Views
INTRODUCTION TO AUXINFO. AUXINFO. http://www.auxinfo.uscg.gov/ Takes data from AUXDATA and presents it in a meaningful, understandable, graphic way through the use of “cubes”. ( say something about being COGNOS ). AUXINFO Opening Page. Overview of AUXINFO.
E N D
INTRODUCTION TO AUXINFO bplatt@juno.com
AUXINFO • http://www.auxinfo.uscg.gov/ • Takes data from AUXDATA and presents it in a meaningful, understandable, graphic way through the use of “cubes”. • (say something about being COGNOS) bplatt@juno.com
AUXINFO Opening Page bplatt@juno.com
Overview of AUXINFO • AUXDATA cubes contain data entered after 15 March 2002, when AUXMIS was replaced by AUXDATA. • AUXMIS cubes contain data entered prior to 11 March 2002. bplatt@juno.com
AUXDATA Cube Selection bplatt@juno.com
AUXDATA Cubes • Awards • Demographics -age, gender, status (IQ, BQ, etc) • Member Activities • Unit Activities • Competencies -qualifications • Facilities -boats, planes, radios • Tasks - currency maintenance, courses and workshops • Unit - unit locations bplatt@juno.com
AUXMIS Cube Selection Cubes are organized in the way data was entered into AUXMIS bplatt@juno.com
AUXMIS Cubes • Aids to Navigation • Demographics -age, gender, status (IQ, BQ, etc) • Member Qualifications • Operation Hours • Public Education Classes • Vessel Examinations • Awards • Member Courses • Member Workshops • Public Affairs • Search and Rescue bplatt@juno.com
Using AUXDATA Cubes Note the date. Only AUXDATA entries made prior to that date will appear in the Cubes bplatt@juno.com
Using AUXINFO (cont’d) Number of columns displayed Zero Suppress Number of rows displayed Swap Axis bplatt@juno.com
Using AUXINFO (cont’d) Number of columns displayed Export CSV format Zero Suppress Number of rows displayed Swap Axis Prepare Bookmark Export PDF format bplatt@juno.com
Using Available Buttons Each button on the top bar of the Member Activity cube provides a different aspect of the information displayed Take the “All Positions” button - bplatt@juno.com
Using “All Positions” Button Clicking on the button brings a drop down menu of selections available. Data in the cube can be displayed for each listed choice individually or all together. bplatt@juno.com
Using “All Positions” Button Mouse over “Action” then “Nest” and clicking on “Columns” will result in data indicated for each in separate columns bplatt@juno.com
Using “All Years” Button The “All Years” button provides the opportunity to display the data for a specific Calendar or Fiscal Year. It further allows, by “drilling down, to display the data in the specific quarter, month, week or day that it was performed. bplatt@juno.com
Using “All Years” Button Mouse over “Action” then “Nest” then click on “Columns” will result in the data displayed by Quarters bplatt@juno.com
Using “All Years” Button Click on the “CY 2002” button brings this drop down menu. Click on “Down a Level” will display the data by Months. Repeat the process displays the data by weeks, and again by individual days. bplatt@juno.com
Using “All Facilities” Button With the All Facilities button, one can determine what portion of the activity was performed by Aircraft, Boat,Radio or Unit resources, or any combination of the three. bplatt@juno.com
Using “All Facilities” Button (cont’d) Clicking on Aircraft or Radio will provide options as to which type of resource performed the activity and clicking on the type will lead to the individual facility. bplatt@juno.com
Using “All Facilities” Button (cont’d) Clicking on Boat breaks boats into their category Clicking on a category will lead to boats that fall into that category. bplatt@juno.com
Using “All Missions” Button At the bottom of the Member Activities Cube opening screen, there is the All Missions button Clicking on the button brings up this menu. Initially the screen displays activity for each Mission. Clicking “Down a Level” the screen changes to activity for each Sub Mission bplatt@juno.com
To Hide/Show Rows/Columns • To prevent rows or columns from being visible, click on the button that serves as the row or column label. • From the drop down menu, click on “Action” • From the next menu, select - - - bplatt@juno.com
To Hide/Show Rows/Columns • - - from this menu, selecting “Hide Total” (or “Hide Sub Total” when available) will condense • the report by eliminating unnecessary info. • Clicking on “Hide/Show Rows” will result in the following pop up menu. bplatt@juno.com
To Hide/Show Rows/Columns • The option is available to Clear or Select the visible categories. bplatt@juno.com
Member Activity Cube Screen Display of Mission Hours for each Mission bplatt@juno.com
Member Activity Screen (cont’d) After clicking “All Missions” and “Down a Level” the screen now displays hours for each Sub Mission bplatt@juno.com
Member Activity Screen (cont’d) Instead of clicking on the button, click on the “+” and a new column is formed for the Sub Missions bplatt@juno.com
Measurers Clicking on the “Mission Hours” button will bring up the list of Measures, that is, what the number represent; Hours, ATONS Verified, VSC Count, etc. bplatt@juno.com
Measures (cont’d) Click on “All Missions” then mouse over “Action” and “Nest” then click on “MEASURES” then ----- bplatt@juno.com
Measures (cont’d) ---then a breakout of Measures for a Mission / Sub Mission is shown These are the applicable Measures for the ATON Mission bplatt@juno.com
Member Activities Cube (cont’d) • The Member Activities cube can be used to track hours for all facilities. • Boat, Radio, Aircraft hours can be shown by missions. bplatt@juno.com
Member Activities Cube (cont’d) • To see facility mission activities, drill down to the division or flotilla level desired. • Click on Unit button, mouse over “Action” and click on “Hide/Show Columns” and click on “Clear All” to hide members bplatt@juno.com
Member Activities Cube (cont’d) • Click on the down arrow and on drop down menu, click on “All Facilities” to list all Facilities in place of the Unit • Click on “Swap Axis” bplatt@juno.com
Member Activities Cube (cont’d) • To show only Boat Facilities, click on “Boat.” • Click on “All Facilities” button to see - - - bplatt@juno.com
Member Activities Cube (cont’d) • - - to see facilities listed by type. Click on the “Boat” button. On the drop down menu, click on “Down a Level” to see - - bplatt@juno.com
Member Activities Cube (cont’d) • - - to see all facilities in the selected unit. bplatt@juno.com
“Drilling” To a District or Lower • Technique by which you select the appropriate level you are looking for by moving down through (“drilling”) preceding levels. • Hold mouse over USCG-LANTAREA and PACAREA appear. Hold mouse over PACAREA-Districts 11, 13, 14, and 17 appear…..so on until you reach a unit. bplatt@juno.com
Drilling from the USCG level down to an Auxiliary Division level bplatt@juno.com
Uses of AUXINFO • Finding the average age of members in a District, Division, Flotilla • Number of hours or missions an individual or unit has in Safety Patrols, ATON, etc. • Which awards a member has earned • Locations of facilities • Who in your unit is Coxswain, Crew or AUXOP qualified,or a qualified Auxiliary Pilot. bplatt@juno.com
Demographics Cube Data bplatt@juno.com
Demographics Cube Data By clicking on “All Statuses” button and mouse over “Active” or “Not Active” a further breakdown is available by clicking an option in one of the pop up menus. bplatt@juno.com
Awards Cube Data bplatt@juno.com
Using Awards Cube • The cube is used to find which members received a specific or a group of awards and when. • The cube is used to find which awards a member or a group of members received and when. bplatt@juno.com
Using Awards Cube (cont’d) The cube opens showing all awards counted by year bplatt@juno.com
Using Awards Cube (cont’d) Drill down to the unit or member(s) and click the “Zero Suppression” icon to for this display. bplatt@juno.com
Using Awards Cube (cont’d) Click in “All Awards” button and mouse over “Action” & “Nest” and click on “Rows” will display - - - bplatt@juno.com
Using Awards Cube (cont’d) - - a screen showing the specific awards received bplatt@juno.com
Competencies Cube Data The Competencies are divided into these four categories. bplatt@juno.com
Competencies Cube (cont’d) The Air Competencies bplatt@juno.com
Competencies Cube (cont’d) The Boat Competencies bplatt@juno.com