Other packages > Find by keyword >

rolap  

Obtaining Star Databases from Flat Tables
View on CRAN: Click here


Download and install rolap package within the R console
Install from CRAN:
install.packages("rolap")

Install from Github:
library("remotes")
install_github("cran/rolap")

Install by package version:
library("remotes")
install_version("rolap", "2.5.2")



Attach the package and use:
library("rolap")
Maintained by
Jose Samos
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2023-08-08
Latest Update: 2025-05-22
Description:
Data in multidimensional systems is obtained from operational systems and is transformed to adapt it to the new structure. Frequently, the operations to be performed aim to transform a flat table into a ROLAP (Relational On-Line Analytical Processing) star database. The main objective of the package is to allow the definition of these transformations easily. The implementation of the multidimensional database obtained can be exported to work with multidimensional analysis tools on spreadsheets or relational databases.
How to cite:
Jose Samos (2023). rolap: Obtaining Star Databases from Flat Tables. R package version 2.5.2, https://cran.r-project.org/web/packages/rolap. Accessed 09 Oct. 2026.
Previous versions and publish date:
(2026-07-09 06:52), 2.0.0 (2023-08-08 16:40), 2.1.0 (2023-08-13 23:00), 2.2.0 (2023-09-15 09:50), 2.3.0 (2023-10-16 14:30), 2.4.0 (2023-11-14 10:50), 2.5.0 (2023-12-11 09:40), 2.5.1 (2024-01-10 11:30)
Other packages that cited rolap R package
View rolap citation profile
Other R packages that rolap depends, imports, suggests or enhances
Complete documentation for rolap
Functions, R codes and Examples using the rolap R package
Some associated functions: add_custom_column . add_dimension_instances . add_dput_column . add_operation . add_surrogate_key.dimension_table . apply_filter_dimension . apply_select_dimension . apply_select_fact . as_GeoPackage . as_csv_files . as_dm_class . as_geolayer . as_multistar . as_rdb . as_single_tibble_list . as_star_database . as_tibble_list . as_xlsx_file . cancel_deployment . check_geoattribute_geometry . check_lookup_table . check_refesh . conform_dimensions . constellation . coordinates_to_point . default_disconnect . define_dimension . define_facts . define_geoattribute . define_geoattribute_from_layer . delete_all_operations_found . delete_operation . delete_operation_set . deploy . dimension_schema . dimension_table . draw_tables . fact_schema . fact_table . filter_dimension . filter_geo_attributes . filter_geo_dimensions . filter_rpd_dimensions . flat_table . ft . ft_age . ft_age_rpd . ft_cause_rpd . ft_num . generate_refresh_sql . generate_table_sql_delete . generate_table_sql_insert . generate_table_sql_update . get_agg_functions.fact_schema . get_all_dimension_operations . get_attribute_names . get_attribute_names_schema.dimension_schema . get_attribute_names_schema.star_schema . get_default_unknown_value . get_deployment_names . get_dimension_names . get_dimension_table . get_existing_fact_instances . get_fact_name.fact_schema . get_fact_names . get_geoattribute_geometries . get_geoattribute_name . get_geoattributes . get_layer . get_layer_from_attribute . get_layer_geometry . get_lookup_tables . get_measure_names . get_measure_names_schema.fact_schema . get_measure_names_schema.star_schema . get_new_dimension_instances . get_next_operation . get_nrow_agg.fact_schema . get_pk_attribute_names . get_point_geometry . get_role_playing_dimension_names . get_rpd_dimensions . get_similar_attribute_values . get_similar_attribute_values_individually . get_similar_values_table . get_star_database . get_star_query_schema . get_star_schema . get_surrogate_key.dimension_table . get_table . get_table_names . get_transformation_code . get_transformation_file . get_unique_attribute_values . get_unique_values_table . get_unknown_value_defined . get_unknown_values . get_variable_description . get_variables . group_by_keys . group_dimension_instances . group_facts . incremental_refresh . integrate_geo_dimensions . interpret_operation_add_custom_column . interpret_operation_flat_table . interpret_operation_group_dimension_instances . interpret_operation_join_lookup_table . interpret_operation_lookup_table . interpret_operation_remove_instances_without_measures . interpret_operation_replace_attribute_values . interpret_operation_replace_empty_values . interpret_operation_replace_string . interpret_operation_replace_unknown_values . interpret_operation_role_playing_dimension . interpret_operation_select_attributes . interpret_operation_select_instances . interpret_operation_select_instances_by_comparison . interpret_operation_select_measures . interpret_operation_separate_measures . interpret_operation_set_attribute_names . interpret_operation_set_measure_names . interpret_operation_snake_case . interpret_operation_star_database . interpret_operation_transform_attribute_format . interpret_operation_transform_from_values . interpret_operation_transform_to_attribute . interpret_operation_transform_to_measure . interpret_operation_transform_to_values . is_empty_string . is_new_operation . is_scd . join_lookup_table . line_last_op . load_star_database . lookup_table . mrs_age_schema . mrs_age_schema_rpd . mrs_cause_schema . mrs_cause_schema_rpd . mrs_db . mrs_db_geo . mrs_ft . mrs_ft_new . multiple_value_key . name_with_nexus . new_multistar . prepare_to_join . purge_dimension . purge_dimension_instances . purge_dimension_instances_star_database . read_flat_table_file . read_flat_table_folder . reformat_file . refresh_deployments . remove_all_measures_na . remove_duplicate_dimension_rows . remove_instances_without_measures . replace_attribute_values . replace_empty_values . replace_empty_values_table . replace_names . replace_string . replace_unknown_values . role_playing_dimension . rpd_in_constellation . run_query . same_granularity_facts . select_attributes . select_dimension . select_fact . select_instances . select_instances_by_comparison . select_measures . separate_measures . set_attribute_names . set_layer . set_measure_names . set_variables . share_dimension_instance_operations . share_dimensions . simplify_rpd_dimensions . snake_case . snake_case_table.dimension_table . snake_case_table.fact_table . star_database . star_database_with_previous_operations . star_operation . star_query . star_schema . string_or_null . string_to_vector . summarize_layer . transform_attribute_format . transform_from_values . transform_names . transform_to_attribute . transform_to_measure . transform_to_values . unify_facts_and_dimensions . unify_rpd . update_according_to . us_census_state . us_layer_state . validate_attributes . validate_dimension_attributes . validate_dimension_names . validate_facts . validate_lookup_parameters . validate_measures . validate_names . vector_presentation . vector_to_string . 
Some associated R codes: common.R . constellation.R . data.R . deploy.R . flat_table.R . flat_table_join.R . flat_table_read.R . flat_table_transform.R . generic.R . geoattribute.R . geolayer.R . operations.R . refresh.R . role_playing.R . schemas.R . star_database.R . star_database_export.R . star_query.R . table.R . tables_fact_dimension.R . update_according_to.R . utils.R .  Full rolap package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

binovisualfields  
Depth-Dependent Binocular Visual Fields Simulation
Simulation and visualization depth-dependent integrated visual fields. Visual fields are measured mo ...
Download / Learn more Package Citations See dependency  
TRMF  
Temporally Regularized Matrix Factorization
Functions to estimate temporally regularized matrix factorizations (TRMF) for forecasting and imputi ...
Download / Learn more Package Citations See dependency  
baffle  
Make Waffle Plots with Base Graphics
Waffle plots are rectangular pie charts that represent a quantity or abundances using colored squar ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
githubinstall  
A Helpful Way to Install R Packages Hosted on GitHub
Provides an helpful way to install packages hosted on GitHub. ...
Download / Learn more Package Citations See dependency  
separationplot  
Separation Plots
Visual representations of model fit or predictive success in the form of "separation plots." See Gr ...
Download / Learn more Package Citations See dependency  

28,989

R Packages

247,686

Dependencies

76,495

Author Associations

28,990

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA