Unknown Error while Importing a Subset

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.

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

All comments

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

ankit_cheeni

@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?

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

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.

@rob_marshall

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

@Misbah

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

@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

@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

ankit_cheeni

@rob_marshall @Misbah Thank you very much for your responses. They are very insightful and I did find a line item that will breach the threshold.

Cheers!