Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

...

HTML
<script>
jQuery(document).ready(function()
{
jQuery(".external-link").attr("target",
"_blank");
});
</script>

Table of Contents:

 

  1. Purpose

  2. Support

  3. Additional Resources

 
Anchor
instructions_purpose
instructions_purpose

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. 

Anchor
instructions_instructions
instructions_instructions

2. Instructions – 

  • Firewall Access: 
    1. Request EPMPROD/QNYEPM03/EPMNY01P/EPMTEST firewall access by emailing it.

...

...

...

...

    1.  Please include the IP address of your work PC. 

    2. Make sure that

...

    1. all entries are up-to-date

...

    1. in the

...

    1. tnsnames.ora and

...

    1. swlnet.ora files. 
    2. The files should reside in the Oracle folder: 

...


    1. Image Added

    2. Test the connections using telnet

...

    1. by typing "cmd" in the Start window and

...

    1. hitting Enter

...


...


    1. Image Added

...


    1. Image Added

    2. Type the following commands at the cmd line.

...

    1. Each command should be typed individually: 

    ...

    ...

        1.  1530

    ...

    ...

        1.  1531

    ...

    ...

        1.  1533

    ...

    ...

        1.  1533

    ...


        1. Image Added
      1. A successful connection will look like the

    ...

      1. screen below: 

    ...


      1. Image Added
      2. If you encounter more connection problems after completing this process, please follow the

    ...

      1. instructions in the

    ...

    View file
    nameSystem 11 Studio TNS Error Fix.pdf
    height250

    ...

    II.  Update TNS Entries

     

    1. TNSNAMES ENTRY:

     

     

    ...

     

    • 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.

    ...

      1. The location of your tnsnames.ora file may be in the following (or similar) path:

    ...

      1.  C:\Oracle\product\11.2.0\client_1\network\admin

    ...

      1. . 

       

          • 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. 

      ...


        1. Interactive Reporting (Brio) .OCE:

      ...

        1.  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.

       


        1. Testing Your Connection:

      ...

        1.  
          1. Click on your Start menu icon. 
          2. Type "cmd" and

      ...

          1. click Enter

      ...

          1. .
          2. A command window will open. Type "tnsping" and the name of the database that you

      ...

          1. wish to test your connection to. The name should match the entry in your tnsnames.ora file entry (

      ...

          1. e.g. "tnsping epmny01p"). 

      ...

          1. Please wait a few seconds for a response. If successful, you will

      ...

          1. recieve a

      ...

          1. message that reads "...

      ...

          1. attempting to contact..."

      ...

          1. which will end with "OK."

      ...

          1. See example below

      ...

          1. : 

       


          1. Used TNSNAMES adapter to resolve the alias

      ...

          1. Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=webprod-scan.

      ...

          1. cfs.its.nyu.edu) (PORT=1531)) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=we

      ...

      ...

          1. OK (30 msec)

      ...

          1. C:\Users\am11>

             

      III.  Updating your Queries

       

          1.  

      • Updating Your Queries: 

        1. Joining an Interactive Reporting (Brio)

      ...

        1. Query to UDW+ for the

      ...

        1. First Time: Please select DataModel ---> Synch with Database.

      ...

        1. This will

      ...

        1. notify you

      ...

        1. of any columns or

      ...

        1. tables in which the names might have changed so that you

      ...

        1. may update your query accordingly and decide

      ...

        1. whether to synch or wait. 

        2. Considerations for Creating Student Records Queries: Regardless of the tool that you are using

      ...

        1. to create your

      ...

        1. student records queries, the following considerations must be taken into account:

         

        UDW+ version of Student Records EPM contains the following enhancements:

            • Use D_Person or D_Student to

        ...

            • replace NYU_D_Person
              1. D_Student:

          ...

                  1. Has everything as D_person
                  2. D_

          ...

                  1. student joins to the Student_

          ...

                  1. Sld
                  2. In general, if your existing queries leverage NYU_D_Person, you should

          ...

                  1. switch to D_Student.
                1. D_

          ...

                1. Person:

            ...

                    1. Is a conformed dimension that is used throughout the warehouse
                    2. D_Person joins on a

            ...

                    1. fact to the Person_SID
                    2. In general, use of D_Person is specific to joining

            ...

                    1. person information across

            ...

                    1. 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+

            Anchor
            instructions_support
            instructions_support

            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).  

            Anchor
            instructions_add
            instructions_add

            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.