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