I'm facing an m2m error on one of my widgets. From the Analyze Widget JAQL view, I can see the issue is that inventory.tenant_id and vendor.tenant_id are not connected directly to tenant.id. The problem is that they are joined directly in the elasticube model. Is there a trick to force the inventory and vendor tenant_ids to the tenant table?
Curiously, if I remove EITHER the vendor fields or cost center fields from the widget, the error goes away...
Hello cglowe ,
A pleasure to e-meet you, I'm Benji from Paldi Solutions- a gold-certified Sisense partner.
One important thing to know is that the Sisense query engine looks for the shortest paths when querying the ElastiCube.
I haven't looked at your data model but at the links below you can find some information on how to solve these kinds of issues:
https://support.sisense.com/kb/en/article/key-table-store-data-relationships-between-primary-key-values
https://support.sisense.com/kb/en/article/formulas-creating-random-paths-between-dimensions
https://support.sisense.com/kb/en/article/not-all-dimensions-relate-to-all-facts
