Questions tagged [data.cube]
5 questions
13
votes
2 answers
Star schema, normalized dimensions, denormalized hierarchy level keys
Given the following star schema tables.
fact, two dimensions, two measures.
# geog_abb time_date amount value
#1: AL 2013-03-26 55.57 9113.3898
#2: CO 2011-06-28 19.25 9846.6468
#3: MI 2012-05-15 94.87 4762.5398
#4: …
jangorecki
- 16,384
- 4
- 79
- 160
3
votes
1 answer
R data cube define hierarchy
I have some problems with the OLapCube package, data.cube:
install.packages("data.cube", repos = paste0("https://", c(
"jangorecki.gitlab.io/data.cube",
"cloud.r-project.org"
)))
Some test data:
library(data.table)
set.seed(42)
dt <-…
Markus Hein
- 63
- 4
2
votes
1 answer
Is it possible to set a cube with a snowflake schema in data.cube R?
Or, can dimensions be, in some way nested, in data.cube?
Given the following example (accessed via ?data.cube on R, having installed last branch of data.cube-oop package, by @jangorecki) for which I post code and image example.
Consider I want to…
MikeMajara
- 922
- 9
- 23
2
votes
1 answer
subsetting data.cube inside custom function
I am trying to make a function of my own to subset a data.cube in R, and format the result automatically for some predefined plots I aim to build.
This is my function.
require(data.table)
require(data.cube)
secciona <- function(cubo = NULL,
…
MikeMajara
- 922
- 9
- 23
0
votes
1 answer
How much RAM (memory) do I save by using an array in R (instead of list, data.frame, data.table)?
What would be the general formula be for describing this savings/ difference?
Items to consider for the calculation:
Number of array dimensions (identifying columns)
The size of each dimension (unique elements in each identifying column)
The…
rbatt
- 4,677
- 4
- 23
- 41