RAH-Award-View Quick Start Guide

Owned by Saparnell
Last updated: Mar 09, 2022
2 min read

This view contains a summary of the Award information.

Data Loads:

Data is loaded nightly from Kuali.

Granularity:

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

Cognos developers: Cognos will aggregate the totals at the correct grain.  You can shut off the aggregation as needed.

Tableau developers:  Tableau will aggregate the total for all levels of the view, this will inflate your numbers.  Level of Detail calculations have been built into the Tableau data source based on the measure's the granularity.


LevelKey (uniqueness / group by)Attributes
1UCSD Award Sequence Number

UCSD Award Number - Full + UCSD Award Sequence Number + Award OP Reporting Date






Tableau report developers:  {FIXED [UCSD Award Number - Full], [UCSD Award Sequence Number]: MIN([Award...])}

Tableau report developers:  {FIXED [UCSD Award Number - Full], [UCSD Award Sequence Number], [Award OP Reporting Date]: MIN([Award...])}

Measure:
  • Award Anticipated Direct Cost
  • Award Anticipated Indirect Cost
  • Award Anticipated Total Cost
  • Award Obligated Direct Cost
  • Award Obligated Indirect Cost
  • Award Obligated Total Cost
  • Award Obligated To Date Direct Cost
  • Award Obligated To Date Indirect Cost
  • Award Obligated To Date Total
  • Award Pending Direct Amount
  • Award Pending Indirect Amount
  • Award Pending Total Amount
  • Award Investigator Count - COI
  • Award Investigator Count - PI
  • Award Investigator Count - Total

All dimensions not listed below


Key Fields to View:

  • UCSD Award Number - Base
  • Award OP Reporting Date = the date of processing in Kuali

Key Fields Filter on:

  • Award Version Status
  • Legacy Tier Indicator
  • Legacy Pending Transaction