Showing results for 
Search instead for 
Did you mean: 

Unwanted Join Path

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


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:


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

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]