Allow exporting of Elasticubes to Excel / CSV
In order to export data from an Elasticube, it is necessary to create a dashboard, add a table widget, individually add each column to the widget, save it, view it, and export it.
It would seem to be a rudimentary and helpful feature to be able to export any cube to Excel or to CSV.
-
Although there is no actual button from the UI to achieve this, you can consider using the SQL API with which you will be able to export to csv format queries from your EC,
For instance:
SELECT *
FROM [table]Or join in other tables to get more complex outputs,
LMK if you have any further questions, feel free to reach out,
Ido
Please sign in to leave a comment.
Comments
2 comments