Versions Compared

Key

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

 

CUNYfirst offers two different reporting services. Read more about each below and how to access.

Note

Production Reporting data is real time.

Development Reporting is from previous day through midnight.

Production Reporting Tools

The CUNYfirst service includes production Reporting Tools (HR/Campus Solutions > Reporting Tools >Query > Query Viewer). The queries in the production Reporting Tools use live production data and the queries are managed by CUNY Central CIS. The production Reporting Tools queries are generally written to cover a general data need and often use prompts for to limit results to a particular institution, semester, career, etc. The production queries may not necessarily be specific to the unique needs of an individual business unit's process or data needs, but in these cases may serve as a starting point for a customization in the reporting instance, the instance that CUNY CIS allows the campus to develop and run queries on.

Accessing Production Reporting Tools

Development Reporting Instance

The development reporting instance is a separate service which allows assignment of Query Manager role for creation, editing, and deletion of private queries, copying of public queries for editing, and viewing and scheduling of public or private queries. The development reporting instance also allows for assignment of Query Viewer role for viewing, organizing and scheduling public and private queries. All data in Reporting Instance have are one day older than CUNYfirst production system.

Accessing Development Reporting Instance

 

...


Anchor
production
production
Access Production Reporting Tools

Go to https://home.cunyfirst.cuny.edu/oam/Portal_Login1.html to access CUNYfirst log-in page.  Place Username and Password then click Log-in.

...

Click on 'Excel' to download a report from a separate window or 'Schedule' the same query for a Query Manger or Query Viewer.  

Anchor

Development Reporting Instance

...

development
development
Development Reporting Instance

Select 'Reporting HR/Campus Solution' and click.

...

Select the appropriate query and click 'Edit' link to display properties for a query for a Query Manger.  Click 'Excel' link to download a report for a Query Manger or Query Viewer.  User can also add any queries to their favorite.  For QM Select a query then click on Action drop down box, choose 'add to Favorites' then click 'Go'.  For QV click 'Favorite' link for any chosen query will be added to an user's screen.

 

Useful Production Queries

 

...