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.5.1
Depends: R (≥ 2.10)
Imports: dm, dplyr, methods, purrr, readr, rlang, sf, snakecase, starschemar, tibble, tidyr, tidyselect, tools, utils, when, xlsx
Suggests: DBI, dbplyr, DiagrammeR, DiagrammeRsvg, knitr, lubridate, magrittr, maps, pander, pivottabler, RMariaDB, rmarkdown, RSQLite, stringr, testthat (≥ 3.0.0)
Published: 2024-01-10
DOI: 10.32614/CRAN.package.rolap
Author: Jose Samos ORCID iD [aut, cre], Universidad de Granada [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
Incremental refresh of star databases
Deployment of star databases with incremental refresh
Star Database Export Features
Performing Multidimensional Queries (also Including Geographic Attributes)


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

Reverse dependencies:

Reverse imports: geogenr


Please use the canonical form to link to this page.