Cube offers users a high degree of flexibility in conducting their analysis, making it an advantageous tool for various business intelligence (BI) use cases.
Three approaches within Cube can support these use cases, each varying in the automation level:
Cube Analytics - Dashboards
Cube has a built-in, powerful BI engine with which you can configure and share custom dashboards with stakeholders. Read about Cube Analytics and dashboards to learn more about this capability and determine if it's right for your needs.
If Cube's built-in BI capabilities do not meet your needs, there are other ways of extracting data from Cube for processing in other tools...
Data Exporter
Cube's Data Exporter allows users to export structured data manually. After the desired data is requested, a CSV file will be emailed to the requester.
Then, the exported data can be directly imported into different BI tools, enabling further analysis.
Learn how to export data.
API Drilldown Endpoint
Cube's API includes a /drilldown endpoint, which can retrieve data in a 2D array JSON format that closely resembles the structure of a CSV file. This endpoint powers the drilldown functionality in Cube's add-ons.
By appending ?spreadsheet=true to the API request, users can obtain data suitable for easy ingestion into BI tools. Compared to the Data Exporter approach, this method tends to be more automated, leveraging the capabilities of Cube's API.
It is important to note that Cube's API has a configured timeout for each request. Consequently, attempting to export all data using the drilldown endpoint is unlikely to succeed.