CRAN/E | rolap

rolap

Obtaining Star Databases from Flat Tables

Installation

About

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.

josesamos.github.io/rolap/
github.com/josesamos/rolap
Bug report File report

Key Metrics

Version 2.5.1
R ≥ 2.10
Published 2024-01-10 270 days ago
Needs compilation? no
License MIT
License File
CRAN checks rolap results
Language en-GB

Downloads

Yesterday 7 0%
Last 7 days 48 -26%
Last 30 days 245 -76%
Last 90 days 3.679 -81%
Last 365 days 126.499 +23633%

Maintainer

Maintainer

Jose Samos

Authors

Jose Samos

aut / cre

Universidad de Granada

cph

Material

README
NEWS
Reference manual
Package source

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)

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

rolap archive

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

Reverse Imports

geogenr