Obtaining Star Databases from Flat Tables


[Up] [Top]

Documentation for package ‘rolap’ version 2.3.0

Help Pages

A C D F G I J L M R S T U

-- 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