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 to, so they're excluded from publish requests. These dimension types are:
- Parent Dimensions
- Formula Dimensions
- Tag Dimensions
- Write-Protected Scenario Dimensions
I. Parent Dimensions
What is a Parent Dimension?
If a dimension has any members - or "children" - that sit beneath it in the hierarchy, it is considered a Parent Dimension.
Why can't I publish to Parent Dimensions?
A Parent Dimension's value is calculated by summing the values of its members (Dimension Member 1 -> 3 in the screenshot above), meaning that unique values cannot be associated with Parent Dimensions.
II. Formula Dimensions
What is a Formula Dimension?
A Formula Dimension is a dimension where the value is calculated based on a formula that's been set up in Cube.
Why can't I publish to Formula Dimensions?
A Formula Dimension's value is a calculation based on the logic of the formula itself and the dimension(s) that it references. Therefore, unique values cannot be associated with Formula Dimensions.
III. Tag Dimensions
What is a Tag Dimension?
A Tag Dimension is a dimension where the value is calculated based on a tag that's been set up in Cube.
Why can't I publish to Tag Dimensions?
A Tag Dimension's value is a calculation based on the rollup of the tagged dimension(s) that it references. Therefore, unique values cannot be associated with Tag Dimensions.
IV. Write-Protected Scenarios
What is a Write-Protected Scenario?
A Write-Protected Scenario is a Scenario dimension that a Write-Protection has been applied. There are 2 types of Write-Protected Scenarios, with each having its own unique restriction:
- No data may be published to scenarios with this restriction
- Data can only be published to Account dimensions that are not mapped to a source system (e.g. Quickbooks, NetSuite, or Salesforce)
Note: Editing your range in the 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.
Why can't I publish to Write-Protected Scenarios?
If you could, then they wouldn't be Write-Protected!