Constituent Report - Dual Alumni from 2 Schools

Where is it?

Link to Report: http://businessintelligence.dsc.umich.edu/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AWWUgJSbn0VNuV2hdZZszSU

BusinessObjects Folder Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Constituent Reports/

​​​​​What does it do?

This report is designed to pull all active alumni with a degree from both of the given Schools/Colleges.

Keywords: Constituent, Alumni, Degree, SCU

Why use this report?

Use this report if you need to find all alumni with degrees from both specified institutions

E.g. Find all Alumni with a degree in both Engineering and Information 

How to use this report?

Scheduling

Please refer to this article for more information on scheduling reports: https//teamdynamix.umich.edu/TDClient/83/Portal/KB/ArticleDet?ID=7265

Running the Report Directly

Click the highlighted icon to bring up the user prompts.

If the report is taking too long to run, schedule the report (see above).

Prompts

You then need to set the prompts. (Prompts act as questions that help you to customize the information in a report to suit your own needs!)

Below are the available prompts (with explanation) —

  • Enter value(s) for Educational College 1:

    • Allows users to select one or more U-M Schools/Colleges (SCUs)

    • E.g., College of Engineering, School of Information
       

  • Enter value(s) for Educational College 2:

    • Allows users to select one or more U-M Schools/Colleges (SCUs)

    • E.g., School of Public Health, School of Social Work

Report Tabs

There is 1 report tab:

  • Report Tab 1

    • Displays all active alumni with a degree from each School/College. 

    • Includes Constituent LookupIDs (LIDs), Full Names, PA City, PA State Code, Degrees, and Class Years for each degree