These are chat archives for DataBrewery/cubes

26th
Jul 2017
Christian Ledermann
@cleder
Jul 26 2017 16:54
I try to denormalize my cubes but the denormalize fails
slicer sql denormalize --config=slicer.ini

Error: config should be a ConfigParser instance, but is <class 'str'>
or
slicer sql denormalize slicer.ini

Error: config should be a ConfigParser instance, but is <class 'str'>
Christian Ledermann
@cleder
Jul 26 2017 16:59
slicer serve runs fine
slicer serve slicer.ini
2017-07-26 17:59:16,286 DEBUG Models root set to current directory
2017-07-26 17:59:16,286 DEBUG Workspace calendar timezone: None first week day: 0
2017-07-26 17:59:16,417 DEBUG Registered store 'default'
2017-07-26 17:59:16,417 DEBUG Loading model main
2017-07-26 17:59:16,417 DEBUG Importing model from model.json. Provider: None Store: None NS: None
...
Cubes version 1.1
Michael Schwab
@schwab
Jul 26 2017 19:14
@cleder on Apr 04 I asked the same question about denormalization. If you scroll back far enough on this thread, you can see the interaction I had with @Stiivi about it. His suggestions got me going. In short there is a bug in the denorm stuff and you have to edit the py code to correct for some changes that have been made. In my case I got it working but found the denorm really did almost nothing for the performance. Including better indexes in my sql model was way more effective.
Also, note that de-norm does not pre-aggregate (like the MS Analysis services product does). I had assumed that would be the effect. Instead it flattens out any joins making a single flat table of your data.