Skip to main content

measure

SQL table: MASTER.MEASURE Master registry of every measure tracked in Factbase, spanning national statistics (e.g. GDP, population) and research analytics (e.g. paper counts, fractional credit, paper authority). Each row defines one measure; the observation values themselves live in separate fact tables (e.g. author_research_measure, institution_research_measure, nation_research_measure) keyed by measure_id. This is a dimension-only reference cube — join it to those fact tables on measure_id to label, filter, and format observations. Ratio measures (is_ratio = true) are computed from their numerator and denominator measures and should not be summed directly.

Dimensions

Measures