You can configure 'live' connection to your Mongo database and use it as a data source for pivot table (chart, flat table) reports. In this case data is not imported: SeekTable uses Mongo aggregate pipeline query (GROUP BY) to retrieve the necessary data for the report.
There are no any limitations on the dataset size, but your MongoDb should be able to execute aggregate queries fast enough (in seconds). If you have really huge collections that cannot be aggregated in the real-time you can apply database-level filtering (with help of "Parameters") or use pre-aggregated collections.
mongodb://user:password@host:port/database[?options]
?connect=replicaSet
If everything is fine you should see a new cube dashboard with the list of available dimensions. In case of connection error you'll see an orange box with the error message.
Field
: dimension value is a document field or result of $project specification (can be provided as first "Parameter").Expression
: dimension is defined as calculated field with custom formula that uses another dimensions as arguments (formula and arguments should be specified in "Parameters").
Field
this is document or sub-document field specifier.${0:0.##}
→ $10.25{0:yyyy-MM-dd}
→ 2017-05-25Field
: you can specify custom $project specification. For example: {$year:"$create_date"}
(extracts year value from "create_date" field).
Expression
: you can specify custom formula (1-st parameter) and dimension names for the arguments (2-nd, 3-rd etc parameter).
Count
: the number of aggregated documents.Sum
: the total sum of a numeric field.Average
: the average value of a numeric field.Min
: the minimal value of a column.Max
: the maximum value of a column.FirstValue
: custom acummulator aggregation pipeline expression.Expression
: measure defined as calculated field.${0:0.##}
→ $10.25Count
: no parameters needed.Sum
/Average
/Min
/Max
: document field or field path to aggregate.FirstValue
: collects field value of the first document.Expression
: first parameter is formula expression, and next parameters are names of measures used as arguments in the expression.