How to manage cube file sizes by reducing model data in Sisense [Linux]
This article provides a solution for users who need to manage their cube file sizes in a Sisense environment by keeping the cube files while removing the data within them. This can be useful.
Step-by-Step Guide:
- Access the Cube Management Interface:
- Navigate to the Sisense platform and log in with your credentials.
- Access the data section from the main menu.
- Build Cubes with Sample Data:
- Select the cube you wish to modify.
- Choose the option to rebuild the cube.
- Use the 'Sample Data' feature to specify the number of rows. For instance, you can set it to 100 rows. This will populate only a small portion of the data, thereby effectively reducing the file size.
- Ensure Data Reduction:
- After setting the sample data limit, proceed with building the cube.
- Verify the cube size post-process to ensure that only the limited data has been retained, maintaining the cube's structure without the full data set.
Conclusion:
By following these instructions, you will successfully manage cube file sizes and maintain the integrity of your cube structures in a non-production environment.
References/Related Content
- Integrity Checks: Perform integrity checks on the cube after rebuilding to ensure that the structure is intact and operational.
- Backup Before Changes: Although the cube structure should remain unaffected, consider backing up any necessary data before modifications.
Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.
Published 06-09-2025
