Open Stiivi opened 8 years ago
I believe the fix should happen at https://github.com/DataBrewery/cubes-mongo/blob/master/cubes-mongo/browser.py#L406
Instead of
escape_level(agg.ref())
you want
escape_level(agg.measure.ref())
I can't make these changes myself and test; I have too much other work to do at the moment.
Thanks @robin900. I added the change. Requires testing. CC: @miraculixx
"unicode type has no attribute ref" I got this error when updated the statement to agg.measure.ref()
Moved from Databrewery/cubes#336 by @miraculixx
Based on the tutorial I converted the tutorial dataset to MongoDB, using the cube with the mongo backend. After fixing the mongo backend it almost works, except that the MongoBrowser creates a pipeline that returns wrong results:
As you can see the amount_sum fields are 0, which is wrong. Looking at the pipeline generated reveals why:
when the two problems are fixed manually and the aggregation directly run against mongodb the results are correct:
The problem probably occurs within the mapping code. Any hints?
Data ready to import into mongodb: https://gist.github.com/miraculixx/5ffc89241478e8b09883 MongoDB: 3.2 cubes: release-1.0.1 with fix for mongodb applied as per above