Data published from your spreadsheet into Cube and data imported into Cube from your source systems (via flat file or direct integration) can be pulled into your spreadsheet anytime using the Fetch Data button in the Spreadsheet App.
Whether creating an ad-hoc report or reviewing a budget, fetching data into your spreadsheet couldn't be easier.
1. Make sure your data is up to date
Before fetching data, you'll want to ensure the data in Cube is up-to-date. You can check this in your Cube Workspace under Source Data. Click the three dots menu next to your source system and then Import history:
If it's been a while, click the import icon to run another import for each source system. Import time will vary depending on the amount of data being re-synced, especially when running multiple imports; you'll receive an email invitation when it's complete and ready to start fetching to your spreadsheet.
2. Define your range(s)
A range is the designated rows and columns in your spreadsheet that tell Cube what data you'd like to see and how you'd like to see it using the names of your dimensions, tags, formulas, and attributes:
You can select a range on a report, create a new range, or open an existing template. For help building ranges, see our guide.
3. Click Fetch Data
When all your columns, rows, and filters have been captured in your Spreadsheet add-on, you're ready to hit Fetch Data.
Want to automatically exclude rows without values from your fetch? Toggle the option to Exclude zero rows before fetching.
When you click Fetch Data, your spreadsheet will populate with your Cube data.
Fetch to multiple ranges
Consider adding multiple ranges to your sheet to support fetching and publishing to different areas or pulling multiple data sets into visualizations.
Select multiple ranges to fetch to all of them at the same time.
Want more? Check out this best practices guide for fetching to ensure you're getting the most out of using Cube!