Planning Table Level Advance Member Filter not working as expected when data limit exceeds for table
Summary:
In the custom table configured, we have applied a advance member filter for Customer to "Replace with members at level Channel where Final Discontinuation Date Is not null" as we want to include only the Channels which have Final Discontinuation Date Is not null. Below are the results:
1. For a single item the advance filter works as expected, show correct output in UI. Using Publish Plan process also it gives correct results.
2. When the all the items are included, the table data limit is exceeded and gives following error: "You cant view this table because the amount of data exceeds the maximum allowed. the maximum allowed is 250,000 cells. (MSC-2806410)". So we use Publish Plan process to export the table. But the customer filter does not work as expected as it includes all the channels.