I am using 2 dimensions and 1 measure column in my report.The query generating by report is showing one more measure along with our selected measure. On top of that, measure is ranked and restricted for 1000 records.
Why is unselected column is showing in Query Log SQL? And how it is ranked and restricted for 1000 records?
Please suggest a solution or work around for this?
I assume it might be row_wid to get your required counts....that may not impact on your data.
if you are not convinced try to share both logical and physical query