Data unit calculation
Hi all,
How do we calculate Data Unit in OneStream ? I know that the largest Data Units should never be above 2-3 million intersections. The sweet spot for OneStream is between 250,000 and 500,000 ...
Forum Discussion
Replying here instead of direct PM since it's the same question.
As Henning stated, you will only get a good feel on the # of records in a data unit by performing an import. Trying to size based on multiplying # of members in each dimension is impractical as it is unlikely that you will have values for every possible combination of members from each dimension.
And to add to what Henning stated, there are more than a few dimensions that you shouldn't use for attempting to calculate the max possible # of records. From your table, I would remove Scenario, Entity, Consolidation, View, Year & period (assumed same time dimension) and Currency (assumed it's handled in Cons dimension).