Issues with publishing data can spring up for various reasons. Below are the most common error messages when attempting to publish data and solutions to overcome them.
Error publishing data
You may run into an error if a publish is in progress and you attempt to publish again. This could be a publish you've initiated or one of your team members, and will likely take a minute or two to complete. Try publishing again in a few minutes.
Cube will confirm that the publish is complete with a message in your Spreadsheet App, and you'll be able to see the recent publish in the audit trail.
No data for publishing
This issue can occur when the sheet has become disconnected from Cube, and Cube can no longer find writable cells in the range.
To resolve this, recreate your sheet and range in a new tab with the same cells, validate the range, then try to publish again.
Publish button is disabled
Not every publishing problem produces an error message. If the Publish button is greyed out, Cube has caught the problem before you could publish. Hover over the button to see the reason.
Dimension members that are parents, tags, formulas, or those with write protection cannot be published to, and the Spreadsheet App will block your ability to publish until publishable dimension members are selected in your range.
Review the rows, columns, and filters that make up your range and ensure they have child dimension members selected. Sometimes, this error can occur when the wrong filters have been applied.
Learn more about which dimensions cannot be published to.
Another common cause is a multi-select filter. If any filter in your range has more than one dimension member selected, the tooltip reads:
Publishing is not available when filters have multiple members selected. Narrow each filter to a single member to publish.
Publishing writes to one specific intersection of your dimensions, so each filter must hold exactly one member. Narrow each multi-select filter to a single member and the button becomes available again. See Publish data to Cube for the full explanation.
Still having issues publishing?
If you’re still encountering problems after trying the steps above, log a ticket with the Customer Support team or email support@cubesoftware.com.