The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
AndreaF
10 months agoContributor III
Zero cells count
Hi, I wanted to ask about the OneStream guidelines for an acceptable proportion of zero cells. I remember reading something a few years back about a suggested maximum proportion, but I can't find tha...
chul
OneStream Employee
10 months agoHi Andrea, It sounds like you're taking the right steps to minimize zeros in the database. I don't believe we have a specific percentage recommendation as we know each application is unique and there are many use cases where loading or calculating zeros is necessary. The more impactful stat relating to performance is the largest data unit size. From there, you can analyze the amount of zero cells and determine if they're required. That being said, in the absence of knowing your customer requirements, 20% seems a tad high but if your data unit sizes are good and performance is acceptable, you can focus on other parts of the build.
Related Content
- 3 years ago
- 2 years ago