RAH-Award-View Quick Start Guide

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.

Level

Key (uniqueness / group by)

Attributes

1

UCSD 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