Empower your spreadsheet experience with the Cube Spreadsheet App. This tool enables you to seamlessly integrate and work with Cube data in Microsoft Excel or Google Sheets. If you're new to the Cube ecosystem, here's what to expect:
- Fetch: Pull the most up-to-date data into your spreadsheet.
- Publish: Push new data to Cube for future analysis or sharing.
To get started, install the Spreadsheet App.
The Spreadsheet App has features that allow you to act efficiently, confidently, and consistently. This article will take a look at each in greater detail:
- Use Build to define the data you wish to interact with using Cube
- Analyze to learn more about your data
- Publish or push your data back to Cube
- Tables to create and open data sets saved to Cube for additional context in your spreadsheets.
- Update Settings to customize your Spreadsheet App configuration to look and behave how you'd like
Build
The Build functionality allows you to set up a Cube data range or slice of your data for your spreadsheet, essentially instructing Cube which data should be fetched or published.
- Select: Are your spreadsheet columns and rows already defined? Use Select to configure a new range quickly.
- New: Working with a blank slate? Use New and our intuitive drag-and-drop range builder to define your data set.
- Open: Open previously saved reports in Cube, pulling them straight from your library.
Analyze
Dive deep into your data with the Analyze feature.
- Drilldown: Explore the intricate details of a specific data cross-section in your spreadsheet by drilling into a cell to open transaction or event data.
- Expand/Collapse: Expand and collapse let you quickly drill into the details you need, while zero-suppression keeps reports clean and focused by showing only data that matters.
- Validate: Ensure your spreadsheet column or rows align with Cube dimensions using validation, preventing potential fetch errors.
Publish
The Publish feature lets you push data back into Cube, ensuring updated data is available for other users or subsequent analyses.
- Publish Data: Introduce fresh data to Cube by updating your defined scenario(s).
- Publish Reports: Save the specified range to Cube for later use or sharing.
- Set attributes: Add a layer of context to your data during publishing by incorporating attributes or other non-Cube-dimensional data right from your spreadsheet.
Tables
Create, manage, and use tables for the numeric and non-numeric data you need to increase flexibility in your planning, reporting, and analysis.
- Create Table from Range: Define a new table from a range in your spreadsheet. Set the permissions and formatting and save to one or more scenarios.
- Open Existing Table: Use to pull your own or a saved table that was shared with you into your spreadsheet.
Settings
Access a range of functionalities straight from the Spreadsheet App's top bar:
- Settings: Open the Cube Workspace, explore the Help Center, provide feedback, adjust your App settings, or view backend Cube processes.
- Mini Audit Trail: Track recent modifications and data fetches in Cube. For an exhaustive record, access the complete audit trail in the Workspace
- Change Cubes: Working with multiple Cubes? Toggle between them as needed.
- Currency: Adjust the currency per your requirements and oversee conversion rates (availability based on plan).