topic View SQL for an insight limitations in Dashboards & Analytics Discussions

View SQL for an insight limitations

RADSr — Tue, 14 Jun 2022 18:30:18 GMT

I have an aggregate table insight, it has measures, I'd like to view the SQL representation of the Incorta query but instead of that I view the message ( screen cap below ) helpfully telling me I must be using a listing or aggregate table and have at least one measure.

What other limitations are there to being able to view SQL?

Re: View SQL for an insight limitations

JoeM — Wed, 15 Jun 2022 19:32:04 GMT

@RADSr - I was able to get in front of the right expert and they mentioned the following reasons:

It has to be a listing table or an aggregated table
All measures must have a proper query plan, one can validate using the query plan button
Improper filters
Empty measures
Empty/invalid formulas/columns
Unsupported filters
Mixing aggregates and non aggregates in measure formulas is not allowed