Unknown Error while Importing a Subset

Highlighted
Frequent Contributor

Unknown Error while Importing a Subset

Hi!

There is a very simple import where the end-user checks a boolean for the items they want to keep in a subset and then runs an action that takes the boolean value to the list and updates the subset. Clean and straight. 

However, user is not getting a peculiar error. Can you help me understand the reason behind this error:

ankit_cheeni_0-1603967122451.png

Just to be clear, the user was adding only 3 items in the subset and not the cell count value being shown in the error.

10 REPLIES 10
Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@ankit_cheeni 

 

Usually that happens when the cell count of any particular line item crosses 2.1-2.2 billion mark. Can you please check if the activation of three list items in a subset makes any line item (which is dimensioned by that subset) go beyond that mark.

 

Misbah

Highlighted
Frequent Contributor

Re: Unknown Error while Importing a Subset

@Misbah Thank you! that is new information for me. However, all the modules have a cell count of less than 2.2 billion so there cannot be a line item that heavy. Could there be any other reason that I can check?

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@ankit_cheeni 

 

It is because when you add members to that subset, the result will be greater than the 2.177 billion cells in a line item and the system is preventing you from doing that.

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@ankit_cheeni 

 

As @Misbah stated, your line item is too big with dimensionality which causes the cell count of that line item to be greater than 2^31-1 (roughly 2.177 billion cells).  Anaplan stores data (at the most detailed level) in blocks and we have 3 types of blocks: Time, Version, and Custom Lists.  That block can't be bigger than the above threshold for a particular line item.

 

2020-10-29_07-25-10.png

 

In the above picture, the data that is stored is in green (SKU by City by Channel). 

 

Now, you may have seen cell calculations larger than 2.177 billion cells which can be explained in a couple different ways:

  • that cell count is aggregation of data, so if you turn Summaries off, that cell count will go down (remember, the threshold is at the most detailed or detailed "block" of data)
  • if the line item is using Time, again, the cell count is the aggregation of all time and that threshold is at the most granular level of time (be it at day, week, month, etc.).  What this means, is the cell count of the most granular time period (day, week, month) has a limit of 2.177 billion cells, and since it is Time, the threshold resets for every granular "block",  And since Versions are similar to Time, the same thresholds apply (Actual, Plan, Budget).
  • The above bullet also helps understand why using "Real" time is so important and beneficial.

So, to solve your issue, the cell count for that line item is too big and you need to remove dimensionality from it.

 

Hope this explains your issue.

 

Rob

 

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@rob_marshall 

 

Great info. something new to me especially about Time and Versions. By the way 2^31-1 : What is the figure? 

 

 

 

 

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@Misbah 

 

That figure is the figure @ankit_cheeni is hitting, roughly 2.177 billion cells per line item.

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@rob_marshall 

 

What I actually meant to ask was about the background/origin/genesis of that figure. Is it 2^31-1 for every block? I presume the answer would be yes

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@Misbah 

 

Honestly, I don't know the "why" and how Michael came up with that exact threshold, there has to be some kind math behind it.  And yes, it is at the block level.  So remember, you have blocks for Time, Version, and Custom Lists.  I say this because I can get more cells using real time and real versions than using "fake" versions or "fake" time because the fake time and fake versions go into the Custom List block.

 

Rob

Highlighted
Master Anaplanner/Community Boss

Re: Unknown Error while Importing a Subset

@rob_marshall 

 

Awesome:)

 

To Version or Not to Version - a point to be noted against custom version.