RAH-IPDetail-View Quick Start Guide

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

1

IP Proposal Sequence Number

IP Proposal Number + IP Proposal Sequence Number + IP OP Reporting Date

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

Measure:

IP Direct Cost Initial
IP Direct Cost Total
IP Indirect Cost Initial
IP Indirect Cost Total
IP Total Cost
IP Total Cost Initial

All dimensions not listed below

2

Lower Levels

There are multiple groups of fields that live at a lower grain than the Award + Sequence Number. These groups are not part of a hierarchy and should be considered separately.

If you add any field from these groups to your report you will see the Measures that live at a higher grain repeated for each value within these groups. This is expected behavior.

Folders containing these groups of fields include:

IP IDC
IP IDC Multi
IP Investigator
IP Investigator Percent Effort
IP Key Person
IP Key Person Percent Effort
IP Special Review

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