Reporting/Data Warehouse

The following questions are related to reporting and data warehouse. Click on the question to jump to the answer.

 

Can I request direct access via ODBC to the LionPATH data warehouse?

Direct access to the LionPATH data warehouse is not being granted due to the complexity of the warehouse. The recommended solution for obtaining the data will be via LionPATH subject areas within iTwo.

What are some advantages of iTwo?

iTwo is a user friendly tool with drag and drop capabilities. Also, users don’t have to worry about joining multiple tables together in order to get the correct results; table joins are already done behind the scenes.

What if LionPATH subject areas in iTwo will not meet my data needs?

Send an email to ProjectLionPATH@psu.edu and the LionPATH team will work with you to determine the best solution to meet your needs.

 

Who has access to view dashboards using LionPATH data

Access to dashboards using LionPATH data have been granted automatically to certain job families with responsibilities. Emails will be sent to users notifying them that they have access to new dashboards as they become available.

How do I request access to admissions data in iTwo? I have a legitimate educational need to see this information.

To request access to admissions data in iTwo, please go to the following link: http://kb.its.psu.edu/node/2197. Once there, click on the Admissions link located under Subject Areas. Then click on the iTwo Admission request form link to submit your request.


How do I request access to view the class meeting patterns dashboard? I have a legitimate educational need to see this information.

To request access to the class meeting patterns dashboard, please go to the following link: http://kb.its.psu.edu/node/2197. Once there, click on the Student Enrollment and Course Enrollment link located under Subject Areas. Then click on the iTwo Student Enrollment and Course Enrollment request form link to submit your request.

How do I request access to view the student and instruction dashboards using LionPATH information? I have a legitimate educational need to see this information.

To request access to the student and instruction dashboards, please go to the following link: http://kb.its.psu.edu/node/2197. Once there, click on the Student Enrollment and Course Enrollment link located under Subject Areas. Then click on the iTwo Student Enrollment and Course Enrollment request form link to submit your request.

Where do I go to see the student and instruction dashboards available that are using LionPATH data?

  • Go to https://itwo.psu.edu/analytics/
  • Use your Penn State Login
  • Click on “Dashboards,” then expand “Student and Instruction” and you will see the dashboards available using LionPATH data.
  • Previous dashboards under ‘Student and Instruction’ have been moved under ‘Student and Instruction – Legacy.’ These will remain available at this location for your reference.iTwo student instruction dashboard

 

How often will LionPATH data be updated in iTwo?

Data will be updated nightly.


How do I get to the iTwo LionPATH data training materials?

Data training materials are available in the LionPATH online help library, under ‘iTwo LionPATH Reporting Documentation’.

Will it be beneficial to have access to iTwo?

Yes, it will be beneficial for you to have access to iTwo if you need to view reports or access data. The primary method of accessing reports, dashboards and data will be via iTwo. We strongly recommend taking iTwo training to become familiar with accessing and generating reports.


Do I need access to the data warehouse to take iTwo training?

Access to the Data Warehouse is not needed to take iTwo training. If you do not already have iTwo access, temporary access will be given for a short period of time to those taking training.

Will I see both the old and new values in iTwo?

Based on your security access, within iTwo, you will be able to view all of the dashboards and reports that access the existing data warehouse, and you will be able to view the new dashboards and reports that are created from LionPATH. You will also be able to create your own reports. However, you will not be able to mix or view the old values and new values in iTwo together in a single report.

Will the reporting team help build iTwo dashboards and reports to replace what offices and departments are doing now to generate reports?

Offices that currently use the existing data warehouse will need to create new reports to replace their reports and processes. They may also have to commit resources and time to this effort. The Reporting/Data Warehouse team will work with offices to ensure that they have access to the information that they need. There will be some initial reports available, but the actual development of specific reports may be the responsibility of the individual offices.

Will information from Talisma go into iTwo?

Talisma data is not scheduled to be available in iTwo. Only data coming from the existing data warehouse or the LionPATH data warehouse will be available in iTwo. Talisma data is not in either warehouse.

Will everyone have access to PS (PeopleSoft) Queries in LionPATH?

Access to PS Queries will be determined by a person’s role and data access within LionPATH. This means that not everyone will have access to run PS Queries.

Can anyone build PS Queries?

The ability to create or build PS Queries against the LionPATH system will be limited. The criteria for having this ability has not been determined yet, but will be shortly. Regardless of whether an individual is given access or not, they will not be able to write and run PS Queries on the fly. Every PS Query will go through a development process and be reviewed and tested before being put into the production database to ensure it does not interfere with system performance.

Will real-time queries run against the LionPATH system, or the LionPATH data warehouse?

Real time queries will run against the LionPATH system.

Will reports have the ability to be filtered?

Many PS Queries against LionPATH will have drop down selection boxes to filter results. Similarly, iTwo reports will also have drop down selections to do the same. These filters are easily customizable.

Can I schedule queries and have them downloaded to my desktop automatically?

You can schedule any PS Queries to which you have security access to run automatically. However, they are not downloaded automatically to your desktop. Similarly, reports on iTwo can be scheduled to run automatically. Like PS Queries though, they will not automatically be downloaded to your desktop.

When will additional information be available?

Please visit our reporting release schedule.