RAH-IP-View Quick Start Guide
- Saparnell
This view contains all of the Institutional Proposal (IP) and associated 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 | |
|---|---|---|---|
The lowest level is one row per associated field value.
Key Fields to View:
- IP Proposal Number
- IP OP Reporting Date = the date of processing in Kuali
Key Fields Filter on:
- IP Proposal Version Status
- IP Status