1 / 28

Data Warehouse Student Data User Group Meeting - 4/25/2013 Class of ‘78 Pavilion Van Pelt Library

Data Warehouse Student Data User Group Meeting - 4/25/2013 Class of ‘78 Pavilion Van Pelt Library. Student Data User Group - 4/25/2013. Agenda. News Summary Tips & FAQs Highlights Discussion topics Inventory subgroups New exit action D1 and entry action R1 Cross-division majors

arnold
Download Presentation

Data Warehouse Student Data User Group Meeting - 4/25/2013 Class of ‘78 Pavilion Van Pelt Library

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehouse Student Data User Group Meeting - 4/25/2013Class of ‘78 PavilionVan Pelt Library

  2. Student Data User Group - 4/25/2013 Agenda • News Summary • Tips & FAQs Highlights • Discussion topics • Inventory subgroups • New exit action D1 and entry action R1 • Cross-division majors • New admin structure in Arts & Sciences – PLE

  3. News Summary • Webi training schedule changes – On-campus training taught by ONLC has been reduced to 4-5 offerings per year. • New columns: • SUBGROUP_1_TITLE, SUBGROUP_2_TITLE added to COURSE_INVENTORY • New exit action D1-1st Drop and associated entry action R1 -Readmitted • In the warehouse, this looks like a leave of absence • Implementing cross-division majors: • NAS, NEG – added as NON-DEGREE PROGRAM values to DEGREE table • Appears in APPROVED_ACADEMIC_PROGRAMS, DEGREE and not in DEGREE _PURSUAL_ALL_V • New administrative structure in Arts and Sciences

  4. Training Tip • Consider Youtube for self-training videos on Webi. There are videos ranging from the basics to more advanced topics, and are a good alternative to the on-campus Business Objects training. • www.youtube.com -> search for Web Intelligence 3.1 • Recommended SAP author: RimGeurts • Stick with the 3.1 tutorials… we won’t be going to 4.0 for a while. • Caution: Not all videos are produced by the vendor, nor in English • Feel free to contact data administration with your training questions

  5. Tips & FAQs Highlight • How to Sort on multiple columns in Infoview and Webi • http://www.upenn.edu/computing/da/bo/webi/qna/iv_orderBreaksSorts.html • From the FAQs & Tips page, a search for sort leads to the url listed above. • The most efficient way to do this is with InfoView Interactive View mode, but it can be done in Webi too.

  6. Tips & FAQs Highlight • How to Sort on multiple columns in Infoview and Webi To create report sorts on multiple columns • Click the sort icon #2 from the toolbar or Right-click in a column that you want to sort by • Choose type of sort Ascending or Descending. • 3. Notice that by default the sort priority is the same as the order that you created the sort.

  7. Tips & FAQs Highlight • How to Sort on multiple columns in Infoview and Webi To view and change sort priorities • Select a column that has a sort and click on it. (Sort button #2 looks 'indented' when a column that has sorts is clicked.) • Either select the drop-down menu from the sort button #2 or right-click. • SelectProperties, and the Sort Properties window appears. • Select the column you want to reposition and using the arrows move it up or down in the priority list.

  8. Tips & FAQs Highlight • How to Sort on multiple columns in Infoview and Webi • Select the column you want to reposition and using the arrows move it up or down in the priority list.

  9. Questions about sorting on multiple columns?

  10. Tips & FAQs Highlight • How to pick the correct enrollment branch in STDTCANQ http://www.upenn.edu/computing/da/dw/student/stdtcanq.html • There are 3 ways to get to enrollment in courses and to course data in general; These are referred to as the AA, AB, and AC branches. • Choose the branch based on your purpose for the enrollment data in that specific query/report.

  11. Tips & FAQs Highlight • How to pick the correct enrollment branch in STDTCANQ AC Branch:  If you’re just getting a list of everyone taking a course (or courses), and nothing else. Note in the diagram Enrollment joined directly to Person table. AB Branch:  If you want people in a course AND you want to report on anything else happening that same term --- their majors, or their divisions/degree or dual degree status, their advisors, etc. The AB branch is the one used most often. Note in the diagram that to get from Enrollment to the Person table you must join through Degree Term and Degree Pursual. AA Branch:  If you’re reporting on people in a course but you only want to see the ones who are counting that course towards a specific degree or appearing on a specific transcript.   (Uses the “career pointers” in SRS to determine the enrollment assignments.) Note in the diagram that to get from Enrollment to the Person table you must join through Assignment and Degree Pursual.

  12. Questions about enrollment branches?

  13. Questions about enrollment branches?

  14. Inventory subgroups

  15. SRS online help says: “SRS uses this value to group courses in the Course Register in an order other than the subject area.” The codes appear on screen 125; the values appear on screens 1D2 and 1D3: In the warehouse, the subgroup text will be in the Course_Inventory table:

  16. Questions about subgroups?

  17. New exit_action: D1 • In SRS, it looks like a drop, but • In the Data Warehouse, it looks like a Leave of Absence • The corresponding entry_action is R1

  18. An exit_action of D1 is a “First Drop”. It is used as an intermediate probationary action: more serious than a mandatory leave, but not as serious as “dropped by division”

  19. The return from a D1 should be an R1

  20. In SRS, a student who exits with a D1 will have “Dropped” and the date placed on their transcript. But in the Data Warehouse, this person will look like a Leave of Absence. The leave flags will be set on all of the relevant tables (degree_pursual_all_v, degree_term_all_v, major_minor_term), and a row will be inserted into the Leave table.

  21. A student who is returned from a D1 exit should be returned using the R1 entry action. In the Data Warehouse, the leave flags will be cleared out in the appropriate places, just like any other leave of absence, and the Leave table updated. (note: the only place you will see R1 in the warehouse is in the Student_APS table.)

  22. Questions about D1 or R1?

  23. Cross-division majors In the Approved_Academic_Programs table, you’ll see cross-division majors appearing like this: Note that you can no longer tell from this table that the BCHE major is administered by Arts and Sciences. In other words, this table tells you what students are allowed to major in; it does not tell you the administrative relationships between majors, divisions and schools.

  24. The NAS and NEG degrees were created so that they can be used by the Academic Planning Worksheets. This is their only purpose, and although you may see some entries for NAS and NEG in the Approved_Academic_Programs table, students should not be matriculated into those degrees on screen 110 (and you should not see these in Degree_Pursual).

  25. Questions/discussion about cross-division majors?

  26. New administrative structure in Arts and Sciences

  27. Any other news anyone else would like to share?

  28. Wrap-up • Next Data Admin/BusinessObjects Office Hours: May 6 (Mon) • For all warehouse data collections , Freestylin’ Open Lab • Register in KnowledgeLink • Next SDUG Meeting: June- July? • We are seeking… • Suggestions for topics/ presentations/ speakers • Volunteer(s) to present • Thank you for coming!

More Related