The Spreadsheet add-on uses the dimension names to connect the data from your spreadsheet to the data in your cloud. Defining a range of rows and columns in your spreadsheet tells Cube which dimensions to use when fetching and publishing data.
There are three ways to build a range in the Spreadsheet add-on:
- Select to register a range when dimension names are already in rows and columns
- New range from scratch by telling the Spreadsheet add-on which dimensions to insert into the spreadsheet
- Open pre-existing reports or templates
Try out the range building experience below!
Select existing dimensions
This option is best for defining a range in pre-formatted spreadsheets.
1. Select the columns and rows with your listed dimensions (dimensions, tags, and formula names exactly how they appear on the Dimensions page of the Web portal to ensure data fetches successfully).
2. Then click Select Range.
3. If successful, you'll receive a confirmation message that your range was set.
If the attempt was unsuccessful, Cube couldn't identify dimensions in the rows and columns selected. There may have been missing dimensions, or the names are listed incorrectly. Use the validate feature in the Spreadsheet add-on to see which dimensions Cube recognizes and which need to be updated.
You can also reference this guide to troubleshoot range selection issues.
4. Click Fetch Data to retrieve data to your range. You'll receive a confirmation message in the Spreadsheet add-on that your fetch was successful.
Walk through steps below:
Define new dimensions
1. Build a range from scratch quickly by clicking + New in the Spreadsheet add-on.
2. Then, drag your dimensions from the dock and drop them into Columns, Rows, or Filters.
3. To write the range and fetch data to your sheet, click Fetch Data.
Walk through the steps below to try out building a new range:
See step-by-step instructions for more details.
Open a template
Use existing templates and reports to push and pull information from Cube into your spreadsheet.
1. Click Open in the Spreadsheet add-on.
2. Choose the template you would like to open.
Learn how to create templates.