Using Cube's Sheets or Excel add-on, you have the ability to publish data to Cube directly from your spreadsheet. But some dimension types can't be published, so they're excluded from requests.
These dimension types are:
Parent dimensions
If a dimension has members - or "children" - that sit beneath it in the hierarchy, it is considered a Parent dimension. Because its value is calculated by summing the child values, unique values cannot be published directly to parent dimensions.
Learn more about the Cube dimension hierarchy.
Formula dimensions
A Formula dimension is a dimension where the value is calculated based on a formula set up in Cube. Because its calculation is based on the logic of the formula itself and the dimension(s) that it references, unique values cannot be published directly to formula dimensions.
Learn more about formulas in Cube.
Tag dimensions
A Tag dimension is a dimension where the value is calculated based on a tag applied to one or more dimensions in Cube. Because the calculation is based on the roll-up of the tagged dimension(s) referenced, unique values cannot be published directly to tag dimensions.
Learn more about using tags.
Write-protected scenarios
A Write-protected scenario is a Scenario dimension that a write-protection setting has been applied to.
There are two types, each having its unique restriction:
- Block
- No data may be published to scenarios with this restriction
- Actuals
- Data can only be published to Account dimensions that are not mapped to a source system (e.g. Quickbooks, NetSuite, or Salesforce)
Learn more about applying write protection to scenarios.
Write-protected ranges
Additionally, write protection can be applied to a specific range in the Spreadsheet add-on to limit publishing entirely.
Editing your range in the Spreadsheet add-on and unchecking Allow Publishing Data effectively disables the ability to write to your Cube for the selected range.
Clicking Enable publishing on this range will bring you directly to the settings to turn the publish function back on.
Similarly, the Allow Fetching Data range option stops Cube from fetching from Cube and effectively writing new data to your sheet from Cube.