Dimension filters from Secondary
do change (filter out) Marks on a view.
It's better to have the required Dimensions in Primary,
and of course they should be all "domain complete"
(contain all unique values -- as your CALENDAR.Date).
One can easily build such a "Scaffold" datasource in Excel
using a distinct Sheet for every (single-column) Dimension,
together with a special [Link ID] == 1 field for a cross-join.
Please find the attached.
Hope it helps.
UNION_YF.twbx 68.5 KB