cancel
Showing results for 
Search instead for 
Did you mean: 

View SQL for an insight limitations

RADSr
Partner
Partner

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?   

 

RADSr_0-1655231179696.png

 

1 REPLY 1

JoeM
Community Manager
Community Manager

@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