Hi,
I get "Generated SQL/MDX: No SQL/MDX available" message when i try to view the SQL generate by report studio for my report... any idea why it's happening?
Thanks.
you have too many errors in the query that the query engine can not resolve for generating a sql.
try removing one query item at a time and see where it breaks.
The point is that report studio is actually generating any SQL because return records...
I have noticed that on query subjects with many members and filters sometimes generating SQL/MDX fails even if the report is running fine. Depending on what your trying to do delete all filters and then try, its not perfect but at least you get basic sql with joins