SAP Knowledge Base Article - Public

3559633 - Error "Sorry, we couldn't carry out your data entry because all leaf member combinations for this cell are excluded by filters....."

Symptom

When inputting data and clicking on process Data, you get the error 
"Sorry, we couldn't carry out your data entry because all leaf member combinations for this cell are excluded by filters. Please check any advanced filters or restricted members on the account or cross calculation dimensions or contact the story owner. " 

Environment

SAP Analytics Cloud 1.0

Cause

The error message is as expected. In fact, if you click the "Learn more..." link on the error message, you will be navigated to the help document explaining the possible scenarios that you can run into the error.

Below is one example:

  • In your story, you have a calculation of restricted measures .
  • In the calculation, you restricts the Version to one member - "Actual".
  • In the table of the Story, you set the filter to another member of Version - "Budget". 
  • This setting makes the Version filter conflicts and the error message displays when you try to input data.

Resolution

To resolve the issue, remove the conflict.

For the example mentioned, either modify the restricted measure to restrict the Version on "Budget", or change the Version filter from the table to "Actual" in your Story.

Keywords

KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem

Product

SAP Analytics Cloud 1.0