in datapartitions and stored query it is possible to define an where clause. Then using OR conditions with relations to other tables, service desk detect and report a cartesian product error. It is possible to avoid a cartesian product error. Negate the condition and use the AND operator. But this statements are much slower as the initial condition. These statements creates realy cartesian products.
it should be possible to set an option to disable the 'cartesian product' check. The customer can this decide at your own risk.