Differences between revisions 146 and 147
Revision 146 as of 2018-10-15 14:22:34
Size: 19638
Editor: cox
Comment:
Revision 147 as of 2018-10-31 13:52:24
Size: 19749
Editor: lchesnutt
Comment:
Deletions are marked like this. Additions are marked like this.
Line 51: Line 51:
||OU_Deans_Office|| ||Lori Tirpak (tirpak@oakand.edu)|| ||ARGOS_UTS||Larry Chesnutt (lchesnutt@oakland.edu)||

Argos Reporting

What is Argos Reporting?

  • Argos Reporting is the one-stop, complete reporting tool of choice for Oakland University Banner users.
  • Banner data is accessible from Argos Reporting (real-time). Additionally, functions, tables and views can be used in Argos objects.
  • Whether you need ad-hoc and on-going reporting, Argos provides the user community with current, real time data. Data can be presented in various types of charts/graphs, mini text boxes or cubes. Dashboards with multiple selection criteria allow unlimited filtering and flexibility. Additionally, Argos can present the data/output in letter, printed, CSV, delimited and pdf format.
  • Entire teams can access Argos Dashboards to view their teams's data. Argos provides consistant, stable reporting at the users' request. Changes to DataBlocks and Dashboards do require UTS promotion to production. For continuously changing reports another reporting tool may fit better.

  • Argos uses a GUI based Developer Tool that makes it easy to design and develop queries. A DataBlock Designer will create a DataBlock and Dashboard for Report Writers and Viewers to use.

  • A default Data Dictionary, provided by Evisions, has been loaded for use. As new ADO Connections are added, they must be added to the Data Dictionary to be used. The Argos Core Reporting Team will evaluate the Evisions Data Dictionary and modify as needed in the future.

Argos Reporting Group Owners

Below is a list of the Argos Reporting Groups and DataBlock Designers.

If a user or group has questions regarding Argos, please feel free to reach out to the related Group Owner or DataBlock Designer.

  • Group Owner: Approves user(s) access to the Group Folder and associated DataBlocks and Dashboards, verifies / compares Argos user access to Banner user access and approves Promotion Requests. The Group Owner is responsible to insure users of their Folders and DataBlocks do not have access to data in Argos that they do not have in Banner. If there is a designated Secondary, the same responsibility applies. The Group Owner will work with the Core (or main) DataBlock Designer to insure DataBlocks are placed in correct, secure Group Folders.

  • DataBlock Designer: Creates DataBlocks, and Dashboards with charts, cubes and various filtering criteria, and the Core DataBlock Designer approves Promotion Requests.

  • Report Writer: Creates reports based on DataBlocks

  • Report Viewer: Runs reports and views Dashboards

Argos Reporting - Group Owners and DataBlock Designers

FOLDER

SUB-FOLDER

OWNER

SECONDARY

ADO CONNECTION

DATABLOCK DESIGNER

OU_Acad_Affairs

Peggy Cooke (cooke@oakland.edu)

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_ACADAFF

Michael Kazmierski (mekazmie@oakland.edu)

OU_Acad_Affairs

Catalog

Peggy Cooke (cooke@oakland.edu)

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_ACADAFF

Michael Kazmierski (mekazmie@oakland.edu)

OU_Acad_Affairs

Finance

Peggy Cooke (cooke@oakland.edu)

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_ACADAFF

Michael Kazmierski (mekazmie@oakland.edu)

OU_Accounts_Receivable

Linda Switzer (switzer@oakland.edu)

ARGOS_AR

Robert Bonam (bonam@oakand.edu)

OU_Admissions

Dawn Marie Aubry (dmaubry@oakland.edu)

Steven Szalay (szalay@oakland.edu)

ARGOS_ADMISS

Steven Szalay (szalay@oakland.edu)

OU_Advancement

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Advancement_Services

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Campaign

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

College_Arts_Sciences

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Engagement_and_Events

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Giving_Reports

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Planned_Giving

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advancement

Stewardship

Lauren Hwa Young Jeske (lhjeske@oakland.edu)

ARGOS_ADVNCMNT

Christopher Michael Bowles (cmbowles@oakland.edu )

OU_Advising

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_BIS

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_CAS

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_Public

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_SBA

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_SECS

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_SEHS

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_SHS

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Advising

OU_Advising_SON

Tricia Westergaard (westerga@oakland.edu)

ARGOS_ADVISING

Steven Meyer (meyer234@oakland.edu)

OU_Budget

Brelanda Pirani (pirani@oakand.edu)

ARGOS_BUDGET

Ross Hallaron (hallaron@oakland.edu)

OU_Deans_Office

Lori Tirpak (tirpak@oakand.edu)

ARGOS_UTS

Larry Chesnutt (lchesnutt@oakland.edu)

OU_DegreeWorks

Tricia Westergaard (westerga@oakland.edu)

ARGOS_DEGREEWORKS

Karla Brown (brown234@oakland.edu)

OU_ELIS

John Coughlin (jcoughli@oakland.edu)

Eric Merrill (merrill@oakland.edu)

TBD

TBD

OU_Finance_Admin

Thomas LeMarbe (lemarbe@oakland.edu)

ARGOS_FINADMIN

Stephen Sklar (sklar@oakland.edu)

OU_Finance

Gerri Ann Reimann (reimann@oakland.edu)

James Hargett (hargett@oakland.edu)

ARGOS_FINANCE

Chris Bowles (cmbowles@oakland.edu)

OU_Finance

OU_Accounting

Gerri Ann Reimann (reimann@oakland.edu)

ARGOS_FINANCE

Chris Bowles (cmbowles@oakland.edu)

OU_Finance

OU_Accounts_Payable

Bryan Atkinson (atkinson@oakland.edu)

ARGOS_FINANCE

Chris Bowles (cmbowles@oakland.edu)

OU_Finance

OU_Asst_VP_Controller

Gerri Ann Reimann (reimann@oakland.edu)

James Hargett (hargett@oakland.edu)

ARGOS_FINANCE

Chris Bowles (cmbowles@oakland.edu)

OU_Finance

OU_Payroll

George Leaver (gleaver@oakland.edu)

ARGOS_FINANCE

Chris Bowles (cmbowles@oakland.edu)

OU_Financial_Aid

Cindy Hermsen (hermsen@oakland.edu)

Brian Long (bmlong@oakland.edu)

ARGOS_FINAID

Brian Long (bmlong@oakland.edu)

OU_Financial_Aid

Advising

Cindy Hermsen (hermsen@oakland.edu)

Brian Long (bmlong@oakland.edu)

ARGOS_FINAID

Brian Long (bmlong@oakland.edu)

OU_Financial_Aid

Leadership

Cindy Hermsen (hermsen@oakland.edu)

Brian Long (bmlong@oakland.edu)

ARGOS_FINAID

Brian Long (bmlong@oakland.edu)

OU_Financial_Aid

Operations

Cindy Hermsen (hermsen@oakland.edu)

Brian Long (bmlong@oakland.edu)

ARGOS_FINAID

Brian Long (bmlong@oakland.edu)

OU_Financial_Aid

Systems

Cindy Hermsen (hermsen@oakland.edu)

Brian Long (bmlong@oakland.edu)

ARGOS_FINAID

Brian Long (bmlong@oakland.edu)

OU_First_Year_Advising_Center

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_First_Year_Advising_Center

BRM Reporting

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_First_Year_Advising_Center

FYAC MGMT

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_First_Year_Advising_Center

Orientation

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_Grad_Study

Claire Rammel (rammel@oakland.edu)

NingNing Zheng (nzheng@oakland.edu)

ARGOS_GRADSTUDY

NingNing Zheng (nzheng@oakland.edu)

OU_Grad_Study

Grad_Admissions

Claire Rammel (rammel@oakland.edu)

NingNing Zheng (nzheng@oakland.edu)

ARGOS_GRADSTUDY

NingNing Zheng (nzheng@oakland.edu)

OU_Grad_Study

Grad_Retention

Claire Rammel (rammel@oakland.edu)

NingNing Zheng (nzheng@oakland.edu)

ARGOS_GRADSTUDY

NingNing Zheng (nzheng@oakland.edu)

OU_Honors_College

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_Honors_College

Honors College Info Sessions

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_Human_Resources

Ron Watson (rwatson@oakland.edu)

ARGOS_UHR

Stephen Sklar (sklar@oakland.edu)

OU_Human_Resources

OU_Academic_HR

Michelle Piskulich (piskulic@oakland.edu)

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_AHR

Michael Kazmierski (mekazmie@oakland.edu)

OU_Human_Resources

OU_University_HR

Chitra Krishnan (ckrishnan@oakland.edu)

ARGOS_UHR

Chitra Krishnan (ckrishnan@oakland.edu)

OU_Institutional_Research

Laura Schartman (schartma@oakland.edu)

Reuben Ternes (ternes@oakland.edu)

ARGOS_IR

Reuben Ternes (ternes@oakland.edu)

OU_International_Students_and Scholars

David Archbold (archbold@oakland.edu)

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_ISSO

Michael Kazmierski (mekazmie@oakland.edu)

OU_OSS

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_OSS

Faculty Feedback

Sara Webb (crampton@oakland.edu)

William Johnson (johnson@oakland.edu)

ARGOS_FYAC

William Johnson (johnson@oakland.edu)

OU_Registrar

Tricia Westergaard (westerga@oakland.edu)

Jon Davidson (davidson@oakland.edu)

ARGOS_REGISTRAR

Karla Brown (brown234@oakland.edu)

OU_Registrar

Audits

Tricia Westergaard (westerga@oakland.edu)

Jon Davidson (davidson@oakland.edu)

ARGOS_REGISTRAR

Karla Brown (brown234@oakland.edu)

OU_Research

Academic Unit's Faculty members email

Michael Kazmierski (mekazmie@oakland.edu)

ARGOS_RESEARCH

Michael Kazmierski (mekazmie@oakland.edu)

OU_SON

Jason Pennington (penningt@oakland.edu)

Joan Denby (denby@oakland.edu)

ARGOS_SON

Joan Denby (denby@oakland.edu)

OU_SON

OU_SON_Advising

Jason Pennington (penningt@oakland.edu)

Joan Denby (denby@oakland.edu)

ARGOS_SON

Joan Denby (denby@oakland.edu)

OU_School_of_ Business_Administration

SBA

TBD

TBD

ARGOS_SBA

Juan Carlos Mendez Santos (mendezsa@oakland.edu)

OU_Student_Affairs

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Barnes and Noble

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Career Services

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Center for Multicultural Initiatives

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Community Engagement

Leonardo Debiaggi (ledebiag@oakland.edu

Glenn McIntosh (mcintosh@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Cross Divisional Housing Reports

Leonardo Debiaggi (ledebiag@oakland.edu)

Glenn McIntosh (mcintosh@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Dean of Students System Integrations

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Dean of Students

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Disability Support Services

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Emergency Response

Leonardo Debiaggi (ledebiag@oakland.edu

Glenn McIntosh (mcintosh@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

General

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Graham Health Center

Glenn McIntosh (mcintosh@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Housing

James Zentmeyer (zentmeye@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_HOUSING

Zachary Budrow (zabudrow@oakland.edu)

OU_Student_Affairs

SAIT

Leonardo Debiaggi (ledebiag@oakland.edu

William Johnson (johnson@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Student Success Initiative

Leonardo Debiaggi (ledebiag@oakland.edu

Glenn McIntosh (mcintosh@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_Student_Affairs

Veterans Support Services

Omar L. Brown-El (brownel@oakland.edu)

Leonardo Debiaggi (ledebiag@oakland.edu)

ARGOS_STUDAFF

Leonardo Debiaggi (ledebiag@oakland.edu)

OU_UTS_University_Technology_Services

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_ALL

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_Audits

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_Banner

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_DBA_Only

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_Data_Warehouse

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

OU_UTS_University_Technology_Services

OU_UTS_Management_Only

Theresa Rowe (rowe@oakland.edu)

Lori Tirpak (tirpak@oakland.edu)

ARGOS_UTS

Michael Cox (cox@oakland.edu)

||OU_UTS_University_Technology_Services||OU_UTS_Scheduled||Theresa Rowe (rowe@oakland.edu)||Lori Tirpak (tirpak@oakland.edu)||ARGOS_UTS||Michael Cox (cox@oakland.edu)

Argos Reporting User Group Meetings

The Argos Core Reporting Group meets monthly to demo DataBlocks and Dashboards, address issues and discuss enhancements.

Please contact one of the Argos Core Reporting DataBlock Designers in the table above to find out when and where the next meeting is being held.

Available Training

Note:

  1. Recommendations for SkillSoft Training - Intro to PL/SQL or Intro to 11g/12c.

  2. An Evisions/Argos Account/ID is NOT needed to view or take the above training.
  3. Access to the Argos application (DataBlock Designer, Report Writer or Report Viewer) is NOT needed to view or take the above training.

Access Requirements, Set-up & Guidelines

There are three (3) steps for a new Group or User to get setup:

  1. Argos ADO Connection ID
    Argos ADO Connection ID: Steps for requesting the creation an Argos ADO Connection ID. Also instructions for generating list of Roles, Grant statements and Request to Data Stewards.
    /ArgosConnectionId

  2. Argos Business / Group Folders
    Argos Business / Groups Folders: Requirements for creating new Group Folders.
    /ArgosAccess

  3. Argos User Access
    Argos User Access and Security: Requirements for getting access to Argos Reporting (Report Viewer, Report Writer and DataBlock Designer).
    /ArgosAccess

SQL Developer Export Acceptance

SQL Developer Export Acceptance: Legal requires that we track users that have downloaded SQL Developer.
/ArgosSqlDevAccept

How-To Pages

  • Argos Help: Help with the Argos Reporting Tool.
    /ArgosHelp

  • SQL Developer Setup: Help with setting up SQL Developer.
    /ArgosSqlDev

Technical Standards and Procedures

  • Development and Testing Guide: Instructions on where to develop and test.
    /ArgosDevelopmentGuide

  • Querying tables with SSN: Instructions on querying against Banner Views without SSN.
    /ArgosSsnInfo

  • Coding Standards: Standards for DataBlock and Report Writers.
    /ArgosCodingStandards

  • Naming Conventions: Standards for naming variables and objects.
    /ArgosNamingConventions

  • Request Production Promotion: Instructions for requesting a promotion of Argos objects to Production.
    /ArgosPromotionRequest

  • SFTP file Task: Instructions for using SFTP file Task in a DataBlock Schedule.
    /ArgosSftpTask

  • GoAnywhere SFTP Setup: Instructions for requesting a GoAnywhere Resource and SFTP Job to connect and transfer files to an approved Vendor.
    /ArgosGoAnywhereJob

Administration Procedures

Note: Please provide ALL Details in the Footprints Ticket as to WHAT was performed, executed, granted or created.