I have a table with two unrelated repeated structures tied to common key and using this table to create an explore.
How am I building my explore:
With this I have an explore with two different sets of metrics and dims and few common dimensions coming from outer table.
Issue:
Often times, consumer mix the dims and measures of these two structs and complain that it is not working as expected when they were not supposed to use them together. I have the metrics and dims separated into two buckets using view_label but looks like that is not enough.
Is there anything we can do to limit users or put warning message when they mix dims and measure from different views?
Building a separate explore is not an option