Skip to end of metadata
Go to start of metadata

Table of Contents:

 

  1. Purpose

  2. Support

  3. Additional Resources

 

1. Purpose – The purpose of this page is to provide users who are experiencing direct connection problems with various, thorough instructions to solve their specific issue. 

2. Instructions – 

  • Firewall Access: 
    1. Request EPMPROD/QNYEPM03/EPMNY01P/EPMTEST firewall access by emailing it.bi@nyu.edu or sis-integrate-group@nyu.edu. Please include the IP address of your work PC. 

    2. Make sure that all entries are up-to-date in the tnsnames.ora and swlnet.ora files. 
    3. The files should reside in the Oracle folder: 



    4. Test the connections using telnet by typing "cmd" in the Start window and hitting Enter: 





    5. Type the following commands at the cmd line. Each command should be typed individually: 
      1. telnet adc475-scan.cfs.its.nyu.edu 1530
      2. telnet scan-162.cfs.its.nyu.edu 1531
      3. telnet adc162-rac.cfs.its.nyu.edu 1533
      4. telnet adc163-rac.cfs.its.nyu.edu 1533

    6. A successful connection will look like the screen below: 

    7. If you encounter more connection problems after completing this process, please follow the instructions in the attached PDF document

 

  • Update TNS Entries: 

    1. TNSNames Entry: Below is a list of the tnsnames entries for UDW+ (EPMNY01P) which you will need to add to your Oracle client tnsnames.ora file. The location of your tnsnames.ora file may be in the following (or similar) path: C:\Oracle\product\11.2.0\client_1\network\admin. 
      • EPMNY01P.WORLD =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = adc477-scan.cfs.its.nyu.edu)(PORT = 1531))
            (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = epmny01p.its.nyu.edu)
            )
          )
      • Note – You may or may not need the ".WORLD" suffix in the entry above, depending on whether the suffix exists in all of your other entries. 

    2. Interactive Reporting (Brio) .OCE: Attached is an .oce file I created locally to connect to UDW+ (EPMNY01P).  I have also published the .oce to the Interactive Reporting (Brio) portal so you can select it from the list when publishing relevant BQYs.

    3. Testing Your Connection: 
      1. Click on your Start menu icon. 
      2. Type "cmd" and click Enter.
      3. A command window will open. Type "tnsping" and the name of the database that you wish to test your connection to. The name should match the entry in your tnsnames.ora file entry (e.g. "tnsping epmny01p"). 
      4. Please wait a few seconds for a response. If successful, you will recieve a message that reads "...attempting to contact..." which will end with "OK." See example below: 

        Used TNSNAMES adapter to resolve the alias
        Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=webprod-scan.
        cfs.its.nyu.edu) (PORT=1531)) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=we
        bprod.linux.its.nyu.edu)))
        OK (30 msec)
        C:\Users\am11>

         

         

  • Updating Your Queries: 

    1. Joining an Interactive Reporting (Brio) Query to UDW+ for the First Time: Please select DataModel ---> Synch with Database. This will notify you of any columns or tables in which the names might have changed so that you may update your query accordingly and decide whether to synch or wait. 

    2. Considerations for Creating Student Records Queries: Regardless of the tool that you are using to create your student records queries, the following considerations must be taken into account:
      • Use D_Person or D_Student to replace NYU_D_Person
        1. D_Student:
          1. Has everything as D_person
          2. D_student joins to the Student_Sld
          3. In general, if your existing queries leverage NYU_D_Person, you should switch to D_Student.
        2. D_Person:
          1. Is a conformed dimension that is used throughout the warehouse
          2. D_Person joins on a fact to the Person_SID
          3. In general, use of D_Person is specific to joining person information across student, HR, and UDM data marts/
      • Reporting Department – Use this to group schools and departments consistently across different areas. This is centrally updated by NYU Office of Institutional Research.
      • HR Instructor Data – Instructor dimension has been enriched with data job data elements from the HR data mart.
      • Full CPP Stack (Grain change on all Subject Areas due to multiple Plans/Subplans) – Queries will now need to be filtered on Primary Plan = Y if you wish to limit to only the primary plan for each student.
      • All Class Instructors (Grain Change on Class Enrollment) – The instructor dimension contains all instructors for a given course. Limit to Primary Instructor Flag = Y to refine your result set to one record per class.
      • Test score data is now available. 
      • Note – All tables that exist in EPM Prod also exist in UDW+. 

7. Support – If there is an issue that you would like to report or you have questions about UDW+, please contact the Decision Support Group by email at askDSG@nyu.edu or call 212-998-2900 (extension 82900).  

8. Additional Resources – Training is recommended for those who are new to UDW+. To schedule a one-on-one training session, contact the Decision Support Group at 212-998-2900 or email askdsg@nyu.edu. The NYU Business Glossary is a living document that contains commonly used NYU business terms for reference.

  • No labels