Obtaining Star Databases from Flat Tables
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘rolap’ version 2.3.0
Help Pages
-- A --
| add_custom_column | Add custom column |
| add_custom_column.flat_table | Add custom column |
| as_dm_class | Generate a 'dm' class with fact and dimension tables |
| as_dm_class.star_database | Generate a 'dm' class with fact and dimension tables |
| as_single_tibble_list | Generate a list of tibbles of flat tables |
| as_single_tibble_list.star_database | Generate a list of tibbles of flat tables |
| as_star_database | Get a star database from a flat table |
| as_star_database.flat_table | Get a star database from a flat table |
| as_tibble_list | Generate a list of tibbles with fact and dimension tables |
| as_tibble_list.star_database | Generate a list of tibbles with fact and dimension tables |
-- C --
| check_lookup_table | Check the result of joining a flat table with a lookup table |
| check_lookup_table.flat_table | Check the result of joining a flat table with a lookup table |
| constellation | Create constellation |
-- D --
| db_finest | Czech debit card company specialising on payments at gas stations (finest detail) |
| db_summary | Czech debit card company specialising on payments at gas stations (summary) |
| define_dimension | Define dimension in a 'star_schema' object. |
| define_dimension.star_schema | Define dimension in a 'star_schema' object. |
| define_facts | Define facts in a 'star_schema' object. |
| define_facts.star_schema | Define facts in a 'star_schema' object. |
| dimension_schema | 'dimension_schema' S3 class |
-- F --
| fact_schema | 'fact_schema' S3 class |
| flat_table | 'flat_table' S3 class |
| ft | Mortality Reporting System |
| ft_age | Mortality Reporting System by Age Group |
| ft_age_rpd | Mortality Reporting System by Age |
| ft_cause_rpd | Mortality Reporting System by Cause |
| ft_num | Mortality Reporting System with numerical measures |
-- G --
| get_attribute_names | Get the names of the attributes |
| get_attribute_names.flat_table | Get the names of the attributes |
| get_attribute_names.star_database | Get the names of the attributes |
| get_dimension_names | Get the names of the dimensions of a star database |
| get_dimension_names.star_database | Get the names of the dimensions of a star database |
| get_existing_fact_instances | Get existing fact instances |
| get_existing_fact_instances.star_database_update | Get existing fact instances |
| get_fact_names | Get the names of the facts of a star database |
| get_fact_names.star_database | Get the names of the facts of a star database |
| get_lookup_tables | Get lookup tables |
| get_lookup_tables.star_database_update | Get lookup tables |
| get_measure_names | Get the names of the measures |
| get_measure_names.flat_table | Get the names of the measures |
| get_measure_names.star_database | Get the names of the measures |
| get_new_dimension_instances | Get new dimension instances |
| get_new_dimension_instances.star_database_update | Get new dimension instances |
| get_pk_attribute_names | Get the names of the primary key attributes of a flat table |
| get_pk_attribute_names.flat_table | Get the names of the primary key attributes of a flat table |
| get_role_playing_dimension_names | Get the names of the role playing dimensions |
| get_role_playing_dimension_names.star_database | Get the names of the role playing dimensions |
| get_similar_attribute_values | Get similar attribute values combination |
| get_similar_attribute_values.flat_table | Get similar attribute values combination |
| get_similar_attribute_values.star_database | Get similar attribute values combination |
| get_similar_attribute_values_individually | Get similar values for individual attributes |
| get_similar_attribute_values_individually.flat_table | Get similar values for individual attributes |
| get_similar_attribute_values_individually.star_database | Get similar values for individual attributes |
| get_star_database | Get star database |
| get_star_database.star_database_update | Get star database |
| get_star_schema | Get star schema |
| get_star_schema.star_database_update | Get star schema |
| get_table | Get the table of the flat table |
| get_table.flat_table | Get the table of the flat table |
| get_table_names | Get the names of the tables of a star database |
| get_table_names.star_database | Get the names of the tables of a star database |
| get_transformation_code | Get transformation function code |
| get_transformation_code.star_database_update | Get transformation function code |
| get_transformation_file | Get transformation function file |
| get_transformation_file.star_database_update | Get transformation function file |
| get_unique_attribute_values | Get unique attribute values |
| get_unique_attribute_values.flat_table | Get unique attribute values |
| get_unique_attribute_values.star_database | Get unique attribute values |
| get_unknown_values | Get unknown attribute values |
| get_unknown_values.flat_table | Get unknown attribute values |
| get_unknown_value_defined | Get the unknown value defined |
| get_unknown_value_defined.flat_table | Get the unknown value defined |
| group_dimension_instances | Group instances of a dimension |
| group_dimension_instances.star_database | Group instances of a dimension |
-- I --
| incremental_refresh | Refresh a star database in a constellation |
| incremental_refresh.star_database | Refresh a star database in a constellation |
-- J --
| join_lookup_table | Join a flat table with a lookup table |
| join_lookup_table.flat_table | Join a flat table with a lookup table |
-- L --
| lookup_table | Transform a flat table into a look up table |
| lookup_table.flat_table | Transform a flat table into a look up table |
-- M --
| mrs_age_schema | Star schema for Mortality Reporting System by Age |
| mrs_age_schema_rpd | Star schema for Mortality Reporting System by Age with additional dates |
| mrs_cause_schema | Star schema for Mortality Reporting System by Cause |
| mrs_cause_schema_rpd | Star schema for Mortality Reporting System by Cause with additional dates |
| mrs_db | Constellation generated from MRS file |
| mrs_ft | Flat table generated from MRS file |
| mrs_ft_new | Flat table generated from MRS file |
-- R --
| read_flat_table_file | Import flat table file |
| read_flat_table_folder | Import all flat table files in a folder |
| remove_instances_without_measures | Remove instances without measures |
| remove_instances_without_measures.flat_table | Remove instances without measures |
| replace_attribute_values | Replace instance values |
| replace_attribute_values.flat_table | Replace instance values |
| replace_attribute_values.star_database | Replace instance values |
| replace_empty_values | Replace empty values with the unknown value |
| replace_empty_values.flat_table | Replace empty values with the unknown value |
| replace_string | Replace strings |
| replace_string.flat_table | Replace strings |
| replace_unknown_values | Replace unknown values with the given value |
| replace_unknown_values.flat_table | Replace unknown values with the given value |
| role_playing_dimension | Define a role playing dimension and its associated dimensions |
| role_playing_dimension.star_database | Define a role playing dimension and its associated dimensions |
-- S --
| select_attributes | Select attributes of a flat table |
| select_attributes.flat_table | Select attributes of a flat table |
| select_instances | Select instances of a flat table by value |
| select_instances.flat_table | Select instances of a flat table by value |
| select_instances_by_comparison | Select instances of a flat table by comparison |
| select_instances_by_comparison.flat_table | Select instances of a flat table by comparison |
| select_measures | Select measures of a flat table |
| select_measures.flat_table | Select measures of a flat table |
| separate_measures | Separate measures in flat tables |
| separate_measures.flat_table | Separate measures in flat tables |
| set_attribute_names | Rename attributes |
| set_attribute_names.flat_table | Rename attributes |
| set_attribute_names.star_database | Rename attributes |
| set_measure_names | Rename measures |
| set_measure_names.flat_table | Rename measures |
| set_measure_names.star_database | Rename measures |
| snake_case | Transform names according to the snake case style |
| snake_case.flat_table | Transform names according to the snake case style |
| snake_case.star_database | Transform names according to the snake case style |
| star_database | 'star_database' S3 class |
| star_schema | 'star_schema' S3 class |
-- T --
| transactions_db | Czech debit card company specialising on payments at gas stations (tables) |
| transform_attribute_format | Transform attribute format |
| transform_attribute_format.flat_table | Transform attribute format |
| transform_from_values | Transform attribute values into measure names |
| transform_from_values.flat_table | Transform attribute values into measure names |
| transform_to_attribute | Transform to attribute |
| transform_to_attribute.flat_table | Transform to attribute |
| transform_to_measure | Transform to measure |
| transform_to_measure.flat_table | Transform to measure |
| transform_to_values | Transform measure names into attribute values |
| transform_to_values.flat_table | Transform measure names into attribute values |
-- U --
| update_according_to | Update a flat table according to another structure |
| update_according_to.flat_table | Update a flat table according to another structure |