Discussion (2)1
Log in or sign up to continue

In MDX, you need to include "on AXIS" where AXIS can be 0,1,2,rows,columns. I think it would be rare to find this text in an SQL query.

Is calling %DeepSee.ResultSet.%PrepareMDX() and checking the status an option? If this succeeds, you are ready to Execute and if it does not, then you can proceed with SQL.

Thank you.

I thought about using prepare, but I'm searching for solutions without it.

"ON AXIS" should work