Cell formula constraints

Before adding any data source, be aware there is a limitation on the number of dimensions the template can support. Users will create datasets for the template that are based on the data sources created, and these data sources can impact the tasks performed by the template. The maximum number of dimensions the cell-based workbook supports when inserting MPCData formulas, using the Insert Block and Insert Value tasks, depends on which task is used as well as the writability of the data source.

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 user attempts to insert a block of data with a dataset that includes 15 or more dimensions, an error message is displayed to indicate there are too many dimensions in the dataset. In this case, dimension members are inserted but MPCData formulas are not inserted, for example, no values are displayed.
• If an application has 15-29 dimensions, you can add the missing values using the Insert Value task IF the data source is read-only. In this case, the formulas inserted are CBData formulas, not MPCData formulas. See "Using the Cell-Based Workbook". Consequently, there is an impact on performance for these cells and writeback is not supported.

Neither MPCData formulas nor CBData formulas can be inserted if a dataset includes 30 or more dimensions.