Troubleshoot Dynamic Ranges That Stop Adding New Accounts

Check your range layout so Cube can insert new accounts and other dimension members automatically when you fetch.

1. Open the Spreadsheet App.
2. Select or build your range.
3. Confirm Auto add child dimensions is turned on for the range. 
4. Confirm the parent dimension member is in the row headers of the range.
5. Confirm at least one of its children is visible in the row directly above the parent.
6. Unhide any hidden rows directly above the parent. 
7. Select Fetch Data. 
8. If new members still don’t appear, highlight the range, including all row and column headers.
9. Select Select, then Select Range.
10. Select Fetch Data.

Note: Cube inserts new members only when auto-add is on, the parent is in the rows, and a child is visible directly above the parent. 

Note: If new members fall into your range filters, the existing range can’t fetch them. Reselect the range to include them.

What updates automatically

• Cube inserts missing child members into the range.
• The range expands to include the new rows.

Related articles

• Automatically Insert Missing Child Rows with Dynamic Ranges
• Set range permissions and settings in the Spreadsheet App
• Best practices for fetching Cube data to your spreadsheets
• Expand and Collapse Dimensions
• Build a range