We built a django app for product warehousing. Increasingly, the requests are for reporting such as knowing the quantity of the SKU by date etc.
I have looked at cubes. I am not sure if it's overkill to have cubes and Django at the same time. I could add new features to the django app but i was wondering if there's a better way to do this than to sprinkle a bunch of update statements in order to do aggregates that are then stored in another datatable in the postgres database.
Currently, the number of reports we are asked to do is 2. It may grow to 8.
SummaryCoalescingFunction("sum", sql.functions.sum), SummaryCoalescingFunction("count_nonempty", sql.functions.count), FactCountFunction("count"), FactCountDistinctFunction("count_distinct"), ValueCoalescingFunction("min", sql.functions.min), ValueCoalescingFunction("max", sql.functions.max), ValueCoalescingFunction("avg", avg), ValueCoalescingFunction("stddev", stddev), ValueCoalescingFunction("variance", variance)
sumto count true values, but I'm not sure whether you can use booleans like that.