MProfile Helper - Parents by Geolocation

This report can be used to pull the names and LookupIDs of parents of current U-M students using the parent's Geolocation

Where is it?

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

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

​​​​​What does it do?

This Report

This report can be used to pull the names and LookupIDs of parents of current U-M students using the parent's Geolocation

Keywords

MProfile Helper Student Education

Why use this report?

Use this report along with the other set of MProfile helper reports in order to easily pull parent LookupIDs of University of Michigan students for use in the 10.0 Excel MProfile - Parents By LookupID with Student Info report in order to pull reports on parents.

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

Parent’s Address (Optional)

Answer the following prompt to restrict results for parents depending on the student’s permanent address

• Enter Parent’s City

  • You may select one or more values

• Enter Parent’s State

  • You may select one or more values

• Enter Parent’s Zip

  • You may select one or more values

• Enter Parent’s Country

  • You may select one or more values

Parent’s Primary Metro Area (PMA) (Optional)

Answer the following prompt to restrict results for parents depending on which primary metro area their address is assigned to

• Enter Parent’s Primary Metro Area (PMA)

  • You may select one or more values

  • E.g., Baton Rouge, LA

Parent’s Greater Metro Area (GMA) (Optional)

Answer the following prompt to restrict results for parents depending on the greater metro area their address is assigned to

• Enter Parent’s Greater Metro Area (GMA)

  • You may select one or more values

  • E.g., Denver, CO

Parent’s Major Gift Region (MGR) (Optional)

Answer the following prompt to restrict results for parents depending on the major gift region their address is assigned to

• Enter Parent’s Major Gift Region (MGR)

  • You may select one or more values

  • E.g., Midwest

Report Tabs

There is 1 report tab:

• Report

  • This tab provides the set of parent LIDs and full parent names returned from the query sorted by the parent's LID value.