Data Warehouse Student Group Meeting June 6, 2018
"Explore recommendations for new student data collection and cleanups in preparation for NGSS upgrade to BI4.2. Discuss potential reports, data cleanups, and new features including Recycle Bin and Geo mapping. Reference cells like Excel, merge variables, and maximize query panel for efficient data management."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Data Warehouse Student Data User Group Meeting June 6, 2018
Data Warehouse Student Data Users Group Agenda NGSS Pennant Records DW Student data working group Group s recommendations for new Student data collection SRFS data cleanups in preparation for NGSS SAP Business Objects Upgrade to BI4.2 Service Pack 5 Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group NGSS Pennant Records updates Refer to Confluence site https://confluence.apps.upenn.edu/confluence/display/dwUpgrade/Recommendations+ for+Student+Data+reporting NGSS DW working group participants Working group recommendations for new DW student collection Potential reports for new DW student collection Send comments regarding recommendations or potential reports to Susan Collins squant@upenn.edu Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group SRFS data cleanups in preparation for NGSS Changing Exchange students entry_action Making sure all deceased students have an exit_action Data cleanups not done in the Census data Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group Upgrade to Business Objects BI 4.2 - New Features Recycle Bin can recover deleted Webi documents Parallelized data providers shortens query execution time You can maximize the Query Panel to fit the whole screen and it remembers that you did it next time you go in. You can also turn off the data preview if you want and toggle it back on only when you need it (rather than each time). Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group Upgrade to Business Objects BI 4.2 - New Features Ability to reference cells (like Excel) see How Tos /FAQs Geo mapping feature by Country Name or GPS coordinates Merge variables (not just universe data elements) Instructions for some of the new features here: https://confluence.apps.upenn.edu/confluence/display/dwUpgrade/BI+4.2+How- Tos+and+FAQ%27s Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group Upgrade to Business Objects BI4.2 - Fixes HTML Parity Things previously only available in Java are now available in HTML mode Creating and editing subqueries Data Access > Tools tab and related functions: o Changing a query's source universe o Exporting query data o Custom formatting of numbers in tables o Conditional formatting options Firefox No longer get "JavaScript error while calling onChangeDocID" when trying to create a new document More details in Miscellaneous & Browser Troubleshooting section at https://www.isc.upenn.edu/businessobjects-tips-faqs Data Warehouse Student Data Users Group June 6, 2018
Data Warehouse Student Data Users Group Wrap Up Questions on any topics presented today? Other topics / Suggestions for future meeting topics? Data Warehouse Student Data Users Group June 6, 2018
