/
FINAH-Contract-View Quick Start Guide

FINAH-Contract-View Quick Start Guide

Sep 10, 2021

Contract tied to general projects and sponsored projects.

Data Loads:

Data is loaded nightly from oracle.  To see when the data completed being loaded by UCSD into FINAH see this report:  Tableau > Public > AH Data Load Status Report

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.

 

Level

Key (uniqueness / group by)

Attributes

 

Level

Key (uniqueness / group by)

Attributes

1

Contract Code

 Contract Code

Tableau report developers: {FIXED[Contract Code] : MIN([Contract....])}

All fields in Contract Measures beginning with the word “Contract” except "Contract Line".

 

2

Contract Line Number

Contract Code + Contract Line Number

Tableau report developers: {FIXED[Contract Code],[Contract Line Number] : MIN([Contract Line....])}

All fields in Contract Measures beginning with the word "Contract Line".

 

Key Fields:

  • Award Number

  • Contract ID

 

Key Fields to use as filters:

  • Award Number

  • Contract ID

 

Additional Notes: