If your range selection is returning an error, this article can help you determine the cause. Errors usually appear when Cube does not recognize dimensions due to the range's structure or formatting issues.
If you've received an error, it'll likely be due to one of the following issues. Read more to get things back on track.
Accounts are not Cube dimensions
An error that says your Accounts are not Cube dimensions typically happens when there are unrecognized or invalid dimensions in your range. Cube can only pull data using dimension names it recognizes (dimension, formula, tags).
If you've added additional rows and columns to keep notes and information that you don't want to be used as dimensions, but are important information to maintain, add these columns/rows as attributes. By adding these columns/rows as attributes, Cube will recognize them as belonging to the sheet but will not pull in any Cube data.
If these additional rows or columns are not needed as attributes, move them outside the range and re-select your range.
Dimensions cannot be in both rows and columns
If you see an error that says a dimension cannot be in both rows and columns, and it cannot be in multiple rows or columns, you'll need to review your report structure. This error arises when dimension members from the same dimensions are in the same row or column.
For example, the range will not register in Cube if the same Department dimension, Marketing, is in a row and column cell.
Data is stored in Cube using dimension intersections (column meets row). The intersection cannot be located accurately if the same dimension is in two places.
To resolve this, reconfigure your range to have dimensions in one place, whether row or column. Fetch your range again after you've made the adjustments.
Date/time not in the Cube format
If you are receiving an error message about dates and times, review your time dimension rows and columns and any other dates used across your range. While spreadsheets support many different date formats and often automatically update values they recognize as dates, the Cube Spreadsheet App recognizes dates and times in the following formats.
If you find that your spreadsheet is updating your Time dimension members automatically, use a single quote in front of the date to force your spreadsheet to recognize it as a text string instead of a date. For example, Jan-22 would be written as ‘Jan-22.
Typos
If you receive an error about not finding valid dimensions when attempting to fetch data, it's likely because one or more dimension names contain typos or are not recognized.
Click Validate under Analyze in the Spreadsheet App to catch, update, or ignore any dimensions and then fetch again.
Range includes unintended cells
When columns/rows are hidden on your spreadsheet, it can be easy to accidentally select a larger range than you intend.
To account for hidden columns or rows, you can create multiple ranges or add them as attributes.
Dataset requested was too large
We are continuously improving our internal processes and features, but there are times when you may be trying to select a range that is too data-heavy to process successfully, especially if your Cube is carrying a lot of data. If this is an issue, you'll see a message that the requested dataset was too large, with a recommendation to reduce the range and try again.
In this case, create multiple ranges to fetch one at a time. By running your ranges in smaller batches, the data will fetch and publish much more quickly.
Still having issues selecting a range?
If you still encounter errors after trying the steps above, log a ticket with Customer Support or email support@cubesoftware.com.