Today, the Family and Person tables (entities) each have their own measures, relationships, and associated fact tables for both role approvals and function assignments. This makes it very difficult to run intuitive queries like "# of approved volunteer families" or "# of people assigned", because each of those measures has to account for both subsets of data (Family-based and Person-based) and then merge those numbers together.
Instead, it would be better if family and individual measures can be consolidated, with only a single relationship/fact table joining the family/person combination to a role (for approvals) or an arrangement (for assignments).
For now, let's keep the ideas & brainstorming around the requirements and specification in this issue. As part of the eventual PR for implementation, then, we will want to actually record the documentation (e.g., in the wiki).
Today, the Family and Person tables (entities) each have their own measures, relationships, and associated fact tables for both role approvals and function assignments. This makes it very difficult to run intuitive queries like "# of approved volunteer families" or "# of people assigned", because each of those measures has to account for both subsets of data (Family-based and Person-based) and then merge those numbers together.
Instead, it would be better if family and individual measures can be consolidated, with only a single relationship/fact table joining the family/person combination to a role (for approvals) or an arrangement (for assignments).
For now, let's keep the ideas & brainstorming around the requirements and specification in this issue. As part of the eventual PR for implementation, then, we will want to actually record the documentation (e.g., in the wiki).