Man pages for rolap
Obtaining Star Databases from Flat Tables
| add_custom_column | Add custom column |
| add_dimension_instances | Add dimension instances |
| add_dput_column | For each row, add a vector of values |
| add_operation | A 'star_operation' object row is added with a new operation |
| add_surrogate_key.dimension_table | Add the surrogate key from a dimension table to the instances... |
| apply_filter_dimension | Apply filter dimension |
| apply_select_dimension | Apply select dimension |
| apply_select_fact | Apply select fact |
| as_csv_files | Generate csv files with fact and dimension tables |
| as_dm_class | Generate a 'dm' class with fact and dimension tables |
| as_geolayer | Get a 'geolayer' object |
| as_GeoPackage | Save as 'GeoPackage' |
| as_multistar | Generate a 'geomultistar::multistar' object |
| as_rdb | Generate tables in a relational database |
| as_single_tibble_list | Generate a list of tibbles of flat tables |
| as_star_database | Get a star database from a flat table |
| as_tibble_list | Generate a list of tibbles with fact and dimension tables |
| as_xlsx_file | Generate a xlsx file with fact and dimension tables |
| cancel_deployment | Cancel deployment |
| check_geoattribute_geometry | Check a 'geoattribute' geometry instances. |
| check_lookup_table | Check the result of joining a flat table with a lookup table |
| check_refesh | Checks the refresh of the selected star database from the... |
| conform_dimensions | Conform dimensions |
| constellation | Create constellation |
| coordinates_to_point | Transform coordinates to point geometry |
| default_disconnect | Default disconnect function |
| define_dimension | Define dimension in a 'star_schema' object. |
| define_facts | Define facts in a 'star_schema' object. |
| define_geoattribute | Define 'geoattribute' of a dimension |
| define_geoattribute_from_layer | Define geoattribute from a layer |
| delete_all_operations_found | Delete in stars all operations found |
| delete_operation | Delete an operation |
| delete_operation_set | Delete a set of operations |
| deploy | Deploy a star database in a relational database |
| dimension_schema | 'dimension_schema' S3 class |
| dimension_table | 'dimension_table' S3 class |
| draw_tables | Draw tables |
| fact_schema | 'fact_schema' S3 class |
| fact_table | 'fact_table' S3 class |
| filter_dimension | Filter dimension |
| filter_geo_attributes | From attributes, leave only these contained in dimensions |
| filter_geo_dimensions | From geodimensions, leave only contained in vector of names |
| filter_rpd_dimensions | From rpd dimensions, leave only contained in vector of names. |
| 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 |
| generate_refresh_sql | Generate refresh sql |
| generate_table_sql_delete | Generate table sql delete |
| generate_table_sql_insert | Generate table sql insert |
| generate_table_sql_update | Generate table sql update |
| get_agg_functions.fact_schema | Get aggregate functions |
| get_all_dimension_operations | Gets the operations performed on a dimension in all... |
| get_attribute_names | Get the names of the attributes |
| get_attribute_names_schema.dimension_schema | Get attribute names |
| get_attribute_names_schema.star_schema | Get attribute names |
| get_default_unknown_value | get default unknown value |
| get_deployment_names | Get the names of the facts of a star database |
| get_dimension_names | Get the names of the dimensions of a star database |
| get_dimension_table | Get dimension table |
| get_existing_fact_instances | Get existing fact instances |
| get_fact_name.fact_schema | Get fact name |
| get_fact_names | Get the names of the facts of a star database |
| get_geoattribute_geometries | Get geoattribute geometries |
| get_geoattribute_name | Get geoattribute name |
| get_geoattributes | Get geoattributes |
| get_layer | Get geographic information layer |
| get_layer_from_attribute | Get layer from attribute |
| get_layer_geometry | Get layer geometry |
| get_lookup_tables | Get lookup tables |
| get_measure_names | Get the names of the measures |
| get_measure_names_schema.fact_schema | Get measure names |
| get_measure_names_schema.star_schema | Get measure names |
| get_new_dimension_instances | Get new dimension instances |
| get_next_operation | A 'star_operation' object row is returned, the one following... |
| get_nrow_agg.fact_schema | Get number of rows aggregate column |
| get_pk_attribute_names | Get the names of the primary key attributes of a flat table |
| get_point_geometry | Get point geometry |
| get_role_playing_dimension_names | Get the names of the role playing dimensions |
| get_rpd_dimensions | Get rpd dimensions of a dimension |
| get_similar_attribute_values | Get similar attribute values combination |
| get_similar_attribute_values_individually | Get similar values for individual attributes |
| get_similar_values_table | Get similar values in a table |
| get_star_database | Get star database |
| get_star_query_schema | Get star query schema |
| get_star_schema | Get star schema |
| get_surrogate_key.dimension_table | Get surrogate key names |
| get_table | Get the table of the flat table |
| get_table_names | Get the names of the tables of a star database |
| get_transformation_code | Get transformation function code |
| get_transformation_file | Get transformation function file |
| get_unique_attribute_values | Get unique attribute values |
| get_unique_values_table | Get unique values in a table |
| get_unknown_value_defined | Get the unknown value defined |
| get_unknown_values | Get unknown attribute values |
| get_variable_description | Get variable description |
| get_variables | Get the variables layer |
| group_by_keys | Group table instances by keys aggregating the measures using... |
| group_dimension_instances | Group instances of a dimension |
| group_facts | Group facts |
| incremental_refresh | Refresh a star database in a constellation |
| integrate_geo_dimensions | Integrate two geodimensions |
| interpret_operation_add_custom_column | Interpret operation |
| interpret_operation_flat_table | Interpret operation |
| interpret_operation_group_dimension_instances | Interpret operation |
| interpret_operation_join_lookup_table | Interpret operation |
| interpret_operation_lookup_table | Interpret operation |
| interpret_operation_remove_instances_without_measures | Interpret operation |
| interpret_operation_replace_attribute_values | Interpret operation |
| interpret_operation_replace_empty_values | Interpret operation |
| interpret_operation_replace_string | Interpret operation |
| interpret_operation_replace_unknown_values | Interpret operation |
| interpret_operation_role_playing_dimension | Interpret operation |
| interpret_operation_select_attributes | Interpret operation |
| interpret_operation_select_instances | Interpret operation |
| interpret_operation_select_instances_by_comparison | Interpret operation |
| interpret_operation_select_measures | Interpret operation |
| interpret_operation_separate_measures | Interpret operation |
| interpret_operation_set_attribute_names | Interpret operation |
| interpret_operation_set_measure_names | Interpret operation |
| interpret_operation_snake_case | Interpret operation |
| interpret_operation_star_database | Interpret operation |
| interpret_operation_transform_attribute_format | Interpret operation |
| interpret_operation_transform_from_values | Interpret operation |
| interpret_operation_transform_to_attribute | Interpret operation |
| interpret_operation_transform_to_measure | Interpret operation |
| interpret_operation_transform_to_values | Interpret operation |
| is_empty_string | check if a string is empty |
| is_new_operation | A 'star_operation' is new? |
| is_scd | Is a scd dimension |
| join_lookup_table | Join a flat table with a lookup table |
| line_last_op | Get line last operation |
| load_star_database | Load star_database (from a RDS file) |
| lookup_table | Transform a flat table into a look up table |
| mrs_age_schema | Star schema for Mortality Reporting System by Age |
| mrs_age_schema_rpd | Star schema for Mortality Reporting System by Age with... |
| mrs_cause_schema | Star schema for Mortality Reporting System by Cause |
| mrs_cause_schema_rpd | Star schema for Mortality Reporting System by Cause with... |
| mrs_db | Constellation generated from MRS file |
| mrs_db_geo | Constellation generated from MRS file through a query and... |
| mrs_ft | Flat table generated from MRS file |
| mrs_ft_new | Flat table generated from MRS file |
| multiple_value_key | Multiple value key |
| name_with_nexus | Name with nexus |
| new_multistar | 'multistar' S3 class |
| prepare_to_join | Prepare the instances table implemented by a 'tibble' to join |
| purge_dimension | Purge instances of a dimension |
| purge_dimension_instances | Purge instances of dimensions |
| purge_dimension_instances_star_database | Purge instances of dimensions |
| read_flat_table_file | Import flat table file |
| read_flat_table_folder | Import all flat table files in a folder |
| reformat_file | Get line last operation |
| refresh_deployments | Refresh deployments |
| remove_all_measures_na | Remove instance if all measures are na |
| remove_duplicate_dimension_rows | Remove duplicate dimension rows |
| remove_instances_without_measures | Remove instances without measures |
| replace_attribute_values | Replace instance values |
| replace_empty_values | Replace empty values with the unknown value |
| replace_empty_values_table | Replace empty values with the unknown value |
| replace_names | Replace names |
| replace_string | Replace strings |
| replace_unknown_values | Replace unknown values with the given value |
| role_playing_dimension | Define a role playing dimension and its associated dimensions |
| rpd_in_constellation | Transform role playing dimensions in constellation |
| run_query | Run query |
| same_granularity_facts | Do all fact tables have the same granularity? |
| select_attributes | Select attributes of a flat table |
| select_dimension | Select dimension |
| select_fact | Select fact |
| select_instances | Select instances of a flat table by value |
| select_instances_by_comparison | Select instances of a flat table by comparison |
| select_measures | Select measures of a flat table |
| separate_measures | Separate measures in flat tables |
| set_attribute_names | Rename attributes |
| set_layer | Set geographic layer |
| set_measure_names | Rename measures |
| set_variables | Set variables layer |
| share_dimension_instance_operations | Share dimension instance operations between all... |
| share_dimensions | Share the given dimensions in the database |
| simplify_rpd_dimensions | From a vector of dimensions, leave only one of each rpd. |
| snake_case | Transform names according to the snake case style |
| snake_case_table.dimension_table | Transform names according to the snake case style |
| snake_case_table.fact_table | Transform names according to the snake case style |
| star_database | 'star_database' S3 class |
| star_database_with_previous_operations | Creates a 'star_database' adding previous operations |
| star_operation | 'star_operation' S3 class |
| star_query | 'star_query' S3 class |
| star_schema | 'star_schema' S3 class |
| string_or_null | Get the representation to output |
| string_to_vector | Transforms string into a vector of strings. |
| summarize_layer | Summarize geometry of a layer |
| transform_attribute_format | Transform attribute format |
| transform_from_values | Transform attribute values into measure names |
| transform_names | For each row, add a vector of values |
| transform_to_attribute | Transform to attribute |
| transform_to_measure | Transform to measure |
| transform_to_values | Transform measure names into attribute values |
| unify_facts_and_dimensions | Unify facts and dimensions in a flat table |
| unify_rpd | Unify lists of dimension names if there are any in common |
| update_according_to | Update a flat table according to another structure |
| us_census_state | Census of US States, by sex and age |
| us_layer_state | Geographic layer of US States |
| validate_attributes | Validate attribute names |
| validate_dimension_attributes | Validate dimension attributes |
| validate_dimension_names | Validate dimension names |
| validate_facts | Validate fact names |
| validate_lookup_parameters | Validate lookup parameters |
| validate_measures | Validate measure names |
| validate_names | Validate names |
| vector_presentation | vector to string for presentation |
| vector_to_string | Transforms a vector of strings into a string. |
