Values or formulas not inserted
There is a limit to the number of dimensions the Insert Block and Insert Value tasks can support when inserting a block of data or values. The maximum number of dimensions that the tasks can support varies depending on which task is used and the writability of the data source, see this table:
Data source type | Insert Block supports | Insert value supports |
---|---|---|
Read-only | 14 or fewer dimensions | 29 or fewer dimensions |
Read-write | 14 or fewer dimensions | 14 or fewer dimensions |
If a dataset exceeds the supported number of dimensions, an MPCData (or CBData) formula is not inserted, and no value is displayed. There is no workaround for this issue.
For more information, see Cell formula constraints.