The aggregation tag has no wiki summary.
0
votes
0answers
26 views
How do I define a Standard Deviation function in Pentaho Schema Workbench
I'm building an OLAP Analysis with Pentaho's BI Suite (Community Edition). Many of my measures are standard deviations of the variables in my fact tables.
Does someone has a tip on how to define a ...
1
vote
1answer
32 views
I have multiple sources INSERTing into a MySQL innodb table. My periodic aggregation script never makes accurate aggregates. Why?
I apologize in advance if this is a repeat. I'm not really sure how to properly ask for what I'm running into.
I have a large InnoDB table set up. I have 3 sources that all INSERT concurrently at a ...
0
votes
0answers
36 views
MongoDB: Aggregation workaround by helper collection
Since I regularly run against mongodb's document size limit and also aggregation framework's group limitations >16M, depending on the amount of data I need to process, I look for a simple workaround.
...
0
votes
0answers
62 views
MongoDB: group and document size limitation with aggregation and MapReduce
Hitting the limitations of MongoDB (in a single machine environment), I wonder which part of MapReduce and aggregation with group/$group is causing the troubles.
Usually I use a mix of MR/Aggregation ...
2
votes
1answer
264 views
Performing aggregations and calculations: SQL (CTE) vs MDX
I’ve hit a wall and would like some expert advice.
I’m building a data warehouse and don’t quite understand whether the calculations (also time aggregations) should be done in SQL (T-SQL and CTE) or ...
1
vote
4answers
1k views
Should I use the Infobright database or is there a better aggregation solution?
We are a MySQL front-end shop and have a system currently logging event data in a highly structured format. Think apache traffic log.
We need to be able to aggregate counts of this data (cube) vis a ...
