cancel
Showing results for 
Search instead for 
Did you mean: 

Unwanted Join Path

cglowe
8 - Cloud Apps
8 - Cloud Apps

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...

1 REPLY 1

Benji_PaldiTeam
11 - Data Pipeline
11 - Data Pipeline

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-val...

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

 

Feel free to reach out of you have further questions, we're always happy to help (: 
Paldi Solutions - Number #1 Sisense Plugins Developer