as_dm_class: Generate a 'dm' class with fact and dimension tables

In rolap: Obtaining Star Databases from Flat Tables

Generate a dm class with fact and dimension tables

Description

To port databases to other work environments it is useful to be able to export them as a dm class, as this function does, in this way it can be saved directly in a DBMS.

Usage

as_dm_class(db, pk_facts, fk)

## S3 method for class 'star_database'
as_dm_class(db, pk_facts = TRUE, fk = TRUE)

Arguments

db	A star_database object.
pk_facts	A boolean, include primary key in fact tables.
fk	A boolean, include foreign key in fact tables.

Value

A dm object.

See Also

star_database

Other star database exportation functions: as_csv_files(), as_multistar(), as_rdb(), as_single_tibble_list(), as_tibble_list(), as_xlsx_file(), draw_tables()

Examples

db1 <- star_database(mrs_cause_schema, ft_num) |>
  snake_case()
dm1 <- db1 |>
  as_dm_class()

db2 <- star_database(mrs_age_schema, ft_age) |>
  snake_case()

ct <- constellation("MRS", db1, db2)
dm <- ct |>
  as_dm_class()

rolap documentation built on May 29, 2024, 10:38 a.m.