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.1")



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: 2024-01-10
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.1, https://cran.r-project.org/web/packages/rolap. Accessed 21 Dec. 2024.
Previous versions and publish date:
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)
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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

helda  
Preprocess Data and Get Better Insights from Machine Learning Models
The main focus is on preprocessing and data visualization of machine learning models performances.So ...
Download / Learn more Package Citations See dependency  
CIFsmry  
Weighted summary of cumulative incidence functions
Estimate of cumulative incidence function in two samples. Provide weighted summary statistics based ...
Download / Learn more Package Citations See dependency  
batteryreduction  
An R Package for Data Reduction by Battery Reduction
Battery reduction is a method used in data reduction. It uses Gram-Schmidt orthogonal rotations to f ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
condGEE  
Parameter Estimation in Conditional GEE for Recurrent Event Gap Times
Solves for the mean parameters, the variance parameter, and their asymptotic variance in a condition ...
Download / Learn more Package Citations See dependency  
SEIRfansy  
Extended Susceptible-Exposed-Infected-Recovery Model
Extended Susceptible-Exposed-Infected-Recovery Model for handling high false negative rate and symp ...
Download / Learn more Package Citations See dependency  

23,394

R Packages

201,798

Dependencies

63,416

Author Associations

23,395

Publication Badges

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