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 ugr.es>
BugReports: https://github.com/josesamos/rolap/issues
License: MIT + file LICENSE
URL: https://josesamos.github.io/rolap/, https://github.com/josesamos/rolap
NeedsCompilation: no
Language: en-GB
Materials: README NEWS
CRAN checks: rolap results

Documentation:

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)

Downloads:

Package source: rolap_2.5.1.tar.gz
Windows binaries: r-devel: rolap_2.5.1.zip, r-release: rolap_2.5.1.zip, r-oldrel: rolap_2.5.1.zip
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

Linking:

Please use the canonical form https://CRAN.R-project.org/package=rolap to link to this page.