View source: R/multistar_relate_dimension.R
relate_dimension | R Documentation |
multistar
Adding a dimension to a multistar
can only relate to a fact table. You can
then relate to other fact tables in the multistar
using this function. The
name of the fact table and its foreign key must be indicated. The referential
integrity of the instances of the facts is checked.
relate_dimension(ms, dimension_name = NULL, fact_name = NULL, fact_key = NULL)
## S3 method for class 'multistar'
relate_dimension(ms, dimension_name = NULL, fact_name = NULL, fact_key = NULL)
ms |
A |
dimension_name |
A string, name of dimension table. |
fact_name |
A string, name of fact table. |
fact_key |
A string, name of the dimension foreign key. |
A multistar
.
Other multistar functions:
add_dimension()
,
add_facts()
,
multistar()
ms <- multistar() |>
add_facts(
fact_name = "mrs_age",
fact_table = mrs_fact_age,
measures = "n_deaths",
nrow_agg = "count"
) |>
add_facts(
fact_name = "mrs_cause",
fact_table = mrs_fact_cause,
measures = c("pneumonia_and_influenza_deaths", "other_deaths"),
nrow_agg = "nrow_agg"
) |>
add_dimension(
dimension_name = "where",
dimension_table = mrs_where,
dimension_key = "where_pk",
fact_name = "mrs_age",
fact_key = "where_fk"
) |>
add_dimension(
dimension_name = "when",
dimension_table = mrs_when,
dimension_key = "when_pk",
fact_name = "mrs_age",
fact_key = "when_fk",
key_as_data = TRUE
) |>
add_dimension(
dimension_name = "who",
dimension_table = mrs_who,
dimension_key = "who_pk",
fact_name = "mrs_age",
fact_key = "who_fk"
) |>
relate_dimension(dimension_name = "where",
fact_name = "mrs_cause",
fact_key = "where_fk") |>
relate_dimension(dimension_name = "when",
fact_name = "mrs_cause",
fact_key = "when_fk")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.