Hi db
Yes - the member filter I have for the first dynamic column is E#TopEntity.base.Where (Text8 Contains [DP_|WFYear|Q4]), and for the second its the same syntax, except the Text8 is AQ_|WFYear|Q4. The second dynamic column is being suppressed since there are no entities with the AQ_2023Q4 text value. However the first column where the member filter has the specific entity is repeated in its place. I also have the primary dimension type to be Entity in Nested Member Expansion 2 for all of the columns - could that be the source of the issue?
Here's a screenshot of the cube view - the entity that's blacked out is the one I have in the first column's member filter. This is where both dynamic columns do not find text values that match the member filter.
The result for WFSubPeriod would be "M12" if the WF period is 2023M12, right?
Hmm, is that UD8 active on these columns? I'm wondering if that is what is causing the entity to appear where it otherwise shouldn't. That said, I cannot think of a way to have a blank column appear only when there is not data using standard member expansions. Can you do a blank column at all times as a spacer between where the entity lists would be?
For the |WFSubPeriod| you are correct, it would be M12 if you are using monthly workflows. You might need a simple XFBRString to help convert from M12 to Q4.
