Definition of schemas for facts and dimensions for the Mortality Reporting System considering the cause classification.
Details
Dimension schemes can be defined using variables so that you do not have to repeat the definition in several multidimensional designs.
See also
Other mrs example schema:
mrs_age_schema_rpd
,
mrs_age_schema
,
mrs_cause_schema_rpd
Examples
# Defined by:
when <- dimension_schema(name = "When",
attributes = c("Year"))
where <- dimension_schema(name = "Where",
attributes = c("REGION",
"State",
"City"))
mrs_cause_schema <- star_schema() |>
define_facts(name = "MRS Cause",
measures = c("Pneumonia and Influenza Deaths",
"All Deaths")) |>
define_dimension(when) |>
define_dimension(where)