For this scenario, I would create a [Join](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views) view over the **people_data** view and **pv_time_dim** view on effective_date and calendar_date fields. This way, the values for effective_date will be obtained from the time_dim view.
If I have to hardcode the values to the effective_date field, then, I would leverage the [Branch Pruning](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/automatic_simplification_of_queries/removing_redundant_branches_of_queries_partitioned_unions#removing-redundant-branches-of-queries-partitioned-unions) Optimization offered by Denodo Platform which allows the query to filter the results based **only** on the people_data view.
Additionally, if you still need help and if you are a valid Support User, you may open a [Support Case](https://support.denodo.com/) at the Denodo Support Site and the Support Team will help you.
Hope this helps!