author_research_measure

`author_research_measure`

SQL table: MASTER.AUTHOR_RESEARCH_MEASURE Fact table of research-measure observations for authors. Each row records the value of a single measure for a single author, for a single capability, in a single period (year) — optionally within a specific research field. Alongside the raw value, each row carries the author’s share, the peer median, rank, and percentile for that measure/capability/period context. Join to author (entity), capability, and measure for descriptive context.

Joins

Name	Relationship
`author`	many_to_one
`capability`	many_to_one
`measure`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Surrogate primary key — concatenation of author_id, capability_id, measure_id, research_field_id, and period.
`author_id`	string		Foreign key to the author cube.
`capability_id`	string		Foreign key to the capability cube.
`measure_id`	string		Foreign key to the measure cube.
`research_field_id`	string		Identifier of the research field the observation is scoped to. Null when not field-specific.
`period`	number		The year the observation covers.

Measures

Name	Type	Description
`count`	count	Number of observation rows matching the current filter context.
`total_value`	sum	Sum of the observation value. Only meaningful within a single measure.
`avg_value`	avg	Average observation value across the selected rows.
`value`	max	The observation value for a single row.
`avg_share`	avg	Average share across the selected rows.
`share`	max	The author’s share for a single observation row.
`median`	max	Peer median value for the observation’s measure/capability/period context.
`best_rank`	min	Best (lowest) rank among the selected rows.
`rank`	max	The author’s rank for a single observation row.
`percentile`	max	The author’s percentile for a single observation row (higher is better).

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

author_research_measure

`author_research_measure`

Joins

Dimensions

Measures

​author_research_measure

​Joins

​Dimensions

​Measures

`author_research_measure`

Joins

Dimensions

Measures