When using Cube's Sheets or Excel Apps, you have the ability to publish data to Cube directly from your spreadsheet. But some dimension members can't be published to because they don't store values, so they're excluded from requests.
These dimension types are:
- Parent dimension members
- Formula dimension members
- Tag dimension members
- Write-protected scenario dimension members
Parent dimension members
If a dimension member has children that sit beneath it in the hierarchy, it is considered a Parent dimension. Because its value is calculated by summing the children's values, unique values cannot be published directly to parents.
Learn more about the Cube dimension hierarchy.
Formula dimension members
A Formula dimension member calculates its value based on a formula set up in Cube. Because its calculation is based on the logic of the formula itself and the dimension member(s) that it references, unique values cannot be published directly to the formula dimension member.
Learn more about formulas in Cube.
Tag dimension members
A Tag dimension member calculates its value by summing one or more referenced dimension members in the Cube. Because the calculation is based on the rollup of the tagged dimension member(s) referenced, unique values cannot be published directly to tags.
Learn more about using tags.
Write-protected scenarios
A Write-protected scenario is a Scenario dimension member that has write-protection settings applied.
There are two types, each having its unique restriction:
- Block
- No data may be published to scenario dimension members with this restriction
- Actuals
- Data can only be published to Account dimension members that are not mapped to a source system (e.g. Quickbooks, NetSuite, or Salesforce) if the publisher is an Admin or has edit data access permissions for that dimension member.
Learn more about applying write protection to scenarios.
Write-protected ranges
Additionally, write protection can be applied to a specific range in the Spreadsheet App to limit publishing.
Edit your range in the Spreadsheet App and uncheck Allow Publishing Data to effectively disable the ability to write to your Cube for the selected range.
Click Enable publishing on this range to go to the settings and turn the publishing function back on.
Similarly, the Allow Fetching Data range option stops Cube from fetching and writing new data to your sheet.