rolap: Obtaining Star Databases from Flat Tables

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.

Version: 2.2.0
Depends: R (≥ 2.10)
Imports: dm, dplyr, methods, purrr, readr, rlang, snakecase, tibble, tidyr, tidyselect
Suggests: DBI, dbplyr, DiagrammeR, DiagrammeRsvg, knitr, lubridate, maps, pander, RMariaDB, rmarkdown, RSQLite, stringr, testthat (≥ 3.0.0)
Published: 2023-09-15
Author: Jose Samos ORCID iD [aut, cre, cph]
Maintainer: Jose Samos <jsamos at>
License: MIT + file LICENSE
NeedsCompilation: no
Language: en-GB
Materials: README NEWS
CRAN checks: rolap results


Reference manual: rolap.pdf
Vignettes: Basics and getting started with the rolap package
Obtaining and transforming flat tables
Definition of role-playing and role dimensions
Star databases and RDBMS through the dm and rolap packages
Integration of dimension instances


Package source: rolap_2.2.0.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): rolap_2.2.0.tgz, r-oldrel (arm64): rolap_2.2.0.tgz, r-release (x86_64): rolap_2.2.0.tgz, r-oldrel (x86_64): rolap_2.2.0.tgz
Old sources: rolap archive


Please use the canonical form to link to this page.