These are chat archives for DataBrewery/cubes

12th
Dec 2015
Charles Flèche
@charlesfleche
Dec 12 2015 20:19
Hi everyone
I need to process crosstabed data:
date trauma_under5 trauma_above5 wound_under5 wound_above5 infection_under5 infection_above5
2015-01-01 1 2 3 4 5 6
2015-01-02 7 8 9 10 11 12
2015-01-03 13 14 15 16 17 18
Charles Flèche
@charlesfleche
Dec 12 2015 20:24
Two values composes an indicator: a name and an age
For example, infection_under5 represents the number of infections for children under 5 years old
I wonder if it's possible within cubes to represent a flatten version of my data :
Charles Flèche
@charlesfleche
Dec 12 2015 20:33
date indicator age value
2015-01-01 trauma under5 1
2015-01-01 trauma above5 2
2015-01-01 wound under5 3
2015-01-01 wound above5 4
2015-01-01 infection under5 5
2015-01-01 infection above5 6
2015-01-02 trauma under5 7
2015-01-02 traume above5 8
2015-01-02 wound under5 9
2015-01-02 wound above5 10
2015-01-02 infection under5 11
2015-01-02 infection above5 12
2015-01-03 trauma under5 13
2015-01-03 trauma above5 14
2015-01-03 wound under5 15
2015-01-03 wound above5 16
2015-01-03 infection under5 17
2015-01-03 infection above5 18
Is flattening crosstab data possible within cubes ? Should I preprocess the data before it hits cubes storage ? Do I have completely wrong and there is a better way to dig into my indicators ?
Many thanks for the help !