![Page 1: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/1.jpg)
Pennsylvania BANNER Users Group
2007
Getting Started with Self-Service Reporting
![Page 2: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/2.jpg)
General Announcements:
Please turn off all cell phones/pagers If you must leave the session early, please do so as
discreetly as possible Please avoid side conversations during the session Questions will be answered at the end of the session
Thank you for your cooperation
![Page 3: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/3.jpg)
Immaculata University
A private, liberal arts, coeducational Catholic University 375+ acres on a hill overlooking historic Chester County,
Pennsylvania; about 20 miles west of downtown Philadelphia
![Page 4: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/4.jpg)
Immaculata University
Three (3) Colleges offering associate, bachelor's, master's and doctoral degrees:
– College of Undergraduate Studies – 861 students (for Fall 2007)
– College of Graduate Studies – 1120 students (for Fall 2007)
– College of Lifelong Learning – 1991 students (for Fall 2007)
Fall 2005 - 1st Undergraduate coeducational class
![Page 5: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/5.jpg)
Definition of the Problem
Challenges with Baseline Banner reports– Student Attributes
• Primary Attributes & Secondary Attributes
Challenges with MS Access reports– Complex Development Requirements
• Need for Subqueries Max Effective Term• Role-Level Security Required• Client Install Required; Version & PC Idiosyncrasies
Uncertain Needs/Requirements
![Page 6: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/6.jpg)
Multi-Faceted Solution
1. Information Layer• Custom Views & Functions
2. Presentation Layer• Self-Service Banner
![Page 7: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/7.jpg)
Information Layer
Core, Custom Views– Consolidates information around common areas of business
• Simplifies retrieval of data– Provides for consistent results
• Common “Joins”• Use of functions that contain IU “Business Logic”
– Simplifies Security• Banner Role-Level Security – as needed for MSAccess
– Flexible to be used by multiple applications• Banner Self-Serve, Banner Population Selections, MSAccess, or any other
reporting application Supports All IU Reports (whenever possible)
![Page 8: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/8.jpg)
Information Layer…
Examples:– Core, Custom Views
– Custom Functions• Encapsulates Immaculata University business logic• f_iu_get_primary_attribute()
– Returns the primary attribute for the specified Student & Term from the Student Attribute Table (SGRSATT)
• General Person View (GZVCGEN)• Student View (SZVSTUD)• Enrollment View (SZVENRL)• Degree/Academic History (SZVDEGR)• Course Catalog View (SZVCRSE)
• IPEDS View (SZVIPED)• Recruit View (SZVRECR)• Admission View (SZVADMS)• Accounts Receivable (TZVBURS)• Institutional Advancement (AZVCONS)
![Page 9: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/9.jpg)
Presentation Layer
** Self-Service Reporting **** Self-Service Reporting ** (“Matrix”)– Core technical competencies
• Banner/Oracle Web Development using PL/SQL– Familiar, easily accessible user-interface– Robust, standardized reporting solution– 12 “Matrix” Reports serve:
• 10 Departments (approximate)
• 50 Key Users (approximate)
![Page 10: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/10.jpg)
Presentation Layer…
Ctrl-Click to SelectMultiple Parameters
![Page 11: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/11.jpg)
Presentation Layer…
Information in BLUE hyperlinks to
additional, detail information
![Page 12: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/12.jpg)
Presentation Layer…
Drill-Through to Detail Information Page
Option to “Download” to a
Spreadsheet
![Page 13: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/13.jpg)
Benefits of our Self-Service Reporting Solution…
Runtime Parameters– One report serves multiple needs
Drill-Through Capability– Option to navigate from high-level to detail-level
Option to Save to Spreadsheet– Option to download the report information into a
MSExcel spreadsheet (*.csv file)
Accessible from any location (with internet connection)
![Page 14: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/14.jpg)
Technical Overview
Quick Tips BEFORE developing Self-Service Reports– Don’t “Ready, Shoot, Aim” !
– A little planning goes a long way…
– “Banner Web Development” Training (from SunGardHE)• Joseph Langevin, SunGardHE Sr. Technical Consultant
– Adhere to Development Methodologies• Define, Design, Code, Test, Implement, Feedback…
– Adhere to Standards & Naming Conventions
![Page 15: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/15.jpg)
Self-Service Report Development Steps
1. Adopt “Modular Reporting” Model
– Develop one (1) “Package” Per Report
Example: BZSKCANL = Course Analysis Report
– Utilize “Information Layer”
![Page 16: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/16.jpg)
Self-Service Report Development Steps
2. Create “Download to Spreadsheet” Procedure– Create Procedure as “csv” – bzskcanl.csv– Format Web Browser – Add BEFORE print logic
owa_util.showpage;
owa_util.mime_header('text/comma-separated-values');
– Print Comma-Delimited Information – htp.print()
![Page 17: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/17.jpg)
Self-Service Report Development Steps
3. Compile Report as Banner User = “baninst1”
CREATE OR REPLACE PACKAGE baninst1.bzskcanl AS …
4. Grant privileges to run report in Banner Self-Service WWW_USER is the proxy user for Banner Self-Service
GRANT EXECUTE ON bzskcanl TO www_user;
![Page 18: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/18.jpg)
Self-Service Report Development Steps…
5. Add new, custom report to WebTailor Add ALL Procedures in your new Report Package
![Page 19: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/19.jpg)
Self-Service Report Development Steps…
6. Secure Reports– Create custom “WebTailor Role”
• Create one (1) “WebTailor Role” Per Report
INSERT INTO TWTVROLE(TWTVROLE_CODE,TWTVROLE_DESC,TWTVROLE_ACTIVITY_DATE,TWTVROLE_USER_DEFINED_IND)
VALUES('IU_CRSE_ANALYSIS','IU Course Catalog Reporting',trunc(SYSDATE),'Y');
– Add Users to custom “WebTailor Role” INSERT INTO TWGRROLE
(TWGRROLE_PIDM,TWGRROLE_ROLE,TWGRROLE_ACTIVITY_DATE) VALUES
(12345,'IU_CRSE_ANALYSIS', trunc(SYSDATE));
![Page 20: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/20.jpg)
Self-Service Report Development Steps…
![Page 21: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/21.jpg)
Organize your Custom Reports
Add custom Report to a custom Menu– Create new Menu to “WebTailor” – bmenu.IU_Reports– Click “Customize Menu Items” to add custom report to
custom menu – bzskcanl.P_Display_Canl_Choices
![Page 22: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/22.jpg)
Organize your New, Custom Reports…
Add custom Menu as a custom Tab– Add to “standalone_role_nav_bar”
![Page 23: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/23.jpg)
Future Direction
Expand & Enhance Banner Self-Service “Matrix” Reports with Key University Reports
Capture Usage & Performance Statistics– Self-Service “Matrix” Usage Report
Improve Reporting Architecture– Move toward a dedicated reporting architecture……away from a production, transactional reporting
architecture (Banner)
![Page 24: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/24.jpg)
Future Direction…
Additional Reporting Tools Argos (from eVisions)
– Batch, Burst Nightly Reports to Users
• Longitudinal (Year-Over) Analysis• Dynamic Charts, Graphs, & Data• Argos Co-Op
![Page 25: Pennsylvania BANNER Users Group 2007 Getting Started with Self-Service Reporting](https://reader035.vdocuments.us/reader035/viewer/2022081507/5514ff03550346b0478b643d/html5/thumbnails/25.jpg)
Thank You !
Patrick Kelly – Director, Administrative Computing– [email protected]
Fred Lukens – Systems/Reporting Analyst– [email protected]