Cube Sheet Size Limits
Cube Sheet Size Limits
Cube sheets have
limits for data, rows, and cells. Users will receive a warning message if they attempt
to load a cube sheet that exceeds any limit. - Size:5 gigabytes per version
- Rows:15 thousand rows
- Cells:75 million cells
Row and cell limits are
based on the current view of the sheet which is a combination of elements selected
for the columns, rows, and dimensions.
Cube Sheet Size
Cube sheets have a 5 GB size limit per versions. You can monitor your cube
sheets size on the cube sheet Summary page (Modeling > Sheets). If the cube sheet is
above 50% capacity in one or more versions, you will see a warning message with a
percentage on the Summary page.Cube Sheet Size
- Warning on the Summary page for cube sheets that exceed 5 GB:This cube sheet has too much data to display in one or more versions."
- Warning when attempting to view a cube sheet that exceeds 5 GB:"This sheet has too much data to display."
Decrease Cube Sheet Size
- Reduce the number of years in the version.
- Reduce the number of accounts or dimensions available on the cube.
- Split the cube into two smaller cube sheets.
Cube Sheet Rows & Cells
Cube sheets
have a 15 thousand row limit and a 75 million cell based limit to restrict the amount of
viewable data for the "current view" of the cube sheet which is a combination of
elements (accounts, levels, dimensions, and time periods
) selected for the
columns, rows, and dimensions. Decrease Cube Sheet Rows and Cells
- Enable "suppress rows if all zeros or blank"
- Create cube restrictions
- Use filter to adjust the Initial View for the sheet