Commit Graph

186 Commits

Author SHA1 Message Date
Benjamin Dauvergne 5473870dc2 visualisation: return 0.0 for None measures in json_data (#38913) 2020-01-15 23:42:20 +01:00
Benjamin Dauvergne 5b72a4be6d engine: force join to right when looking for members (#38913) 2020-01-15 23:42:20 +01:00
Valentin Deniaud ebb9cb3e39 visualization: add warehouse slug support (#38596) 2020-01-15 15:27:32 +01:00
Valentin Deniaud 9004d49fb7 schemas: remove duplicate key (#38596) 2020-01-15 15:27:32 +01:00
Valentin Deniaud d305de24fe hobo: give cubes a slug (#38596)
This also reverts commit 3e956befb4,
which was buggy since new is file scoped and cubes_slug config-section
scoped.
2020-01-15 15:27:32 +01:00
Benjamin Dauvergne 126ddfa812 engine: add missing parenthesis around ->> operator (#38932) 2020-01-14 10:52:57 +01:00
Benjamin Dauvergne 16b60621d4 engine: remove use of cross join (#38691)
It prevented reporting of NULL values.
2020-01-06 22:07:37 +01:00
Benjamin Dauvergne 8f204362a4 engine: simplifiy equivalent code (#38691)
The two branches built the same string.
2020-01-06 22:07:36 +01:00
Frédéric Péters dbe3ff07e3 translation update 2019-12-30 14:31:59 +01:00
Serghei Mihai 74a41d13ac utils: handle proxy objects in ods export (#38641) 2019-12-19 15:00:57 +01:00
Valentin Deniaud 6d790559a4 views: add pagination to visualizations list (#27410) 2019-12-17 10:18:03 +01:00
Benjamin Dauvergne 79a965f328 engine: add setting for postgresql init statements (#38462) 2019-12-12 15:41:53 +01:00
Valentin Deniaud 4f9c50badd visualization: use correct Visualization object (#38356) 2019-12-10 16:48:52 +01:00
Benjamin Dauvergne 980cb76aae settings: improve tests runtime by turning DEBUG off (#38067) 2019-12-04 19:30:58 +01:00
Benjamin Dauvergne 10b4405fd1 engine: propagate filters to dimension's members enumeration (#38067) 2019-12-04 19:30:42 +01:00
Benjamin Dauvergne 72e8d4c83e overhaul of query to table transformation (#38067)
* during query obtain dimension id and label if a different projection
is defined
* use object to materialize query results : Cells, DimensionCell,
MeasureCell
* handle stringification in the *Cell classes
* never ignore NULL dimension's values (it's detected in
Visualization.data() and added to the list of dimension members)
* sum of columns is only computed if there are more than one column
* sum of rows is only computed if there are more than one row
* full sum is only computed if there are more thant one column and more
than one row
* 1 dimension table are computed in the same maner as 2 dimensions
tables, no more discrepancies
* JSON web-service now use the same base methods table_2d() and table_1d()
as the native rendering in bijoe
* EngineDimension.members is specialized for bool dimensions (as it's
always True/False)
2019-12-03 21:04:01 +01:00
Benjamin Dauvergne 6402c7ea99 visualization/utils: remove dead import (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne e8e1d573c5 schemas: add an absent_label property to Dimension (#38067)
Also force lazy strings to unicode in to_json().
2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 2422edd733 engine: use LEFT OUTER JOIN to join with inline json join table (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne d603f14860 engine: hide NULL values of json dimensions in inline join table (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 4701568437 engine: cache proxy descriptor result on engine's cubes (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 3f7bedf0d3 engine: do not hardcode cube's json field name (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne a868f11d42 engine: cache EngineDimension.members (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 33a8eabdba utils: cache get_warehouses() result based on schema files paths (#38067) 2019-12-03 16:53:25 +01:00
Frédéric Péters 833449e236 api: export measure type (#37935) 2019-11-29 11:59:07 +01:00
Valentin Deniaud 6553db03ed visualization: share warehouses between visualizations (#37913) 2019-11-25 15:06:20 +01:00
Valentin Deniaud 90a5bb49c4 Revert "utils: cache warehouses (#27412)"
This reverts commit ba2c0c4fab.
2019-11-25 15:06:20 +01:00
Frédéric Péters 039e32fb83 misc: move loop after drilldown parameters (#16019) 2019-11-23 17:55:23 +01:00
Valentin Deniaud 5d68c543b8 translation update 2019-11-21 14:46:49 +01:00
Valentin Deniaud 370a8e73e3 templates: allow deleting visualization from listing (#27412) 2019-11-21 11:56:15 +01:00
Valentin Deniaud a0caedde62 views: grey out unavailable visualizations (#27412) 2019-11-21 11:56:14 +01:00
Valentin Deniaud ba2c0c4fab utils: cache warehouses (#27412)
Disk reads take a long long time.
2019-11-21 11:54:21 +01:00
Valentin Deniaud 7a5373c91e utils: get tenant from import rather than request (#27412) 2019-11-21 11:53:27 +01:00
Benjamin Dauvergne 6716a7594f engine: quote join's aliases (#37495) 2019-11-07 19:20:41 +01:00
Benjamin Dauvergne 09c52ca6c3 views: export duration as numbers in JSON API (#36770) 2019-10-13 22:44:29 +02:00
Benjamin Dauvergne 690ea992d1 schema: add Cube.warnings support (#36576) 2019-10-01 13:35:46 +02:00
Benjamin Dauvergne 29932ac31c remove all explicit quoting (#36488)
The schemas must contain quoted names for fields and tables when
necessary.
2019-09-28 11:03:37 +02:00
Benjamin Dauvergne f92ae54d47 engine: remove duplicated line (#36488) 2019-09-28 02:56:24 +02:00
Frédéric Péters 6618a50ef7 misc: adapt "display as PNG" to find canvas in new HTML tags (#36006) 2019-09-11 11:39:58 +02:00
Frédéric Péters 3c0e2bab16 misc: don't add a js datepicker on top of HTML5 date inputs (#35997) 2019-09-11 11:35:24 +02:00
Frédéric Péters 789d2d2d9b misc: force labels to be text for json view (#35885) 2019-09-06 15:40:20 +02:00
Frédéric Péters 9fbda03caf misc: require authentication to download ods (#35447) 2019-08-19 14:39:03 +02:00
Frédéric Péters b3839357a7 api: use empty strings for None labels (#35448) 2019-08-19 14:39:03 +02:00
Frédéric Péters eacd1a51f5 misc: account for slug default max length of 50 characters (#30855) 2019-08-13 08:16:27 +02:00
Benjamin Dauvergne c289591dd3 visualization: keep None value for dimension cells (#35295) 2019-08-12 20:18:19 +02:00
Benjamin Dauvergne 80332cfc1b schemas: handle case of an unique IS NULL filter (#32476) 2019-08-12 20:18:19 +02:00
Benjamin Dauvergne ace7a3407b engine: conserve table name case in SQL queries (#35130) 2019-08-12 20:18:19 +02:00
Frédéric Péters c196221f4b misc: add slugs to visualizations (#30855) 2019-08-12 20:15:23 +02:00
Frédéric Péters 7ea6b54588 hobo deploy: don't skip secondary services that were declared (#33821) 2019-06-18 09:11:43 +02:00
Benjamin Dauvergne ac35b22162 templates: don't use gadjo popup for ODS links (#33035) 2019-05-13 11:12:22 +02:00