Hi @moonlms_.
The clams and membership tables are kept separately. They are combined dynamically within VA through a series of transformations that use aggregated data source and data source join. It's like a multi-step calculation. We don't have any parameterized calculations in this example, but if we had, we would be able to verify that changes on the parameter value would be cascaded through the steps, showing that this is truly dynamic.
I agree with you that the member month calculation requires selecting upfront all categories from the membership table, but how often do we foresee new categories/dimensions being added to this table? it's not a rhetoric question 🙂
... View more