COGNOS REPORTING WAREHOUSE SUPPORT  10/27/2008 - 11:21  If you need assistance using Cognos, take advantage of Open Labs offered at the Fremont Training Center. The DWA training staff will be available to assist and answer questions, according to the schedule below. Seating at Open Lab is available on a first-come, first-served basis. Where: Fremont Training Center, Old Town, Bungalow B3 located at 2375 Congress St., San Diego, CA 92110 When: on the following days: Friday, November 7, 2008 (8:00am-11:00am) (12:00pm-3:00pm) Thursday, November 20, 2008 (8:00am-11:00am) (12:00pm-3:00pm) (We are closed for lunch between 11:00am-12:00pm) *Attention* Click here for directions to Fremont Training Center. Cognos unavailable on Tuesday, March 25, 2008 at 4:00pm  03/25/2008 - 09:26  Cognos will be unavailable on Tuesday, March 25, 2008 starting at 4:00pm for scheduled maintenance. It is estimated that it will be backup by 9 a.m. tomorrow. You will receive notification via email when the system is available. Please inform your administrator or staff that this unavailability may affect. Sorry for any inconvenience this may cause. COGNOS REPORTING WAREHOUSE SUPPORT  12/19/2007 - 10:27  If you need assistance using Cognos, take advantage of Open Labs offered at the Fremont Training Center. The DWA training staff will be available to assist and answer questions, according to the schedule below. Seating at Open Lab is available on a first-come, first-served basis. Where: Fremont Training Center, Old Town, Bungalow B3 located at 2375 Congress St., San Diego, CA 92110 When: on the following days: Friday, February 8, 2008 (8:00am-11:00am) (12:00pm-3:00pm) Friday, February 22, 2008 (8:00am-11:00am) (12:00pm-3:00pm) (We are closed for lunch between 11:00am-12:00pm) *Attention* Click here for directions to Fremont Training Center. Click here for Parking Permit. THE COGNOS REPORTING WAREHOUSE CAN BE ACCESSED FROM HOME!  09/21/2007 - 09:24  You can access the Cognos Reporting Warehouse outside of the district’s network at https://cognos.sandi.net/. Please be aware that the Cognos Reporting Warehouse will be unavailable nightly from 12:30am - 12:45am to accommodate system and data backups. In addition, starting every night at 2:00am, new and updated data from Zangle, Encore, and PeopleSoft from the prior day will be loaded into Cognos. This may cause slowness in the application until the updates complete. COGNOS REPORTING WAREHOUSE TRAINING & SUPPORT The IT Training & Support group has developed an easy to navigate website to provide assistance. If you need additional help, take advantage of Open Labs offered on Fridays at the Fremont Training Center. The Open Lab calendar is available here: http://www.sandi.net/peoplesoft/training/open_lab/practice.asp This site includes: Job Aids Knowledgebase Articles On-Line Tutorials As additional functionality is made available to you such as ad-hoc query writing, instructor-led training will be available. Visit the Cognos Training & Support website today at http://www.sandi.net/cognos The Cognos Reporting Warehouse is bigger & better for the new school year!  09/10/2007 - 14:56  WHAT‘S NEW IN COGNOS? CST test results for the past 6 years including the newly released 2007 scores can now be accessed using the Cognos Reporting Warehouse! THE COGNOS REPORTING WAREHOUSE IS HERE! The Cognos Reporting Warehouse is a web-based tool intended to provide district staff members the capability to report on a variety of data from various student information systems from ONE place! A diverse set of reports and tools are available via the Cognos Portal.The Cognos Reporting Warehouse currently contains data reported for students who are presently enrolled in a school, including schedule information, grades, absences and test scores. Reports display data at a district, site, classroom, and student level based on user access. You can access the Cognos Reporting Warehouse at https://cognos.sandi.net/. In order to help you get started, we have included these Knowledgebase articles; Article #533 will introduce you to the Cognos portal Article #534 gives information on system requirements to run Cognos, including supported browsers Article #535 provides data on how to locate Cognos jobaids Article #536 indicates how users can submit requests for new reports or additions to existing reports Article #745 gives information on how to interpret report data and who to contact Job Aids in the Read & Learn page will help step you through the process of logging in and navigating the portal. Visit the Cognos Training & Support website today at http://www.sandi.net/cognos New Reports Displaying Student Schedules Available in Cognos  08/30/2007 - 10:21  Three new reports are available in the Cognos Reporting Warehouse on August 27, 2007. Each of the new reports display the selected student’s schedule for all terms for several years. For each class, the report displays the school year, term, class period, school name, building, classroom number, from date, to date, course number, course name, section number, and teacher name. Classes are grouped by year and term and sorted in order of descending school year, ascending term name, and ascending period. The format of each report will differ based on the school type; Elementary, Secondary, or Extended Day Secondary. Student Schedule - Elementary (SI06A) - This report is useful for a relatively quick overview of a student's schedule over time and for determining where a student is during a particular period. Please see Knowledgebase Article #773 for more details. Student Schedule – Secondary (SI06B) - This report is useful for a relatively quick overview of a student's schedule over time and for determining where a student is during a particular period. Please see Knowledgebase Article #774 for more details. Student Schedule – Extended Day Only – Secondary (SI06C) - This report is useful for a relatively quick overview of a student's extended-day schedule over time and for determining where a student is during extended day. Please see Knowledgebase Article #775 for more details. New Reports Displaying CST Data Available July 2 in Cognos  06/29/2007 - 11:47  Two new reports will be made available in the Cognos Reporting Warehouse on Monday, July 2. CST Strand Results by Course/Section for Teacher, Student Strands (SP33SD) - Displays percentages of students by performance level for each test. Data is organized by students scheduled for a section in the master schedule. The aggregate data is displayed in the form of a stacked bar graph. A table showing the number of students at each performance level is included. The data is organized by strand and includes the number of questions, number correct, and percent correct. Please see Knowledgbase Article #732 for more details. CST Strand Results by Course/Section for Teacher, Student Demographics (SP34SD) - Displays individual results for each student in a specific section including: current grade level, student ID, name, performance level on CST test, scale score, test subject, and student demographic information. The aggregate data is displayed in the form of a stacked bar graph. Please see Knowledgebase Article #764 for more details. Both reports display last year's test results and filter on the current year and prior school year schedules. This makes them useful for allowing teachers to understand the past performance of both prior and current students. New Job Aid and OnLine Tutorial; Setting Your Cognos Portal View  06/07/2007 - 15:28  Early users of Cognos (those who logged in to Cognos before 9am on Wednesday, June 6th) missed out on one last significant update made to the Cognos User Interface. When you log in, if your portal displays 2 tabs called Public Folder and My Folder, without any graph at the right, then you may have been an early adopter of Cognos who missed out on this update. A job aid and corresponding online tutorial have been written that show you how to reset your view to the Cognos Reporting Warehouse portal when you log in.